Skip to Content
0
Nov 04, 2012 at 11:51 PM

How can I connect SQL Server BI tools to HANA? I'm getting ODBC error with v38

731 Views

Is there a trick to getting the SQL Server BI tools to connect to HANA. I was trying to use SQL Server 2012 Reporting Services and SQL Server Data Tools to build reports to try and connect and I'm getting a consistent failure when setting up a data link to the ODBC driver. I'm using v38 of the client tooll x64 bit version.

I first setup a User (or System or File) DSN using the ODBC Data Source Administrator - no problems with connecting via the tool using Server:port imdbhdb:30015 for the port. Clicking Connect prompted me for Use and Password and connected without SSL and got a Connect sucessful! message.

When I go into SQL Server Data Tools or use the SQL Server 2012 Report Builder to create a Data Link - this is where the problems start. The example I'll walkthru here is creating a Tabular Data model for Analysis Services using SQL Server Data Tools.

  1. Create a Tablular model project
  2. Choose the Model menu and select the Import from Data Source... command that launches the Table Import Wizard.
  3. Choose the Others (OLEDB/ODBC) source which uses the OLEDB for ODBC provider to make the connection
  4. Click the Build... command to build my connection string
  5. I select my HANA DSN, enter the user name and passwod and then click the Test Connection button.

This results in the very unexpected error:

Test connection failed because of an error in imitializing provider. [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

Any help would be greatly appriciated.

Regards,

Bill