Re: psqlODBC / install / WinXP

hi janet,

good eyes ... turns out, that was a typo in my e-mail ... the entries in
the registry are spelled consistent ... "PostGreSQL" ...

--sk

On Thu, 22 Jul 2004, Janet Borschowa wrote:

> Hi Stuart,
> Perhaps there's a problem with the names in the registry as PostgreSQL !=
> PostGresSQL.
>
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL
>
> ^^^^^^^^^^^
> (Default)        REG_SZ        (value not set)
> APILevel        REG_SZ        1
> ConnectFunctions    REG_SZ        YYN
> Driver            REG_SZ        PSQLODBC.DLL
> DriverODBCVer        REG_SZ        03.00
> FileUsage        REG_SZ        0
> Setup            REG_SZ        PSQLODBC.DLL
> SQLLevel        REG_SZ        1
> UsageCount        REG_SZ        0x00000001 (1)
>
> and HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
> PostGresSQL        REG_SZ        Installed
> ^^^^^^^^^^^^^
>
> ========================
> Janet Borschowa
> Software Engineer, Database Products
> Rogue Wave Software, a QUOVADX(tm) Division
> (541) 753-1931   FAX: (541) 757-4630
> mailto:borschow@roguewave.com  http://www.roguewave.com
>
>
>
>
>> -----Original Message-----
>> From: Stuart Kendrick [mailto:skendric@fhcrc.org]
>> Sent: Wednesday, July 21, 2004 12:44 PM
>> To: Dave Page
>> Cc: pgsql-odbc@postgresql.org
>> Subject: Re: [ODBC] psqlODBC / install / WinXP
>>
>>
>> hi dave,
>>
>> i like manual approaches ... gives me a chance to see more
>> precisely what
>> might be going awry.
>>
>> ok, i used the uninstaller from the 'Add/Remove Programs'
>> Control Panel.
>> That resulted in the registry entries disappearing, but the
>> three files in
>> c:\windows\system32 were still there ... so i deleted them.
>>
>> then, i copied psqlodbc.dll from the psqlodbc-07_05_0001.zip file to
>> c:\windows\system32.  and double-clicked on the reg file to
>> import it into
>> the registry.  now, i can see a 'PostgresSQL' key:
>>
>> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL
>>
>> (Default)        REG_SZ        (value not set)
>> APILevel        REG_SZ        1
>> ConnectFunctions    REG_SZ        YYN
>> Driver            REG_SZ        PSQLODBC.DLL
>> DriverODBCVer        REG_SZ        03.00
>> FileUsage        REG_SZ        0
>> Setup            REG_SZ        PSQLODBC.DLL
>> SQLLevel        REG_SZ        1
>> UsageCount        REG_SZ        0x00000001 (1)
>>
>> and HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
>> PostGresSQL        REG_SZ        Installed
>>
>> and of course the file itself:
>> C:\WINDOWS\SYSTEM32>dir psql*
>>   Volume in drive C has no label.
>>   Volume Serial Number is 2CC5-AF5A
>>
>>   Directory of C:\WINDOWS\SYSTEM32
>>
>> 07/21/2004  08:38 AM           356,352 psqlodbc.dll
>>                 1 File(s)        356,352 bytes
>>                 0 Dir(s)   2,326,204,416 bytes free
>>
>> C:\WINDOWS\SYSTEM32>
>>
>> but ... the GUI tool still doesn't display a 'PostGres'
>> choice, when i
>> click on the 'Drivers' tab.
>>
>> if you can think of another approach, do let me know.  but
>> i'm guessing
>> that you have offered me all your tricks ... in any case,
>> thank you for
>> your efforts on my behalf!
>>
>> i've been wanting to use visio to document the schema in my postgres
>> databases ... i like visio and use it frequently for other
>> tasks.  but i
>> bet that other tools exist, perhaps in the Unix world -- i'll
>> go hunting
>> for them.
>>
>> --sk
>>
>> On Wed, 21 Jul 2004, Dave Page wrote:
>>
>>>
>>>
>>>> -----Original Message-----
>>>> From: Stuart Kendrick [mailto:skendric@fhcrc.org]
>>>> Sent: 20 July 2004 22:04
>>>> To: Dave Page
>>>> Cc: pgsql-odbc@postgresql.org
>>>> Subject: RE: [ODBC] psqlODBC / install / WinXP
>>>>
>>>> hi dave,
>>>>
>>>> C:\WINDOWS\SYSTEM32>dir psqlodbc*
>>>>   Volume in drive C has no label.
>>>>   Volume Serial Number is E460-3235
>>>
>>> Hi Stuart,
>>>
>>> Hmm, how strange. OK, let's try this the simple way. Please
>> uninstall
>>> the driver and then check that those three files and the various
>>> registry entries have gone. If they do not go, they can be manually
>>> removed.
>>>
>>> Then, download
>>>
>> ftp://ftp.postgresql.org/pub/odbc/versions/snapshots/ps> qlodbc-07_05_00
>>> 01
>>> .zip, extract the files, and copy the .dll into your
>> Windows\System32
>>> directory. Finally, double click the .reg file to merge it into the
>>> registry.
>>>
>>> That's the simple, manual way to install the driver - if
>> that doesn't
>>> work, then there is something seriously wrong :-(
>>>
>>> Regards Dave.
>>>
>>>
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>>     (send "unregister YourEmailAddressHere" to
>> majordomo@postgresql.org)
>>
>