This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 69%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Hello,
I'm trying to develop a tabular project for SSAS 2019 on VS2022 17.2.2.
The data source is our HANA database (64bit). THe SSAS 2019 enterprise is 64bit.
The ODBC driver is "HDBODBC". It is a 64bit driver.
As VS2022 is a 64bit application, I thought there would be no issue to use the 64bit driver.
But I cannot create the data source in the tabular project.
The connection string is "servernode=172.20.180.10:30015;driver={HDBODBC};serverdb=SHANG_PB1;currentschema=SHANG_PB1".
This connection string can be used in Power BI desktop without any problem.
But in VS2022, it does not work.
It also allows me to enter the credential.
But after I click "Connect", it gives me this error, "Unable to connect"."The 'Driver' property with value '{HDBODBC}' doesn't correspond to an installed ODBC driver."
It looks like at this point the program is not supporting the 64bit driver.
How is this happening?
But if I try to use the 32bit driver at the first place, it doesn't work, either. It even cannot pass the connection string check.
How can we use the HANA ODBC 64bit driver in VS2022?
It looks like a bug.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 75%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWP%3C/text%3E%3C/svg%3E)
This issue has been submitted to the VS feedback site on 2022/5/30.
No update yet.
Hi @Kaniel Wang ,
Thanks for your question.
Regarding your question, please ensure that you create a system DSN rather than a user DSN. Secondly, please make sure you have installed SAP HANA ODBC Driver on Windows 64 Bits.
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thank you for your feedback.
HANA ODBC 64bit driver has been installed.
On the same 64bit windows, I can connect to the HANA database in PowerBI desktop with the connection string.
And the connection string also works in Excel.
But in VS 2022 it's not working.
It says HDBODBC driver is not installed.
Actually, the driver works fine in other applications.
And I also added system DNS in ODBC data source 64bit. It's not working in VS2022 either.
It works only when I also added a system DNS with the same name in the 32 bit ODBC data source.
Hi Zoe,
If the ODBC driver is not installed, there will be an error message on this screen. At this step, the program is looking for a 64bit driver. Only 64bit drivers can be recognized.
And I won't be able to go to the next screen. (the entering credential screen) At this step, the program is looking for a 32bit driver. No 64bit drivers can be recognized. This is the issue.
Hi Zoe,
If the HANA ODBC 64bit driver is not installed, the program will give an error message in the below screen. And it won't let me go to the next step.
At this screen, 64bit drivers are recognized without a problem.
But in the entering credential screen, the program cannot recognize 64bit drivers. And I think at this step the program works in 32bit mode. So only 32bit drivers can be recognized.
And I also created the 64bit system DSN with the name "SHANGSAP".
When I use the "New Data Source" to add the data source in VS2022, it shows correctly in the DSN list. And it is added successfully.
But when I tried to import a table from the data source, it give me this error message.
"The specified DNS contains an architecture mismatch between the Driver (64-bit) and Application (32-bit).
If I create a new query in the power query editor, it also give me the same error message.
So I believe the query editor in VS2022 is still in 32-bit architecture.
It's not a 64-bit version!!Why?
Hi @Kaniel Wang ,
Thanks for your detailed information.
I recommend you to submit the issue to the Microsoft feedback at this link https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0 . This site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 28.999999999999996%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
I am having similar issues except for me the problem starts when I try to process a model. I just installed SSAS 2022 version and have installed ODBC driver version recommended by Microsoft with is 17.10 https://learn.microsoft.com/en-us/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?view=sql-server-ver16. This is the error I get with Tabular Model 2022 while processing
OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [08S01] [SAP AG][LIBODBCHDB DLL][HDBODBC] Communication link failure;-10709 Connect failed (connect timeout expired) ( IP address)
OLE DB or ODBC error: The command has been canceled..
OLE DB or ODBC error: The command has been canceled..