Data Source not found in Excel (Data/From other sources/From MS Query) connecting to PostgreSQL

0

I set up an ODBC connection to a datamart with c:\windows\SysWOW64\odbcad32.exe.

I set up my Data Sources in the System DSN tab using the PostgreSQL ANSI driver.

When I go into Excel bring in the external data (Data Tab/From Other Sources/From MS Query) my connection is not listed in the box.

How can get my Data Source viewable here?

Would really like to get this resolved as I have numerous customers with the same issue.

WindowsOS ver is 7.0, Excel is from Office 10 (ver 14.0.6129.500 - 64 bit).

Brigitte Lmsg Walsh

Posted 2013-04-21T18:15:17.013

Reputation:

Is question does not fit right here. Please read: http://stackoverflow.com/faq

– TheHippo – 2013-04-21T20:05:54.930

have you tried browsing for it? – K_B – 2013-04-21T20:06:22.837

You're using 64-bit Office but you set up a 32-bit ODBC connection. You have to set up the 64-bit ODBC connection (use the odbcad32.exe that's not in SysWOW64) using the 64-bit PostgreSQL ODBC driver, or use a 32-bit Excel. (Will post as answer if/when this question gets reopened and migrated; please comment here if the question gets reopened). – Craig Ringer – 2013-04-22T00:24:36.003

Answers

1

You're using 64-bit Office but you set up a 32-bit ODBC connection by using c:\windows\SysWOW64\odbcad32.exe instead of ``. You have to set up the 64-bit ODBC connection (use the odbcad32.exe that's not in SysWOW64) using the 64-bit PostgreSQL ODBC driver, or use a 32-bit Excel.

You may need to install a 64-bit version of psqlODBC if you don't already have one installed.

See Microsoft KB942976.

Craig Ringer

Posted 2013-04-21T18:15:17.013

Reputation: 2 630

Asked: 2013-04-21T18:15:17.013

Viewed: 2 726 times

Active: 2019-03-09T05:02:45.653