CNN.connectionstring="provider=msdasql;driver={sybase system 11};
    srver=srveru;dsn="";db=dataa;uid=sa;pwd=dqwe;persist securitu info=fakse"

解决方案 »

  1.   

    for: Sybase System 12 (or 12.5) Enterprise Open Client ODBC DriveroConn.Open "Driver={SYBASE ASE ODBC Driver};" & _
               "Srvr=myServerName;" & _
               "Uid=myUsername;" & _
               "Pwd=myPassword"
     
    for: Sybase System 11 ODBC DriveroConn.Open "Driver={SYBASE SYSTEM 11};" & _
               "Srvr=myServerName;" & _
               "Uid=myUsername;" & _
               "Pwd=myPassword"
     
    for: Intersolv 3.10 Sybase ODBC DriveroConn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};" & _
               "Srvr=myServerName;" & _
               "Uid=myUsername;" & _
               "Pwd=myPassword"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="""""