Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error connecting DataSet with SQL Server

Status
Not open for further replies.

rnooraei

Programmer
Apr 5, 2005
74
CA
Hi
Any suggestion for this error message. I got this error message when I did migration from my access database to SQL Server.
Thanks


Line 3: Incorrect syntax near '?'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 3: Incorrect syntax near '?'.

Source Error:


Line 2374: End If
Line 2375: Dim dataTable As BarDataSet.tblDeptDivSectsDataTable = New BarDataSet.tblDeptDivSectsDataTable
Line 2376: Me.Adapter.Fill(dataTable)
Line 2377: Return dataTable
Line 2378: End Function

 
Sql Server does not use "?", Access does..
show your original query so that we can help you convert it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top