Pb + SQL server 2000, 9.0 is configured on one machine, after all the required DLLS on another machine, connect to the database failed, the configuration file is as follows:
The SQLCA. DBMS=MSS Microsoft SQL Server
The SQLCA.
ServerName=STAR - PCThe SQLCA. Database=publish
The SQLCA. LogId=sa
The SQLCA. LogPass=
The SQLCA. DBParm=;

CodePudding user response:

Using SQL client tools or windbver check, whether to use a TCP connection,
Could they use the default Name of pipe or other connection,

CodePudding user response:

Use is a TCP connection,

CodePudding user response:

What failure information

CodePudding user response:

Are there any sQL client!

CodePudding user response:

SQLSERVER2000 already installed, failure information for database connection fails, the interface can log in, is not connected to the database,

CodePudding user response:

Check the SQL server using the communication agreements, a named pipe is enabled?

CodePudding user response:

Did you connect??
Don't have this kind of low-level mistakes,

CodePudding user response:

Connection code is as follows:

[used]
The SQLCA. ServerName="127.0.0.1"
[user]
The username=CJQ

Display: "database connection fails,"

CodePudding user response:

My experience: before you set up an ODBC client there, if you can't build, or find the network port, if we can build and test, is the problem program,

Powerbuilder11 newcomers, please add: 20232067
Group: 6539042 (100)
================================================================
Founded by chengg0769

CodePudding user response:

He has to solve the problem, although all is not a problem they say, but thank you,