USES is PB special connection, the program code is as follows:
The SQLCA. DBMS="MSS Microsoft SQL Server"
The SQLCA. Database=sle_database. Text
The SQLCA. LogPass=sle_logpass. Text
The SQLCA. ServerName=sle_servername. Text
The SQLCA. LogId=sle_logid. Text
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""
Connect using the sqlca;

Generally can be connected, but encounter a few times this situation is not connection, win2003server as the client; Sometimes winXPhome version of the client connection failure; Online neighbors can be normal visit, using ODBC to connect, but use a dedicated connection returns sqlca. Sqlcode value is 1, in the search on the net not find valuable resources, consult everybody this case should be how to debug? Or special connection installation time need the support of some files?

CodePudding user response:

The sqlca. Sqlerrtext provide it and see

CodePudding user response:

You mention it reminds me, thank you, first temporarily don't have the test environment, etc. Have I stick up to look at it,

CodePudding user response:

Telnet server IP 1433 to see who can go to you.

CodePudding user response:

reference xuam reply: 3/f

Telnet server IP 1433 to see who can go to you.

CodePudding user response:

I shut down the firewall, but this did not try, try it later, and the error message can't see what was just said no submit SQL transactions,