Need help linking to SQL Server table in Access

[tubbers]

Forgive me if this is explained in detail somewhere else, but I wasn't able to find any posts that helped.

I'm trying to link a table I have set up in SQL Server 2000 to an Access database. I understand that I need to set up the ODBC connection first but I'm running into trouble. I get the following error when I try to create a new data source to SQL Server:

Connection Failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

I'm not very familiar with ODBC and setting up the DSN. My login and password are correct.

Any ideas on where the problem is? I'm running Windows XP Pro and Access 2002.

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886