Linking SQL Tables to Access - Creating ODBC Data Source 1

[storm75m]

I am brand new with SQL Server and all I've done so far is installed SQL 7.0 on a NT 4.0 machine that's in our network, and created a simple database. Now I'm trying to link the tables from that database to an Access application at separate work station, and I've added an ODBC data source, but when I try to connect, I get the following error:

Connection Failed:
SQLState: '01000'
SQL Server Error: 161
[Microsoft][ODBC SQL Server Driver][dbnmpntw]ConnectionOpen(CreateFile())

I actually get this error message twice, but the second time the SQLState is 08001. And help would be much appreciated, and if someone could just point me in the right direction I would be very thankful.

 

[foxdev]

It looks like you are trying to use Named Pipes (the default) from the client, but the server may be using TCP/IP. On the client, change the library to Multiprotocol or TCP/IP and see if this helps. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[storm75m]

Exactly where do I go to change the library from Named Pipes to Multiprotocol? Is this configured in the ODBC Data Source?

 

[foxdev]

If you have the full SQL Server Client package installed, its Client Network Utility on the SQL Server group.

If not, you can open the ODBC administrator, click Configure on the desired DSN, and choose Client Configuration on the second Tab. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org