ODBC Connection issues between XP Client and 2008 R2 MSSQL Express Server

• jacobbdrew

  SSC Veteran

  Points: 235

  More actions

  December 28, 2011 at 12:37 pm

  #250481

  Hi-

  I'm trying to connect a client's XP windows machine via ODBC to a SQL EXPRESS 2008 x64 server.

  I can connect from a Windows 7 x64 client using the 32bit ODBC admin tool in the syswow folder. This is strange to me. Why would this work when...

  ...I cannot connect using the 'regular' ODBC administrator on the Windows 7 client

  Likewise, I cannot connect from the XP computer, which is the connection I really need to work. I've installed the SQL Server Native Client 10.0 driver, Named Pipes are enabled, and remote connections are enabled. (As mentioned, I can connect from a Windows 7 machine. I can also connect remotely with management studio from the Windows 7 machine)

  The error I'm getting suggests there's something wrong with the connection string, but I don't know how to manually review/manipulate the ODBC connection string (I'm using the administrator). Help?

  The error I'm getting when trying to connect from the XP machine:

  Connection Failed: SQLState '08001'

  SQL Server Error: 87

  [Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Connection string is not valid [87].

  Thanks!!!

• NLV

  SSChasing Mays

  Points: 654

  More actions

  December 30, 2011 at 4:10 am

  #1426848

  Hi,

  Can you please check the connection string again which you are using in XP machine.

  Please check the parameter given for Provider option.

  If you are already mentioning "SQLNCLI.1" then try to restart SQL agent once.

  thanks

  NLV.