I am trying to connect to a sybase db in Excel using VBA / ADO. I would like to use NT authentication. I would be grateful if someone could provide me the connection string parameters.
In the sql ini file I use named pipe protocol.
The connection string then would be;
oConn.Open "Provider=Sybase.ASEOLEDBProvider;" & _
"Srvr=myASEServer,5000;" & _
"Catalog=myDBName;" & _
- The Sybase ASE OLE DB provider from the Sybase 12.5 client CD
- 5000 is the port number for Sybase.
Notice you only need the User Id parameter, don't need the password parameter. The server should have access to the NT LAN Manager.