on 10-07-2013 12:39 PM
Hi experts,
We want to modify a Crystal Report but when we try to connect to the database, we get the following message:
Failed to open the connection.
Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
We are using Crystal Reports 2011 with HANA DB
Has anyone faced this issue in the past?
Thank you in advance.
Best Regards
Vasilis Korolis
Make sure you are using the 32bit ODBC Administrator to create your connection.
The 32bit ODBC admin is run from C:\Windows\SysWOW64\odbcad32.exe
The 64bit ODBC admin is run from C:\Windows\System32\odbcad32.exe
The 32 bit driver will show up in the list of available drivers as HDBODBC32.
Follow HANA Academy - Installing the 32bit HANA Client for more detailed explanation
Regards
Shashank K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vassilis
You have to define the ODBC DSN on the machine where your BO Server is installed on. Use the same name for the DSN as the one on your local machine. Make sure to use the 32bit ODBC administrator utility (odbcad32.exe) if your BO server runs on 64bit WIndows.
Your Local DSN should be the same as in Report DSN.
Regards
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.