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).

Improve this question
3
  • Is question does not fit right here. Please read: stackoverflow.com/faq
    – TheHippo
    Apr 21, 2013 at 20:05
  • have you tried browsing for it?
    – K_B
    Apr 21, 2013 at 20:06
  • 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
    Apr 22, 2013 at 0:24

1 Answer 1

Reset to default
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.

Improve this answer

You must log in to answer this question.