Ludek Finstrle wrote:
>> install psqlODBC 08.02.0002 using the MSI installer. I have the driver
>> from PostgreSQL installed, which gives me a "PostgreSQL ANSI" and a
>> "PostgreSQL Unicode" driver (both version 8.01.0200), but installing the
>> MSI does _not_ add another driver. Is there anyhting else I need to do
>> to get this to work?
>
> MSI - I hope you use OS Windows.
I wish I didn't, but yes, I do. :-)
> It may install PostgreSQL driver. It contains:
> C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll (and some others
> needed only for SSL and kerberos)
> Registry:
> HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\PostgreSQL
> APILevel = REG_SZ 1
> ConnectFunctions = REG_SZ YYN
> Driver = REG_SZ C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll
> DriverODBCVer = REG_SZ 03.51
> Setup = REG_SZ C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll
> SQLLevel = REG_SZ 1
> UniqueIndex = REG_SZ 1 (I'm not sure if it's required)
> UsageCount = REG_DWORD 0x0001
> HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers
> PostgreSQL = REG_SZ Installed
The files are present, but for me, every registry key except UniqueIndex
is missing. I do have BoolsAsChar, CancelAsFreeStmt, CommLog, Debug,
ExtraSysTablePrefixes, Fetch, Ksqo, MaxLongVarCharSize, and some more
settings of the driver. It might be that the MSI doesn't install the
registry key if it is already present. [checking...] No, no dice. Maybe
the MSI doesn't install the registry key if the _files_ are already
present. [checking...] Yes, removing the files and reinstalling works, I
now have my driver back. Apparently the uninstaller didn't remove them.
However, I just re-tested uninstalling as well, and the uninstaller
_does_ remove the files now...
> I hope I help you.
Yes, thanks very much for your help! I'm very thankful for the fact that
I can access my database again. :-)
Cheers,
Bart