Re: psqlODBC / install / WinXP

hi dave,

C:\WINDOWS\SYSTEM32>dir psqlodbc*
Volume in drive C has no label.
Volume Serial Number is E460-3235

Directory of C:\WINDOWS\SYSTEM32

10/22/2003 02:11 PM 331,776 psqlodbc.dll
10/22/2003 02:12 PM 307,200 psqlodbc25.dll
10/22/2003 02:13 PM 339,968 psqlodbc30w.dll
3 File(s) 978,944 bytes
0 Dir(s) 7,777,390,592 bytes free

C:\WINDOWS\SYSTEM32>

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL
Driver = C:\WINDOWS\System32\psqlodbc.dll

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Legacy
Driver = C:\WINDOWS\System32\PSQLOD~3.DLL\psqlodbc25.dll

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode (Beta)
Driver = C:\WINDOWS\System32\PSQLOD~1.DLL\psqlodbc30w.dll

that "PSQLOD~1.DLL" directory doesn't exist.

ok, so i changed the value for 'Driver' in the last two keys, removing the
"\PSQLOD~3.DLL" bit.

the keys now look as follows:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL
Driver = C:\WINDOWS\System32\psqlodbc.dll

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Legacy
Driver = C:\WINDOWS\System32\psqlodbc25.dll

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode (Beta)
Driver = C:\WINDOWS\System32\psqlodbc30w.dll

but i still don't see the 'PostGres' stuff in the GUI Tool... so i
rebooted ... no change.

curious, hmm? i'm using WinXP with all the patches installed ...

--sk

On Tue, 20 Jul 2004, Dave Page wrote:

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