Re: psqlODBC / install / WinXP
От | Stuart Kendrick |
---|---|
Тема | Re: psqlODBC / install / WinXP |
Дата | |
Msg-id | Pine.LNX.4.61.0407201339470.3307@vishnu.fhcrc.org обсуждение исходный текст |
Ответ на | Re: psqlODBC / install / WinXP ("Dave Page" <dpage@vale-housing.co.uk>) |
Список | pgsql-odbc |
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@fhcrc.org] >> Sent: 20 July 2004 13:42 >> To: Dave Page >> Cc: pgsql-odbc@postgresql.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. > >
В списке pgsql-odbc по дате отправления: