Advanced ETL Pro (64 Bit) points to 32-bit ODBC manager?

When I click on ODBC Data Source Administrator, the 32-bit version comes up (not the WoW64 version). Perhaps that's a non-issue.


The issue I am really having when I refer to an ODBC source, I get the SQL Connect Failed: IM014. The connection tests fine in 64-bit so I am not sure why I am having this issue.


Thoughts.

Just a side note, I downloaded a 32-bit version of Advanced ETL Pro. I could connect just fine. I couldn't find other things I like, like the repository.

Configuring 64 bit version is tricky.
64bit version works only with 64 bit drivers
32bit with 32bit drivers.
So in order to use 64 bit version you must install latest 64 bit version drivers and create relevant 64 bit odbc dsn's

If you want to work with MS Access you have to follow this guide
www.etl-tools.com/articles/64-bit-etl.html
(towards the end)

PS: Just because we do have 64 bit version does not mean that it is faster.
We do recommend using it when you need a lot of memory

I hope this information is useful for you