Who know how to connect SQL server 2000 under pb10.0-CodePudding

I turned out to be pb9, after upgrading to 11.0, the database configuration where can't see the SQL server driver, where should be how to connect the original existing database?

CodePudding user response:

Title and the content is not
10.5 cancelled after special SQL, want to use the new SNC SQL native client interface

SQL2005 with directly, 2000 under an interface

CodePudding user response:

Through the ODBC connection can also

CodePudding user response:

Ole db, odbc can be

CodePudding user response:

Is ODBC, OLE DB, please.

CodePudding user response:

reference 4 floor ZHGWBZHD response:

still OLE DB, than the ODBC better.

But where? Listen
I basically just compare deficient

CodePudding user response:

Ole db speed a lot, and just have a corresponding DLL, terminal client can need not installation and setup,

However, essentially a side char best instead of type varchar field,

CodePudding user response:

PB10 connected to the SQL Server configuration

May first use the pb10 friends unable to connect to SQL server, on the one hand, without the MSSQL
Dedicated server interface, on the other hand, the database management system (DBMS) replaced by "OLE DB," configuration up a bit not comfortable! The following is to introduce pb10 with OLE
DB connection SQL 2000 database,

At the time of installation pb10 select custom/full mode (the default installation mode would not install ole
Db interface), next - "if you don't have to install.net is not selected in the list of ADO.net... Items, all the way next to complete the installation,

Found in the database drawing board OLE Microsoft OLE DB, right click on it to create a new configuration, the configuration in the pop-up window:

Profile name: fill in the configuration file name//can be arbitrary

The provider: select the database management system type, choose here "SQLOLEDB item
"
The data
Source: the server name (and the previous version is different), can be in the drop-down list to choose, can also fill in the server name or IP address, such as: 127.0.0.1, etc., if the provider is not "SQLOLEDB" may not have the option in the drop-down list,

User ID, user name, my user name is the default sa

Password: the corresponding user ID password, my password is empty, so don't fill,

Here you can successfully connect to the SQL
The server, but which connect to the database? The above parameters are not specified, I'm looking for half a day: P, don't try so hard, in the Extended fill in
"The database=database name", (no quotes)

The final configuration file content is:

//Profile ihs
The SQLCA. DBMS="OLE DB"
The SQLCA. LogId="sa"//my user name is sa
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=
"The PROVIDER='SQLOLEDB', the DATASOURCE='NETMANAGER', PROVIDERSTRING='database=zs"
//my database name is: zs; Behind the datasource can also be a IP address: the datasource='127.0.0.1'

At this point was finished with OLE DB connection under the pb10 SQL server configuration!

CodePudding user response:

10.5 cancelled after special SQL, want to use the new SNC SQL native client interface

With NSN odbc and JDBC connection and good ole db

CodePudding user response:

The

reference 7 floor pb2000 response:

PB10 to connect SQL Server configuration

May first use the pb10 friends unable to connect to SQL server, on the one hand, without the MSSQL
Dedicated server interface, on the other hand, the database management system (DBMS) replaced by "OLE DB," configuration up a bit not comfortable! The following is to introduce pb10 with OLE
DB connection SQL 2000 database,

At the time of installation pb10 select custom/full mode (the default installation mode would not install ole
The db interface), next - "if you don't have installed....

Super detailed, is really fierce!

CodePudding user response:

OLE DB