Connecting to Sybase 11.x with ADO
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>

