Problem connecting ODBC to SQL

Problem connecting ODBC to SQL

Post by U3RlcGhlbi » Sat, 10 Apr 2010 20:40:01

Can any of you guys help?
I am new to using SQL Server. I have a database that I wish to upsize from
Access to put the back end on a server, and use Access as a front-end.
However, I am stuck at the very first stage - I cannot link Access to the
SQL server.

However, the ODBC Data Source Administrator keeps on failing to link to SQL
I get an error message like this:

Microsoft SQL Native Client Version 09.00.4035
Running connectivity tests...
Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a
connection to SQL Server [2].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not
allow remote connections.


I am on a single computer for development, so no network connected yet. I am
using SQL Server 2005 Express, and Access 2010 beta.

I would be grateful for any suggestions


Problem connecting ODBC to SQL

Post by tom knau » Tue, 13 Apr 2010 17:17:07


did you enable tcp/ip in sql configuration panel ?

There are issues on odbc when used on a 64 Bit OS, what do you use ?
Did you try to connect to excel ?


<Stephen> schrieb im Newsbeitrag


Problem connecting ODBC to SQL

Post by UGFrLU1pbm » Fri, 16 Apr 2010 19:28:04

Stephen, as mentioned by Tom, please try TCP/IP. You can read the KB to find
out how to enable TCP/IP:

btw, here is a comparison of Named pipe VS TCP/IP: (SQL.80).aspx. But when we
are connecting to a local SQL server, we are using shared memory by default
which is extremely fast. Therefore, TCP/IP is recommended in general.

Tom, if you are using 64-bit OS and a 32-bit Office, please use
"c:\windows\syswow64\odbcad32.exe" to configure your DSN. But if you are
using 64-bit Office 2010 Beta, you can simply use

WDAC Team, Microsoft.

Problem connecting ODBC to SQL

Post by Kenneth A. » Sat, 10 Jul 2010 08:03:35

"Pak-Ming Cheung - MSFT" < XXXX@XXXXX.COM >

Problem connecting ODBC to SQL

Post by Kenneth A. » Sun, 11 Jul 2010 07:29:24