|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-14-2002, 01:59 PM
|
#1 |
|
Member (6 bit)
Join Date: Nov 2001
Location: North East UK
Posts: 33
  |
MS-SQL 2000 & MS ACCESS won't connect
I am trying to create an Access Database Project (.adp) using an existing SQL database. When I go through MS-Access Data Link properties I enter the domain (eg 217.208.135.14) then the administrator user name and appropriate password. I then type the name of the database in the "Select Database on Server" box. (nothing ever appears in the drop-down)
I always get the following error message: "Test connection failed because of an error in initializing the provider. [DBNMPNTW]Specified SQL Server not found" I am using Win2k SP2 and Access 2000 SR1a. The SQL database is up and running with other applications, I just can't connect to create an .adp. Please help if anyone knows a solution!! Many thanks, Simon. |
|
|
|
08-15-2002, 11:47 AM
|
#2 |
|
Professional gadfly
Join Date: Jan 2002
Location: Minneapolis, MN
Posts: 6,364
 |
What OS is the SQL Server running on?
Have you checked SQL Server's error log? Can you create a connection another way (i.e. setting up a DSN?)? |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
