Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    19

    Unanswered: Connection String for Sybase database

    Hi Guys:

    I am trying to connect to the sybase database using ASP.

    I used the following connection string:

    **************************************************
    MdConnection.Open "Driver={SYBASE ASE ODBC Driver};" & _
    "Srvr=XXXXX;"&_
    "Uid=XXXXX;" & _
    "Pwd=XXXXX"
    **************************************************
    I get the following error:

    **************************************************
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [MERANT][ODBC Sybase ASE driver]Insufficient information to connect to the data source.
    **************************************************

    Any Suggestions???

    By the way i have configured the Sybase ASE driver in the following way:

    Provided the following details and Tested the connection:

    Data Source Name: XXXXX
    Network Library Name: Winsock
    Network Address: XXX.XXX.XXX.XXX,XXXX
    Database Name XXXX

    and then test connection came out successful.

    Please let me know how to change my connection string to provide the complete information as the error says that it has insufficient information.

    Thanks in advance

  2. #2
    Join Date
    Dec 2003
    Location
    FRANCE (Paris)
    Posts
    23

Posting Permissions

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