Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Connecting to Sybase 11.x with ADO

I can connect with an ODBC DSN in my ADO Connection or Recordset, but if I
try a dsn-less ADO syntax, I get an error.

Off of the c:\SQL10 folder is a \ole folder, after I installed the Sybase
ASE OLE DB Provider software, purchased from Sybase.
The OLE Administrator created a dsn called sybase.
----
Code example:
oConn.Open "Sybase ASE OLE DB Provider=sybase;SRVR=FCExxxx;DB=FCErpts","user","(password
goes here)"
--OR--
R.Open "SELECT ldr_entity_id as Entity FROM FCErptsource..entity","DRIVER=Sybase
ASE OLE DB Provider;SRVR=FCEPROD;DB=FCErpts;UID=qspt;PWD=(password goes here);",adOpenStatic

--------------------Error------------------
<p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial" size=2>error
'80004005'</font>
<p>
<font face="Arial" size=2>[Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified</font>
<p>
<font face="Arial" size=2>/Default.asp</font><font face="Arial" size=2>,
line 61</font>
[1136 byte] By [Bill] at [2007-11-9 15:35:26]