MS SQL Server 2000 DB Driver Question

[pullesj]

We are running PB 9.0.1 Enterprise and MS SQL Server 2000 (STD Edition). This app is not n-tier - it is straight client/server. Currently we're using the old MS SQL Server 6.x native mode driver (PBMSS90.dll) for connectivity to the database. This currently works fine, however, when we migrate to PB 10 (who knows when) I understand we'll need to use another access method such as OLE DB (PBOLE90.dll and SQLOLEDB as 'Provider' in the connection string).

I have been doing some experimenting with the OLE DB driver (in PB 9) and it appears slower than the using the old MS SQL 6.x native mode driver. Do I need to tweek the connection parameter string? What's the preferred method for connecting PB 9.0 apps to MS SQL 2000?

 

[mbalent]

The settings for our transaction object are as follows:

dbms = 'OLE DB'
dbparm = PROVIDER='SQLOLEDB',DATASOURCE='SQLDEV',PROVIDERSTRING='database=qte;APP=00MB'
lock = 'RC'
logid = 'csu'
logpass = 'csu'
autocommit = true

HTH,
mbalent

"Nature forges everything on the anvil of time