Delphi7 ADOCONNECTION controls, select the database on the Server now pull after pop-up warning box: [DBNETLIB] [ConnectionOpen (Connect ()).] SQL Server does not exist or access denied, what is the situation? Online methods are used or not

CodePudding user response:

Database machine shut firewall
SQL open TCP/IP protocol

CodePudding user response:

Involves to the server, the client system Settings, IP Settings, firewall...

CodePudding user response:

Check the three places:
1, the parameters of the ADO connection, for example as follows:

 
The Provider=SQLOLEDB. 1; Password=sa; Persist Security Info=True; User ID=sa; Initial Catalog=JXGZ; The Data Source=192.168.1.5 

2, whether the DB server firewall blocked,
The essentially. Exe is added to the exception, table,
3, with essentially a client to login, to access the database, see if there is something wrong,

CodePudding user response:

Want to see what he server, and then the corresponding open can
May be his server address is wrong, a lot of problems

CodePudding user response:

With the native database connection first look at the error message specific what is it

CodePudding user response:

Is a dynamic library file missing?

CodePudding user response:

Database connection? Which version of the database?

CodePudding user response:

This error is the client to the server to send a message, but no reflect, the server involves the question a lot:
1, the network connection impassability;
(1) the network break line;
(2) the server operating system parameters such as IP, set the wrong;
(3) the client operating system parameters such as IP, set the wrong;
2, the server to use static IP
3, the server is not carried out;
4, the server socket without implementation;
5, the server executes, not connect to the database;
6, the server setting the waterproof wall;
7, the client socket without implementation;
8, the server is not open IP services;
9, the client did not open the IP service;
.