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.

TESTS FAILED!

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

Stephen
 
 
 

Problem connecting ODBC to SQL

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

Hello,

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 ?

Tom


<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: http://www.yqcomputer.com/

btw, here is a comparison of Named pipe VS TCP/IP:
http://www.yqcomputer.com/ (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
"c:\windows\system32\odbcad32.exe".

Thanks,
Ming.
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