topic SQL error: Syntax error near 'DECLARE' in QlikView

SQL error: Syntax error near 'DECLARE'

Thu, 11 Jun 2009 09:08:05 GMT

I have no idea why this error message occurs because I'm only running the following 2 lines of code in the load script:

CONNECT TO [Provider=ASAProv.90;Eng=abc1aCCCDbServer;Uid=Username;Pwd=Password; Links=tcpip(Host=10.1.0.27);];

SQL SELECT * FROM sysobjects;

The error occurs on the second line, so the connection appears to be established just fine.

Thanks in advance for any help,
Dave

Thu, 11 Jun 2009 14:08:51 GMT

Dave

Same query i have used. I don't get any error, database connection made through OLEDB provider for sql server.

-Raghu.

Fri, 12 Jun 2009 10:44:51 GMT

Thanks for the reply Raghu.

It works fine for me too on SQL Server. I believe this is something specific to Adaptive Server Anywhere, which is the driver I'm using.

Cheers,

Dave