Strip Oracle ODBC Driver from PC for install in new? 1

[CraigBest]

Hope someone can help...

I have several Crystal Reports that were written about 3 years ago using an Oracle 9 ODBC driver. Since that time, the PC I developed the reports on was replaced, and now the users' PC has been replaced too. When we installed the reports back on the new PC, they won't run because the proper ODBC driver is not present.

We are having huge problems trying to get a driver that will work installed. Oracle's installer program won't give us a diver installation that will run, the connection creation process crashes as soon as you select a driver.

I still have the old user PC with the driver on it -- is there any way to strip it out of the old machine and install it on the new one? Some software or process I can follow that will do this? I'm not looking forward to having to re-rwite all these reports (25 or more) if I have to change the driver.

Please help!


CraigHartz

 

[ArtieChoke]

Typically it's just a dll file. You'll need to go into the registry on the computer that has the good driver and find the file name. The starting point is HKEY_LOCAL_MACHINE\SOFTWARE\ODBC. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI has all the drivers. Select the Oracle entry and you will see the file name listed under the driver and setup entries. You will also need to copy this entry and the one in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers and add them to the registry of the new computers.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[CraigBest]

Cool, thanks! I'll see what I can do. Appreciate it.


CraigHartz

 

[CraigBest]

Artie,

Worked like a charm. Thanks! I'd give you ten stars if I could.



CraigHartz

 

[ArtieChoke]

Just glad I could be of service.

"I think we're all Bozos on this bus!" - Firesign Theatre