Home > database >  How to connect the SQL server database in the original concept?
How to connect the SQL server database in the original concept?

Time:09-29

How to connect the SQL server database in the original concept?

CodePudding user response:

The special interface:
The SQLCA. DBMS="MSS Microsoft SQL Server 6. X"
The SQLCA. Database="JDJL"////Database name
The SQLCA. ServerName="zcglserver"////the server name, if it is written in the native machine name or IP address of the machine
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""

CodePudding user response:

Starting from the pb10 cancelled essentially a special interface, you can use odbc, ole connection, preparation method and the above about!

CodePudding user response:

The SQLCA. DBMS="MSS Microsoft SQL Server 6. X"
The SQLCA. Database=ls_database
The SQLCA. ServerName=ls_server_name
The SQLCA. LogId=ls_user
The SQLCA. LogPass=ls_pwd
The SQLCA. DBPass=ls_pwd
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""
Connect using the sqlca;

CodePudding user response:

Thank you very much!

CodePudding user response:

Can also through the ODBC connection

CodePudding user response:

//Profile test_server
The SQLCA. DBMS="MSS Microsoft SQL Server"
The SQLCA. Database="test"
The SQLCA. LogPass="* *"
The SQLCA. ServerName=". "
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""


We use now or PowerBuilder9.0, but the connection method should be the same,,,,,,,,,

CodePudding user response:

Refer to the http://topic.csdn.net/u/20090406/15/1d6d02d5-875e-43bf-94ae-343761530d61.html
  • Related