SQL error: ODBC SQL server driver Incorrect syntax near',' ...

[lmonincx]

Hi,

I tried to connect to a sql server through oledb using odbc connector trying to read a table, it came back with the attached error.

checking the script resulted in no errors and after clicking on ok of the error, table seemed to be filled completly.

Any idea what is causing this issue, could it be content in sql not covered in odbc?

Trying to use the ODBC connection only did not work either, we need to use teh OLE db ODBC connector.

Any help or suggestions is appreciated.

Kind regards,

Linda Monincx

[Anonymous]

Hi Linda,

May be easier to debug if we coudl see the whole script portion, including the SQL Statement?

Cheers.

Ad.