on 06-06-2014 9:37 PM
I used Design Studio 1.3, log on the server and add a new data source. When I selected the Universe I published on the server, Edit the Query, then I click the "Refresh" button on the "Edit Query Specification" dialog window, it showed me :
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I can Execute the query in Rich Client.
The universe is based on Microsoft Access 2010. I saved the .accdb file on my local drive ( not on the server ).
Should I copy my .accdb file to the server?
Thank you very much!
Hi Chunfeng,
When you access a Universe via the BI platform you need to ensure that the BI platform can access the data source. If this runs locally on your client this might not be the case. Are you working in local mode when using the Webi Rich client? If that's the case the client uses the local defined connection.
With kind regards,
Martijn van Foeken
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, M. van Foeken!
I can select the Universe which is published on server via WIRC and can execute the query correctly. But I can't execute the query via Webi by BI launch pad. it shows: [Microsoft][ODBC][ODBC Driver manager] data source name not found and no default driver specified
I am sure that I use C:\Windows\SysWOW64\odbcad32.exe to create the sdn.
It should be a System DSN that is running wherever your ConnectionServer APS is running. Also, I'm assuming you are using the .accdb driver and not trying to use the .mdb driver.
It looks like you are using the 32-bit ODBC DSN (I think that's right for Access driver, maybe try x64 to be sure?) but you may want to make sure that the DSN name matches the one specified in your Universe connection.
Thank you, Michael.
I used .accdb driver and 32bit odbc dsn(from syswow64 dir) on my local computer. I used IDT to create a Universe and published to repository on BI Platform Server( no .accdb driver on that server).
I tried to create universe based on Excel also, because there is odbc driver on the server, and I also use odbc32.exe to add dsn on server(using the same dsn name and selected the excel file on server as data source), but still error.
How can I try 64bit ODBC? I just find SQL Server driver there, I can't find .accdb driver.
Can you access the Universe from WebI (BI launch Pad)?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.