SQL error: Syntax error near 'DECLARE'

[#1]

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

[#2]

Dave

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

-Raghu.

[#3]

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