Skip to Content
Former Member
Oct 14, 2011 at 11:50 AM

BO 4.0 ODBC Errors


Hi everybody,

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.