Solution for pgsql odbc driver missing from Windows data sources drivers list

Hi, I installed PostgreSQL but the pgsql ODBC driver didn't appear in the W=
indows XP Data Sources drivers list. I looked in the Windows registry and a=
ll the keys were the way they should be, but still no PostgreSQL ODBC drive=
r!



Googling, I found the following entry on the Oracle(!) forum (see http://fo=
rums.oracle.com/forums/thread.jspa?threadID=3D254411&tstart= 3D15):



dcpanton@canada... =
=20=
=20=
=20=
=20=
=20=
=20=
=20
wrote:
=20=
=20=
=20=
=20=
=20=


> Re: ODBC Driver Install Problem. =20=
=20=
=20

> Posted: =
May 22, 2005 4:57 PM =
=
in response to: =
raiford =
=
=
=
=
=
Reply =20=
=20=
=20=
=20=
=20=
=20

=20=
=20=
=20=


> dunno if this will fix your problem, but it fixed mi=
ne...



> Apparently there's a bug in a version of MySQL that inserts an invalid en=
try into



> HKLM\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers



> Solution:



> Export the "HKLM\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers" key.



> edit the exported file to remove the line "@=3D" and save it. (anything b=
elow this line doesn't show up in ODBC Admin list)



> delete the registry key.



> merge your saved key file.




This worked in my situation.

Howard B. Golden



---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate