Pb code to connect SQL server network database, not before compilation, with pb operation can be directly, but not even compile and then run the SQL database, sqlerrtext shows: "SQL server is not available, or does not exist," sqlretutndata shows: "unable to connect: SQL server does not exist or deny network access"
Masters, what reason is this?

CodePudding user response:

The cause of the firewall? Or to be behind the IP and the comma, add the port number 1433?

CodePudding user response:

Firewall should be impossible, I compile with the compiled before is the same computer, firewall Settings is the same,
The comma has added behind the IP, port also some, is the port number to me is 8433,

CodePudding user response:

Connection code?
The preview?

CodePudding user response:

//Profile mobile information machine
The SQLCA. DBMS="MSS Microsoft SQL Server 6. X"
The SQLCA. Database="OpenMas"
The SQLCA. LogPass=& lt; * * * * * * * * * * * * & gt;
The SQLCA. ServerName="111.111.111.111, 1111 \ SQLEXPRESS"
The SQLCA. LogId="OpenMas8005001"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="PBCatalogOwner='OpenMas8005001'"

CodePudding user response:

The 111.111.111.111:1111 \ SQLEXPRESS give it a try

CodePudding user response:

Tried, but also not line,

CodePudding user response:

Use alias, pen name first set up the database in the SQL configuration server, including port and server
Try the alias in the program

CodePudding user response:

With 1111 port, they don't have to instance name

CodePudding user response:

What is the difference between PB compile with the compiled before? Before compiling can obviously of

CodePudding user response:

Compiled run separate PB need fewer database support files?

CodePudding user response:

PB need database support files specific to point to?
Didn't lack what document like yao, and I even had a LAN in the SQL database, application of writing are the same, no problem,
The SQL database is on the Internet, not, really don't understand,

CodePudding user response:

refer to the original poster Pbwenti response:

pb code to connect SQL server network database, not before compilation, with pb operation can be directly, but not even compile and then run the SQL database, sqlerrtext shows: "SQL server is not available, or does not exist," sqlretutndata shows: "unable to connect: SQL server does not exist or deny network access"
Masters, what reason is this?

Should be the problem of dynamic link libraries, and put the pb DLL are copied to the operation of the directory you try

CodePudding user response:

Is this your PB several connection which version of SQL

CodePudding user response:

Whether the dynamic link library file PSLIB21. DLL not startup directory?