on 06-07-2017 7:08 PM
error.pngThe client tool is connected with the server but the web intelligence client tool is not able to fetch data from efashion universe.
I have set up system dsn in odbc for both server side and client side. Still unable to access it .
Error Description : General error not enough information to connect to this DSN with SQL connect.
See the screen shot for detailed error description.
Please provide useful details (workflows, errors) or no one will be able to give you any useful answers.
This is not your first question like that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Denis
Yes I did looked at the mentioned KBA but it did not help my situation.
I am able to edit the universe but testing the connection gives the same error.
One thing that I am not sure about is that what should be selected for database when creating odbc connection on the client side. I mean how can I point odbc connection on client side to the .mdb database located on the server side.
screenshot is attached where this task needs to be performed.
you can't, Access DB is not sharable/network accessable.
efashion db is part of client install as well, so the system DSN on client machine points to local mdb.
Or you place efashion DB on network share and make your DSN's point to it.
Thank You Denis
I moved that data into sqlanywhere database and changed the connection for efashion universe. It is working fine now.
I have one more related question regarding excel connection through odbc.
Do we need to select a workbook while creating odbc connection on the client side for Microsoft Excel too. I am trying to make a relational connection in IDT but my excel workbook is placed on the server side. Should I place my workbook on network share or is there any way to connect with the server's workbook.
this should be asked under Semantic layer tag. I have no idea.
copy the .mdb file from your server to your local machine.after that point the old car connection to your local mdb file
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank You Amit
I moved that data into sqlanywhere database and changed the connection for efashion universe. It is working fine now.
I have one more related question regarding excel connection through odbc.
Do we need to select a workbook while creating odbc connection on the client side for Microsoft Excel too. I am trying to make a relational connection in IDT but my excel workbook is placed on the server side. Should I place my workbook on network share or is there any way to connect with the server's workbook.
Is it required in universe?
If not really required you can connect directly in rich client or bi launch pad to excel file.
In universe or webi rich client you need to place the file at same location in both the places.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.