topic SQL error: ODBC SQL server driver Incorrect syntax near',' ... in QlikView https://community.qlik.com/t5/QlikView/SQL-error-ODBC-SQL-server-driver-Incorrect-syntax-near/m-p/233229#M84769 <HTML><HEAD></HEAD><BODY><P>Hi Linda,</P><P>May be easier to debug if we coudl see the whole script portion, including the SQL Statement?</P><P>Cheers.</P><P>Ad.</P></BODY></HTML> Fri, 15 Oct 2010 16:41:14 GMT Anonymous 2010-10-15T16:41:14Z SQL error: ODBC SQL server driver Incorrect syntax near',' ... https://community.qlik.com/t5/QlikView/SQL-error-ODBC-SQL-server-driver-Incorrect-syntax-near/m-p/233228#M84768 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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.</P><P>checking the script resulted in no errors and after clicking on ok of the error, table seemed to be filled completly.</P><P>Any idea what is causing this issue, could it be content in sql not covered in odbc?</P><P>Trying to use the ODBC connection only did not work either, we need to use teh OLE db ODBC connector.</P><P>Any help or suggestions is appreciated.</P><P>Kind regards,</P><P>Linda Monincx</P></BODY></HTML> Mon, 11 Oct 2010 08:59:25 GMT https://community.qlik.com/t5/QlikView/SQL-error-ODBC-SQL-server-driver-Incorrect-syntax-near/m-p/233228#M84768 lmonincx 2010-10-11T08:59:25Z SQL error: ODBC SQL server driver Incorrect syntax near',' ... https://community.qlik.com/t5/QlikView/SQL-error-ODBC-SQL-server-driver-Incorrect-syntax-near/m-p/233229#M84769 <HTML><HEAD></HEAD><BODY><P>Hi Linda,</P><P>May be easier to debug if we coudl see the whole script portion, including the SQL Statement?</P><P>Cheers.</P><P>Ad.</P></BODY></HTML> Fri, 15 Oct 2010 16:41:14 GMT https://community.qlik.com/t5/QlikView/SQL-error-ODBC-SQL-server-driver-Incorrect-syntax-near/m-p/233229#M84769 Anonymous 2010-10-15T16:41:14Z