odbc will not connect while Server Management Studio will

odbc will not connect while Server Management Studio will

Post by RGF2aWQgQm » Wed, 04 Nov 2009 08:37:01


SQLServer 2008 is running on a SBS Server on local network. From this Vista
64 wkstn Management Studio will connnect to the server and view databases.
ODBC will not (error below) and apps will not.
Remote Connections is enabled on the SQL Server. Named Pipes and TCP/IP
Dynamic enabled

Microsoft SQL Server Native Client Version 10.00.1600

Running connectivity tests...

Attempting connection
[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces:
Connection string is not valid [87].
[Microsoft][SQL Server Native Client 10.0]Login timeout expired
[Microsoft][SQL Server Native Client 10.0]A network-related or
instance-specific error has occurred while establishing a connection to SQL
Server. Server is not found or not accessible. Check if instance name is
correct and if SQL Server is configured to allow remote connections. For more
information see SQL Server Books Online.

TESTS FAILED!
 
 
 

odbc will not connect while Server Management Studio will

Post by Russell Fi » Thu, 05 Nov 2009 00:11:03

David,

You need to show the ODBC definition. The first error is the important one:
Connection string is not valid.

One thing that often raises this problem is that the SQL Server instance
name is not fully specified. For example, your server machine might be
SBSServer, but the SQL Server instance could have been installed as
SBSServer\MyCompany. So, if the full instance name 'SBSServer\MyCompany'
was not specified in ODBC, the connection could not find the SQL Server with
only SBSServer.

Of course, it could also be something else. More information is needed.
First, however, you might want to read:
http://www.yqcomputer.com/

Be sure to read the Q/A discussion as well.

RLF