I am using pb6 wiht ms sql server 7

[santosh2natal]

I am using pb6 wiht ms sql server 7.0 as backend. I want to connect to backend using OLE DB interface. Is it possible? Also on what versions of Windows will it work? Particularly I work on win98 for front end and win NT 4.0 for backend.

Please help

Thanx in advance

 

[mbalent]

These are the connection parameters we use to connect to sql2000 via OLE DB (from pb8.0.3). I don't know if they would work on PB6 or not.

SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='AIN02',PROVIDERSTRING='database=quote_apa;Trusted_Connection=Yes'"