[ykverma]

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.

Thanks in advance

Yogesh

[willy_and_the_ci]

Integrated logins has to be set on the server side using;
http://sybooks.sybase.com/onlinebook...hf=0;pt=9701#X

The connection string then would be;
oConn.Open "Provider=Sybase.ASEOLEDBProvider;" & _
"Srvr=myASEServer,5000;" & _
"Catalog=myDBName;" & _
"User Id=myUserName"
Where:
- 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.