Hi everybody,

I've lost my driver install and I can't recreate it... I'm trying to
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?

Thanks in advance!

Cheers,
Bart

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

> 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.

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\Post greSQL
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

I hope I help you.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

unsubscribe

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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\Post greSQL
> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings