如何连接sybase

Question

ODBC 
 Standard:
"Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;" 
 Intersolv 3.10:
"Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;" 

Answer 1

OLE DB Provider for Sybase Adaptive Server Anywhere (ASA) 
oConn.Open "Provider=ASAProv;" & _
           "Data source=myASA"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"

Answer 2

大不了用odbc建一个sybase连接把里面的连接字串拷过来嘛

Answer 3

引用microsoft.data.odbc;
    代码如下：
using System.Data;
using System.Data.Common;
using Microsoft.Data.Odbc;string source=Driver={Sybase System 11};SRVR=服务器名;DB=数据库名;UID=sa;PWD=
OdbcConnection conn = new OdbcConnection(source);
OdbcCommand cmd=new OdbcCommand();
cmd.Connection=conn;
cmd.CommandType=CommandType.Text;
OdbcDataAdapter da=new OdbcDataAdapter();
da.SelectCommand=cmd;
DataSet ds1=new DataSet();
conn.Open();conn.Close();