Skip to Content
0
Former Member
Sep 15, 2005 at 03:14 PM

Unable to use ODBC source in MDM Import Manager

24 Views

Hello,

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.

Thanks,

Vince Moore