ODBC on Windows Vista x64

Posted by fransena on 2008-04-23 09:22

If I install the win32 version of ActivePython, all of my ODBC connectors complain that "Data source name not found and no default driver specified in LOGIN". (These all work on several win32 machines around the office)

If I install the x64 version, dbi and odbc don't exist...and neither does the editor!

Basically I'm using ODBC to connect to several iSeries machines. Alternatives? Suggestions?

rmuhlig | Wed, 2008-04-23 12:56

When you're using ODBC in a x32 app on x64 windows you need to add the data sources using odbcad32.exe (located in c:\windows\syswow64). The ODBC Data Source Administrator in control panel only applies to native x64 apps.

fransena | Wed, 2008-04-23 13:00

I figured it was something like that, but didn't even think to look for a 32 bit version of the ODBC applet.