Re: [Firebird-odbc-devel] Re-installing ODBCJDBC driver

[Paul R. <pr...@ib...>]

Graeme Edwards wrote:
> I have removed the Firebird ODBC driver while trying to resolve issues with
> Crystal reports and now I cannot get it to re-install. It goes through the
> process of installing but does not install either of the dll files
> (odbcjdbc.dll or odbcjdbcsetup.dll) in the windows system directory or add
> any ODBC drivers to the registry. I have manually removed all reference to
> these drivers from the registry previously.
> Before reinstalling I tried to manually unregister the odbcjdbc.dll file and
> got some kind of windows error about a corrupt file that should be unloaded
> from memory.
> I am running windows 2000 service pack 2. I have tried the re-install many
> times restarting in between with the same results.
> 
> Anyone got any ideas about this?
> 

The install routine is not very clever and was not written with Win2K in 
mind.

You could try to manually copy the IscDbc.dll, OdbcJdbc.dll and 
OdbcJdbcSetup.dll into the system32 directory and then run regsvr32.exe 
from the command line thus:

   c:\path\to\system32\regsvr32.exe x:\path\to\OdbcJdbcSetup.dll

That is all the install package is doing, so I suspect it won't succeed. 
The error most likely resides in OdbcJdbcSetup itself. Win2K is probably 
not helping things, either.

To get the files out of the installation package run the install as 
normal. When you get to the readme (after the dialog asking you to 
specify the install location) go to the %TEMP% directory and locate the 
temporary folder containing the driver. Copy the dlls somewhere safe. 
They get automatically deleted at the end of the install.

If you get really desperate here are the registry entries I have. (Pay 
attention to word wrap, btw):


[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Firebird/InterBase(r) driver]
;This should perhaps be dword:00000001
"UsageCount"=dword:0000000e
"Driver"="C:\\WINNT4\\System32\\OdbcJdbc.dll"
"Setup"="C:\\WINNT4\\System32\\OdbcJdbcSetup.dll"
"FileExtns"="*.gdb"
"APILevel"="1"
"ConnectFunctions"="YYN"
"FileUsage"="0"
"DriverODBCVer"="03.00"

;!!!Amend this as required!!!
;[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Core]
;"UsageCount"=dword:00000007

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"Firebird/InterBase(r) driver"="Installed"


Don't blame me if I've just given you some more rope to hang yourself 
with, btw. This is untried and untested and at your own risk.


Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase