Re: psqlODBC / install / WinXP
От | Janet Borschowa |
---|---|
Тема | Re: psqlODBC / install / WinXP |
Дата | |
Msg-id | D486606E7AD20947BDB7E56862E04C39BDC6CF@cvo1.cvo.roguewave.com обсуждение исходный текст |
Ответ на | psqlODBC / install / WinXP (Stuart Kendrick <skendric@fhcrc.org>) |
Ответы |
Re: psqlODBC / install / WinXP
|
Список | pgsql-odbc |
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) >
В списке pgsql-odbc по дате отправления: