Re: 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/psqlodbc-07_05_0001
> .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.
>
>