Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Unanswered: Connection failed to SQL server 2008 from ADP access 2007.

    ADP Microsoft access 2007.
    I be able to connect to server SQL 2003 without a problem.
    OBDC connection to SQL Server 2008 without a problem.
    Logon to SQL Server 2008 without a problem.
    On my local pc does have Microsoft SQL Server 2008 driver installed.

    But when connect to server SQL server 2008 through test connection.
    I have the following error:

    On the Data Link Properties:
    Connection tab;
    1. Select or enter a server name: (I click on the drop
    down arrow and select the server name.
    2. Use Windows NT Integrated security (I select this)
    Click on the Test Connection button and the following error box display:

    Test connection failed because of an error in intializing provider.
    [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

    Any help is appreciated
    Thanks, nghiem

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    I can't remember the details and my documentation is in my office while I'm at home for the weekend however, if my memory serves me right, this kind of problem can happen if you try to connect to a named instance of SQL Server.

    Did you try using alternative drivers?

    See also: ConnectionStrings.com - Forgot that connection string? Get it here!
    Have a nice day!

  3. #3
    Join Date
    Mar 2013
    Posts
    2
    Hi Sinndho,
    Thanks for the respond. I can wait until you come back next week.
    What alternative drivers?

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Quote Originally Posted by nghiem View Post
    What alternative drivers?
    They are enumerated on the site the address of which I gave in my former post.
    Have a nice day!

Posting Permissions

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