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/For...ccess/200711/1