cancel
Showing results for 
Search instead for 
Did you mean: 

Data source name not found and no default driver specified

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Vassilis 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

Former Member
0 Kudos

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