on 07-25-2012 1:39 PM
Hi all,
I hope someone can help me overcoming a problem that I have with Information Design Tool (IDT).
I have 2 distinct Microsoft SQL 2008 databases and I am trying to create a Universe based on both databases.
I am able to create the relational connections and publish them to the server. Then I create, successfully, a multisourced Data Foundation and select the relational connections (.cns) previously created. However, when I try to expand either one of the table catalogs it gives the following error:
[Data Federator Driver] [Server] [Connector 'TEST'] 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)
Thanks in advance.
Best Regards,
Tabrez
Hi,
It is the Data Federator service (which is part of the ADaptive Processing Server) on BIPlatform which processes the DataAccess for Multi source universes .
--> So you must have the 64-bit driver and DSN setup on the Server. Local connections created in the IDT Client would use 32-bit driver. Makes sure both 32 and 64 DSN have exactly the same connection name.
If using jdbc, You would also need to unpack .jar files into a manually created folder under ..\dataAccess\connectionServer\jdbc\drivers\datafederator\
for example ..\drivers\datafederator\sybase\sybase.jar
regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I hope u guys can help me with this related problem. All i did was rename the datasource names and re-point to a new default DB via ODBC on the server. Now in IDT, when I try to edit the connection, the new names don't show up in the drop down. it still shows the old names and tests successfully. So i decided to type it in manually, but when I test it, I get this error.........
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
Thanks
Hi,
I am getting the same above error. Am using Microsoft SQL server 2005 as one datasource and Microsoft Access as a secondary datasource. After creating DF, when i try to insert the tables, i get the same message. I hope someone out there could help us resolve this issue.
Regards,
Noman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.