Navigation:  Silver Collection > Mar-2002 > Bad ADP Connections - Moving ADP's Between Machines

Garry Robinson        

 

If you open an ADP and the first message you get is

 

Microsoft Data Link Error
 
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. 

 

 Figure 1

or

Microsoft Data Link Error
 
Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. 

This means the server isn't working or you have moved the ADP front-end between machines and the server name is different.

To Solve - OR - Simply Setup Your Correct Connection

Choose File then Connection as in Figure 2.

Figure 2

Then enter the Correct Name of the Server

Figure 3

Test Your Connection and Your Database Should Work Fine