|
|
|
|
|
| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Connect to Sybase |
|
From: |
Bill |
|
Date: |
5/9/2000 5:30:47 PM |
|
IP: |
209.49.247.194 |
We have purchased the Sybase OLE DB cd-rom. I have installed the ole component. I am able to connect using our existing ODBC DSN in ADODB.connection, but have
not connected using the DSN-less provider syntax.
Question:
What is the ADODB.recordset
or ADODB.connection DSN-less syntax? I have tried many including:
oConn.Open "Sybase ASE OLE DB Provider=FCExxxole;SRVR=FCEPROD;DB=FCErpts","userx","passwordx"
----and----
R.Open "SELECT ldr_entity_id as Entity FROM FCErptsource..entity","DRIVER=Sybase ASE OLE DB Provider;SRVR=FCExxxx;DB=FCErpts;UID=userx;PWD=;",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> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
