Converting DB Driver using VB

[PhilipMoss]

I need to be able to automatically change or specify which database driver is used on a report automatically.
Currently a report is using pdsodbc.dll and i need to open and run using pdsora7.dll.

I use VB6 and Crystal 7 active X control.

This is a need to run the same report against the same table structure on two different systems.

One Odbc connection and one Oracle 7

using odbc on oracle database is not good enough in this instance.

 

[kenhamady]

I don't think you can change this from the App.

Workarounds would be to use two versions of the same report, calling the one you need.
Or you can get the data as an ADO recordset in VB and pass it to a report created using the active data driver. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)