How to use Visual Foxpro ODBC drivers to connect to SAP B1 Hana?

[patrice_vigier]

Hello,

Is anyone ever use VFP to connect to the Hana database/tables?

I face several problems.

1) For example I cannot access the OITM table because "too many columns" (over 255)

2) I Cannot select a column, for example

connector = "DRIVER={HDBODBC32};UID=SYSTEM;PWD=mypassword;SERVERNODE=194.x.xxx.xxx:30015;DATABASE=MYDATABASE"

SQLExec(connector, "SELECT ItmsGrpCod from mydatabase.OITB", "zoitb") do not return anything

while

SQLExec(connector, "SELECT * from mydatabase.OITB", "zoitb") return all columns and data...

Basically it does not allow you to get around the "too many columns" limitation because you cannot select them!

Do you have any idea????

Thank you

[patrice_vigier · Accepted solution]

Dear Patrice,

Answer to yourself....

Put the field name into cote like this :

SQLExec(connector, 'SELECT "ItmsGrpCod" from mydatabase.OITB', "zoitb")

and this will allow you to go around the 255 limitation.