Re: psqlODBC / install / WinXP

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)
>