Thread: Still can't find ODBC driver in Data Source Administrator

Still can't find ODBC driver in Data Source Administrator

From

"Gene Farrelly"

Date:

06 October 2004, 06:11:23

I've installed the latest postgres ODBC driver from the gborg site. I've confirmed that the driver appears in my registry and in the odbcinst.ini file. I ran a recent MDAC update from Microsoft (v2.8). Yet, I can't seem to get the postgres driver to come up in the windows Data Source Administrator.

I need to set up the ODBC driver so I can run reports on the data in our postgres database.

Please let me know if you have any suggestions of things for me to try.

Thanks!

Re: Still can't find ODBC driver in Data Source Administrator

From

"Dave Page"

Date:

06 October 2004, 11:26:16

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Gene Farrelly
Sent: 06 October 2004 03:11
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Still can't find ODBC driver in Data Source Administrator

I've installed the latest postgres ODBC driver from the gborg site. I've confirmed that the driver appears in my registry and in the odbcinst.ini file. I ran a recent MDAC update from Microsoft (v2.8). Yet, I can't seem to get the postgres driver to come up in the windows Data Source Administrator.

I need to set up the ODBC driver so I can run reports on the data in our postgres database.

Please let me know if you have any suggestions of things for me to try.

Hi,

Can you confirm the existance of the resistry keys in http://gborg.postgresql.org/project/psqlodbc/cvs/co.php/psqlodbc/psqlodbc.reg?r=1.4 please, and also check the locatiopn of psqlodbc.dll on your system? It should be in your Windows\System32 directory, unless there is a full path to it specified in the registry, in which case it should be there.

Regards, Dave.

Re: Still can't find ODBC driver in Data Source Administrator

From

"Dave Page"

Date:

06 October 2004, 16:05:21

From: Gene Farrelly [mailto:Gene.Farrelly@flashpoint.com]
Sent: 06 October 2004 12:37
To: Dave Page
Subject: RE: [ODBC] Still can't find ODBC driver in Data Source Administrator
Dave –

Thanks for the note. I checked my registry, and everything matches the information on the link you sent me, except that I have full path names to the drivers and not just the file names themselves, i.e.
REGEDIT4
 
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]
 
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"PostgreSQL"="Installed"
 
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL]
"APILevel"="1"
"ConnectFunctions"="YYN"
"Driver"="C:\WINDOWS\System32\PSQLODBC.DLL"
"DriverODBCVer"="03.00"
"FileUsage"="0"
"Setup"="C:\WINDOWS\System32\PSQLODBC.DLL"
"SQLLevel"="1"
"UsageCount"=dword:00000001
And I’ve confirmed the existence of the psqlodbc.dll file in my C:\WINDOWS\SYSTEM32 directory.

Let me know if I should try something else. I’ve tried reinstalling the driver, rebooting before and after, and nothing seems to resolve the issue.

I assume you are looking on the drivers tab in the driver manager and not one of the datasource tabs?

Regards, Dave