How PB9.0 on a visit to MSSQLSERVE

CodePudding user response:

OLE way

The SQLCA. DBMS="OLE DB"
The SQLCA. LogPass="password"
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='127.0.0.1', PROVIDERSTRING='database=database name; AutoTranslate=no 'DBTextLimit=' 8000 '
"The SQLCA. Lock="RC"
MSSQL gs_dbms=' '

CodePudding user response:

SQL special interface
//Profile mydb
The SQLCA. DBMS="MSS Microsoft SQL Server"
The SQLCA. Database="mydb"
The SQLCA. LogPass=& lt; * * * * * & gt;
The SQLCA. ServerName="127.0.0.1"
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""

CodePudding user response:

Originally I can use the database link below normal in PB8 use:
The SQLCA. DBMS="MSS Microsoft SQL Server 2000"
The SQLCA. ServerName="10.60.61.100"
The SQLCA. Database="sa"
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""
The SQLCA. LogPass="aa"
Connect using the SQLCA;

Now I'm going to put an update to the PB10, background database is changeless, after using PB10 compilation, runtime tip:

The DBMS MSS Microsoft SQL Server 2000 is not supported in your current installation.

I don't know how to solve?

CodePudding user response:

I remember the PB10 does not support this way, the PB11 support again

CodePudding user response:

The SQLCA. DBMS="OLE DB"
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='127.0.0.1', PROVIDERSTRING='database=mydatabase'"


10.0 when installation to must do the OLEdb installation

CodePudding user response:

This simple ah, online search will get the answer.