I am unable to connect to any source databases using an ODBC connection. I have several dsn files in the standard location (C:\Program Files\Common Files\ODBC\Data Sources). These dsn files all provide proper connectivity withing other client apps.
MDM IM gives the following error message when I try to connect:
Login Error:[Microsoft][ODBC Driver Message]Data source not found and no default driver specified.
I do not get this error in any other client apps. I tried both with and without the .dsn extension. I have some dsn files that connect to SQL Server databases and some that connect to Oracle databases -- none work in MDM IM, but they all work in other client apps. I also tried giving the full path to the dsn file, but then I get a "source name too long" message.
Any suggestions would be appreciated.