Skip site navigation (1) Skip section navigation (2)

Re: psqlODBC / install / WinXP

From: Stuart Kendrick <skendric(at)fhcrc(dot)org>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlODBC / install / WinXP
Date: 2004-07-20 21:03:49
Message-ID: Pine.LNX.4.61.0407201339470.3307@vishnu.fhcrc.org (view raw or flat)
Thread:
Lists: 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(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.
>
>


In response to

pgsql-odbc by date

Next:From: Joost KraaijeveldDate: 2004-07-20 22:25:24
Subject: SQLExecute fails question
Previous:From: Dave PageDate: 2004-07-20 20:55:21
Subject: Re: 07.05.0001 Snapshot available

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group