Results 1 to 3 of 3
  1. #1
    nyneave is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2012
    Posts
    24

    Connection error when using ODBC/DSN Access 2003 to SQL 2005

    I am using a file DSN connection in an Access 2003 database to use linked SQL Server 2005 tables. I have one setup that works great (to 1 server/database). I am trying to setup another one (to a different server/database). I have a SQL user setup and I can connect fine via SQL Query Analyzer. However, when I try to add a file DSN (also tried a system DSN) using that SQL login; I get the following:



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

    Any ideas?

    Thanks,
    Nyneave

  2. #2
    help_me_with_access is offline help_me_with_excel
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    262

  3. #3
    tanvi is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    100
    This issue arises because Remote connections are disabled by default. Look at the Database Engine -> Remote Connections option. Some Other possibilities are:

    1) Are you trying to connect remotely? If so, disable your temporarily firewall and see if this helps.


    2) I'm not a connection string expert but go to www.connectionstring.com and use one of theirs. This will help ensure it's not a connection string issue.


    3) No SPs installed? You might want to try installing those.

    In my case I had to set local and remote connections to using both TCP/IP and Named pipes.

    Job done!!!

    Hope this will help you too!!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. ARITHABORT error on ODBC Connection
    By nyneave in forum SQL Server
    Replies: 0
    Last Post: 08-01-2012, 09:53 AM
  2. Replies: 0
    Last Post: 03-08-2012, 03:12 AM
  3. ODBC 32 to 64 Bit connection error
    By mgmtexecit in forum Reports
    Replies: 0
    Last Post: 03-30-2011, 10:06 AM
  4. ODBC 32 to 64 Bit connection error
    By mgmtexecit in forum Access
    Replies: 1
    Last Post: 03-30-2011, 10:05 AM
  5. Replies: 2
    Last Post: 11-10-2009, 02:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums