Results 1 to 2 of 2

Thread: VBA / Sybase

  1. #1
    Join Date
    Aug 2003

    Unanswered: VBA / Sybase

    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


  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    Integrated logins has to be set on the server side using;;pt=9701#X

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts