I am using Information Desing Tool IDT (formerly Information Desinger) to create a new model with mulit data sources - but there are some critical problems with the odbc.
In Win7 I created several odbc sources that I want to use in IDT. The sources are a MS Access, a mySQL as well as a SQL Server 2008 Enterprise database. After creating a project in IDT, I create the data base connections. After creating them, I test it by selecting "show values" within the connection - which was successful. Than I publish it in the repository for make it for data foundation.
The error with the ODBC accurs after selecting the connections from the repository. If I try to open the connection in the section Data Foundation the message
"[Data Federator Driver] [Server] [Connector 'my_SQLSERVER'] The database has reported an Exception: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQLState: IM002, Vendor code: 0)"
Does anybody have an idea where the error comes from and how to fix it?
Thank you in advance.