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

Re: psqlODBC / install / WinXP

From: Stuart Kendrick <skendric(at)fhcrc(dot)org>
To: Janet Borschowa <borschow(at)roguewave(dot)com>
Cc: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlODBC / install / WinXP
Date: 2004-07-23 15:12:45
Message-ID: Pine.LNX.4.61.0407230812030.6846@vishnu.fhcrc.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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)
>>
>


In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2004-07-23 15:20:03
Subject: Re: psqlODBC / install / WinXP
Previous:From: Matt IttigsonDate: 2004-07-23 14:26:53
Subject: Re: psqlODBC / install / WinXP

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