Sap Business One Hana Version Compatibility Follow

Legacy Poster

Good day


We have recently implemented SAP Business One, powered by HANA. 

We want to print labels from Bartender and would like to know which version is compatible to use with SAP B1 HANA.


Currently, we have tried to use an 32bit ODBC driver, which is called HDBODBC32. I can setup the ODBC connection in the Administrative Tools and can connect to the DB.


When trying to connect via Bartender to the DB, we errors:SQL Data type out of range.


When I ignore the message I can select the tables I want to use in my Query.


I change the SQL script to read the following. Click on the checkbox Use Custom SQL and click next 


"OITM"."ItemCode","OITM"."ItemName" FROM "SBK_XXX"."OITM"


It allows my to continue, but it doesn't pull through the information I requested.


It also gives an error " not allowed for result set type FORWARD ONLY".


I would like to know if it is possible to use an ODBC connection and which version is supported.






Please sign in to leave a comment.