Results 1 to 2 of 2

Thread: VBA / Sybase

  1. #1
    Join Date
    Aug 2003
    Posts
    7

    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

    Yogesh

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    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.

Posting Permissions

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