Can pb11.5 even SQL SERVER 2000 database, pb9.0 can even, can even, why?

CodePudding user response:

From that, the problem has been solved, solve the following:
Since pb10, Sybase gave up support for essentially a special interface, PB11 going with OLD DB connection MSSQL data,
The SQLCA. DBMS="OLE DB"//interface description
The SQLCA. LogId="sa"//database administrator ID
SQLCA. LogPass=""//database administrator password
The SQLCA. The AutoCommit=False//Settings are automatically submit
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='. ', PROVIDERSTRING='database=techmager"//define the connection parameters DATASOURCE that database server address, can be a computer name or IP, PROVIDERSTRING=' database=techmager 'instructions to connect data is techmager
Connect using the sqlca;//perform database connections

CodePudding user response:

You can also use the SNC

CodePudding user response:

CodePudding user response:

Not directly connected with ADO.NET

CodePudding user response:

By the top

CodePudding user response:

Why want to give up, I don't have to PB11.5 later version,

CodePudding user response:

Oledb can also, don't have to install the client, using SQL NLC and oracle, a virtue, but also install, distribution of trouble,

CodePudding user response:

To connect, as follows: the OLE DB interface,
//Profile hairdb2011
The SQLCA. DBMS="OLE DB"
The SQLCA. LogPass=& lt; * * * * * * * * & gt;
The SQLCA. LogId="hairsa"
The SQLCA. The AutoCommit=False
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='. ', PROVIDERSTRING='database=hairdb2010_txn'"