都试了,还是不可以,我也装了ODBC。NET,MDAC2。6 ,可是 USING Micosoft.Data.Odbc 说找不到这个DATA空间
先要在工程中添加ODBC.NET的引用
添加引用 Micosoft.Data.Odbc.dll
ODBC Driver for Sybase If using the Sybase System 12 (or 12.5) Enterprise Open Client ODBC DriveroConn.Open "Driver={SYBASE ASE ODBC Driver};" & _ "Srvr=myServerName;" & _ "Uid=myUsername;" & _ "Pwd=myPassword"
If using the Sybase System 11 ODBC DriveroConn.Open "Driver={SYBASE SYSTEM 11};" & _ "Srvr=myServerName;" & _ "Uid=myUsername;" & _ "Pwd=myPassword"
If using the Intersolv 3.10 Sybase ODBC DriveroConn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};" & _ "Srvr=myServerName;" & _ "Uid=myUsername;" & _ "Pwd=myPassword" For more information, see: Sybase System 10 ODBC Driver Reference GuideTo view Microsoft KB articles related to ODBC Driver for Sybase, click here ODBC Driver for Sybase SQL Anywhere oConn.Open "ODBC; Driver=Sybase SQL Anywhere 5.0;" & _ "DefaultDir=c:\dbpath\;" & _ "Dbf=c:\sqlany50\mydb.db;" & _ "Uid=myUsername;" & _ "Pwd=myPassword;" & _ "Dsn=""""" Note: Including the DSN tag with a null string is absolutely critical or else you get the dreaded -7778 error.
OLE DB Provider for Sybase Adaptive Server Anywhere (ASA) oConn.Open "Provider=ASAProv;" & _ "Data source=myASA" For more information, see: ASA Programming Interfaces Guide and ASA User's Guide OLE DB Provider for Sybase Adaptive Server Enterprise (ASE) oConn.Open "Provider=Sybase ASE OLE DB Provider;" & _ "Data source=myASEServer" ' Or oConn.Open "Provider=Sybase.ASEOLEDBProvider;" & _ "Srvr=myASEServer,5000;" & _ "Catalog=myDBName;" & _ "User Id=myUserName;" & _ "Password=myUserPassword" Where: - The Sybase ASE OLE DB provider from the Sybase 12.5 client CD - 5000 is the port number for Sybase.Note: The Open Client 12 Sybase OLE DB Provider fails to work without creating a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.Note: With Open Client 12.5, the server port number feature finally works, allowing fully qualified network connection strings to be used without defining any .IDS Data Source files.
USING Micosoft.Data.Odbc
说找不到这个DATA空间
Micosoft.Data.Odbc.dll
If using the Sybase System 12 (or 12.5) Enterprise Open Client ODBC DriveroConn.Open "Driver={SYBASE ASE ODBC Driver};" & _
"Srvr=myServerName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
If using the Sybase System 11 ODBC DriveroConn.Open "Driver={SYBASE SYSTEM 11};" & _
"Srvr=myServerName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
If using the Intersolv 3.10 Sybase ODBC DriveroConn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};" & _
"Srvr=myServerName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
For more information, see: Sybase System 10 ODBC Driver Reference GuideTo view Microsoft KB articles related to ODBC Driver for Sybase, click here ODBC Driver for Sybase SQL Anywhere
oConn.Open "ODBC; Driver=Sybase SQL Anywhere 5.0;" & _
"DefaultDir=c:\dbpath\;" & _
"Dbf=c:\sqlany50\mydb.db;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;" & _
"Dsn="""""
Note: Including the DSN tag with a null string is absolutely critical or else you get the dreaded -7778 error.
oConn.Open "Provider=ASAProv;" & _
"Data source=myASA"
For more information, see: ASA Programming Interfaces Guide and ASA User's Guide OLE DB Provider for Sybase Adaptive Server Enterprise (ASE)
oConn.Open "Provider=Sybase ASE OLE DB Provider;" & _
"Data source=myASEServer"
' Or
oConn.Open "Provider=Sybase.ASEOLEDBProvider;" & _
"Srvr=myASEServer,5000;" & _
"Catalog=myDBName;" & _
"User Id=myUserName;" & _
"Password=myUserPassword"
Where:
- The Sybase ASE OLE DB provider from the Sybase 12.5 client CD
- 5000 is the port number for Sybase.Note: The Open Client 12 Sybase OLE DB Provider fails to work without creating a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.Note: With Open Client 12.5, the server port number feature finally works, allowing fully qualified network connection strings to be used without defining any .IDS Data Source files.