eFashion and Island Reorts - Cannot load in crystal enterprise under normal user
Hi,
I am having a strange issue with efashion and Island Resorts. I have converted them from unv to unx. The following are working
Issue:
1. Cannot run under any other user with Crystal enterprise. (only works with admin)
2. Cannot run under Web intelligence Rich client. (only works with admin)
Tried:
1. Recreating universe from orginals
2. Changing security access to connections.
3. Re-creating ODBC on server.
4. Tried on Win7 x64 bit machine (Tried also Adding ODBC to shared access file on server)
5. Tried on Win XP 32 bit machine (Tried also Adding ODBC to shared access file on server)
Running:
- BOBJ SP4 Patch 3 Server/Client/Crystal Enterprise (Windows 2008 datacenter)
- Windows 7 x64 bit for local machine
Outcomes:
1. Can run sucesfully in Web Intelligence Web Admin account and Power user
2. Can run via Crystal Enterprise and Webi Rich Client when logged in as admin
3. Cannot run via Crystal Enterprise or Webi Rich Client when logged in as Power or any other user.(able to view the query, move objects into panel but when i press refresh the error below occurs)
The error i am getting from webi on the client machine is .... I believe if i resolve this issue it will resolve the my crystal issue to
Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (IES 10901) (WIS 10901)