Sybase connect string gives me SQL Server error msg

Using a user dsn with Sybase 11 driver, I created a pass through query. When
I run it, I get the following error msg:

"[INTERSOLV][ODBC SQL Server driver][SQL Server]Incorrect syntax near ';'
(#102)"

Here's the sql:

"SELECT AccountId FROM dbo_Accounts;"

Here's the connect string placed in the query when I build the connect string:


"ODBC;DSN=DSN_NAME;SRVR=SERVERNAME;DB=xy_abcde;UID=joesmith; PWD=pwd"

Thanks,

Bill

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200711/1