on 09-27-2013 6:43 AM
Hi,
I wanted to test the Multisource Universe having BW cube and relational database. So I created a Relational JCO connection to BW cube and another MS Access 2007 database. In order to connect to MS Access database, I created a ODBC connection on local machine as well as on the BO server with the same name (System DSN). When I test the individual connections (BW and ODBC) both are successful but when try to create a Data Foundation layer using these 2 connections, on ODBC connection I am getting below error when trying to insert the tables from it.
My operating system is 32 bit and I used 32 bit ODBC driver to create the connection (C:\Windows\system32\odbcad32.exe).
Request your help.
Thanks,
Abhijit
Where is the access database?
Are you using a network drive? If so, has the BO service account got permissions to that drive?
Have you specified a utc address for it - \\servername\share rather than f:\ for example?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create 64-bit odbc connection on your BOBJ server.
Regards,
Ambreen
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.