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(at)roguewave(dot)com http://www.roguewave.com
>
>
>
>
>> -----Original Message-----
>> From: Stuart Kendrick [mailto:skendric(at)fhcrc(dot)org]
>> Sent: Wednesday, July 21, 2004 12:44 PM
>> To: Dave Page
>> Cc: pgsql-odbc(at)postgresql(dot)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(at)fhcrc(dot)org]
>>>> Sent: 20 July 2004 22:04
>>>> To: Dave Page
>>>> Cc: pgsql-odbc(at)postgresql(dot)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(at)postgresql(dot)org)
>>
>