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