Re: psqlODBC / install / WinXP

> -----Original Message-----
> From: Stuart Kendrick [mailto:skendric(at)fhcrc(dot)org]
> Sent: 20 July 2004 13:42
> To: Dave Page
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: RE: [ODBC] psqlODBC / install / WinXP
>
> hi dave,
>
> -yes, for better or worse, i log in with administrative
> privileges routinely, and this was the case when i ran the install.

OK, good.

> -i'm staring at
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers ,
> with the window for 'ODBC Data Source Administrator' open on
> another monitor ... and in fact, the list in
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers is
> *identical* to the list in the GUI tool ... except that the
> reg key has "(Default)" as its first entry (whereas the GUI
> tool does not), and the reg key contains three entries near
> the bottom, which the GUI tool does not:
>
> PostgreSQL
> PostgreSQL Legacy
> PostgreSQL Unicode (Beta)

OK, that's good (though you should see the last three entries in the
driver manager as well).

> -so the GUI tool must be doing something more than simply
> reading the list of entries at this key and displaying them
> ... since it is choosing to skip the (Default) entry and the
> three PostgreSQL entries. i notice that the 'Data' field of
> each key is 'Installed' (except for the "(Default)"
> entry), which is blank.

Yup, that's normal.

> any insights appreciated,

Some things to check:

1) Do psqlodbc.dll, psqlodbc25.dll 9might be psqlodbc30w.dll) and
psqlodbc30w.dll exist in C:\Windows\System32 (or whereever your system32
directory is)?

2) Under HKEY_LOCAL_MACHINE\Software\ODBCINST.INI\, there should be reg
keys for 'PostgreSQL', 'PostgreSQL Legacy' and 'PostgreSQL Unicode
(Beta)'. Under each of those should be string values for 'Driver' that
point to the corresponding dlls.

Regards, Dave.