Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PB 9, MS SQL 2000, and OLE DB

Status
Not open for further replies.
pullesj

pullesj

Programmer
Sep 2, 2003
21
US
I'm in the process of migrating a PB 7 PFC application to PB9 PFC. Currently the DBMS provider is MS SQL 2000 and we are using the old MS SQL 6.5 driver:

SQLCA.DBMS = 'MSS Microsoft SQL Server' -- (pbmss90.dll)

I would like to use an OLE DB provider to connect to the database. I have PB 9 IDE connecting to the MS SQL 2000 via OLE DB, but would like to know what .dll file (if any) I need to deploy with the application and if there will be any coding changes required (besides the connection parameters) and if I should expect any system performance enhancement/detriments using OLE DB.

Thanks,
 
Status
Not open for further replies.

Similar threads

CFauvel2
  • Locked
  • Question
I am trying to hide an Adobe Ole Control error from the user using a nested Try/Catch.
Replies
1
Views
482
CFauvel2
CFauvel2
C
  • Locked
  • Question
Copy file from Sybase db to a network share that powerbuilder user does not have access to
Replies
0
Views
607
CharlesSwaim
C
sindbad11
  • Locked
  • Question
how to use ole control assocaited with mscomm32 to read from serial port
Replies
0
Views
359
sindbad11
sindbad11
Eaka
  • Locked
  • Question
How to get date and time from files with Power Builder?
Replies
0
Views
496
Eaka
Eaka
powerbuilde
  • Locked
  • Question
searching text in blob column contains word document(ole)
Replies
0
Views
406
powerbuilde
powerbuilde

Part and Inventory Search

Sponsor

Back
Top