My client application in XP can normal to connect to a remote SQL SERVER2005 server, normal execution applications, but the application under the Windows 7 client is unable to connect, prompt access denied, how should solve? Using ADOconnection connection, my connection string is:
Connstring=Provider=SQLOLEDB. 1; Password=sa; Persist Security Info=False; User ID=sa; Initial Catalog=database name; Use Procedure for Prepare=1; Auto Translate=True; Packet Size=4096; Workstation ID=server name; Use Encryption for Data=https://bbs.csdn.net/topics/False; The Tag with the column collation when possible=False; Data Source=server IP, development language c + + Builder5.0
Emergency help each master,

CodePudding user response:

The remote server whether to allow firewall is essentially the default port 1433 open?

CodePudding user response:

Demon elder brother good, used to open the default port is 1433, should be XP client applications can connect, and normal operation of data access,

CodePudding user response:

First of all use management tools - & gt; Data sources (ODBC) test is successful,
If the data sources (ODBC) can not into the ADO, so have a look at whether the lack of necessary ADO connection required to drive and dynamic library (general system)! Database services cannot connect many reasons, need to the service from the network, from one machine to another machine comparing screen!