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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx