PB9 connection SQLServer2000, on the client using PB9 own database interface directly connected, is not even, appear the following error: A is essentially the request resulted in A bad return code or status but no error massage was returned, but if the gamete ODBC, then using PB9 through ODBC to connect, use is essentially enterprise manager also can connect, depressed...
Please advice...

CodePudding user response:

Connection code to send up to look at it

CodePudding user response:

//Profile 196.168.3.2
The SQLCA. DBMS="MSS Microsoft SQL Server"
The SQLCA. Database="hosp"
The SQLCA. ServerName="196.168.3.2"
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""

CodePudding user response:

Is not directly with pb repeatedly, but not in the same network segment, the server is 196.168.0.2, through odbc and essentially a enterprise manager connection: no problem

CodePudding user response:

Write wrong, the server is 196.168.0.2, client is 196.168.3.2

CodePudding user response:

How do not login password?

CodePudding user response:

No password

CodePudding user response:

The sa password is empty? Have never come across no password, the password that add, or try for the sa add a password

CodePudding user response:

Tried, can't

CodePudding user response:

If I am in the server's local area network (LAN) connection is no problem, all can connect

CodePudding user response:

You set the IP of the machine and the server the same addresses a try, if can be connected is the reason why servername

CodePudding user response:

There is no problem in the local area network (LAN), but servername and what's the problem? Strange is the use of pb through ODBC connection is also possible

CodePudding user response:

This computer has installed pb? In the development environment, using SQL server connection can be connected?

CodePudding user response:

With pb, both in the development environment and compiled, and cannot even, but with essentially can be connected

CodePudding user response:

It.however, if the development environment with essentially a connection, and can see tables and data, then the code page preview window kao attributes to program, and should be able to connect

CodePudding user response:

Yeah, so I am depressed ah

CodePudding user response:

Help you top

CodePudding user response:

Pay attention to pick up points

CodePudding user response:

Sp4 patch on the server used to play, use "Telnet server IP 1433" test server 1433 ports are blocked,

CodePudding user response:

I also encountered such a problem, various methods are tried is not an error, the patch is also big,

CodePudding user response:

I also encountered this problem, attention, waiting for the situation

CodePudding user response:

Encounter the same problem, wait for Daniel,,,

CodePudding user response:

If no essentially a native client

CodePudding user response:

Met the same problem, wait for Daniel,,,
With essentially a native client

CodePudding user response:

Didn't encounter the same problem, wait for Daniel,,,