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(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/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.
>
>