Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

DSN-less ODBC connection error

Discussion in 'Information Technology' started by Melanie O, Jul 28, 2006.

  1. Melanie O

    Melanie O
    Expand Collapse
    Guest

    I tried using Doug Steele's DSN-less connection code in VBA found on
    http://www.accessmvp.com/DJSteele/DSNLessLinks.html. However, I am getting
    the following error message:

    Connection failed:
    SQLState: '01000'
    SQL Server Error: 53
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
    Connection failed:
    SQLState: '08001'
    SQL Server Error: 17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
    access denied.

    Does anyone know how I can troubleshoot this problem?

    Thanks,
    Melanie
     
  2. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    What are you using this for?

    It looks as if you are using it to create an ADO connection to connect to
    SQL Server, if so then you are using the wrong provider.

    --

    Terry Kreft


    "Melanie O" <MelanieO@discussions.microsoft.com> wrote in message
    news:79495184-3985-41EA-B542-473308B2BC16@microsoft.com...
    > I tried using Doug Steele's DSN-less connection code in VBA found on
    > http://www.accessmvp.com/DJSteele/DSNLessLinks.html. However, I am

    getting
    > the following error message:
    >
    > Connection failed:
    > SQLState: '01000'
    > SQL Server Error: 53
    > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
    > Connection failed:
    > SQLState: '08001'
    > SQL Server Error: 17
    > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
    > access denied.
    >
    > Does anyone know how I can troubleshoot this problem?
    >
    > Thanks,
    > Melanie
     

Share This Page