Skip to Content
0
Former Member
Jan 03, 2012 at 02:55 PM

Information Design Tool - Multiple Datasources Troubleshooting ???

79 Views

Hello everybody,

I am looking for a solution that is caused by Information Design Tool (IDT). After creating relational database connection within a project, and publishing them in the repository an error occurs. If I create a new data foundation for multiple data sources and select the published connections an exception is thrown. If I use the data foundation as a single source both connections working. They dont work on a multisource enabled connection

The message is: Error returned by host

If I select the connection with the error and try manually test than the following error description will be displayed

Data Federator Driver Server Connector 'MSSQLSERVER' The database has reported an Exception: MicrosoftODBC Driver Manager Data source name not found and no default driver specified (SQLState: IM002, Vendor code: 0)

What is the reason for the problem? I use the IDT client version 14.0.0.v20110205-0760.

I have created System DSN and they work. If I look up the connection details (*.cnx) I can see table content. I am just not able to use them for a data foundation.

Best regards,

Thom