Unable to connect PHP to HANA DB on Windows 64 bit-machine

[Former Member]

Hi All,

Anybody knows that how to make a db connection to HANA DB using python on windows 64 bit- machine, with DSN or without DSN ?

I scanned the discussion n blogs, but still not able to make connection.

Please help me out.

[Former Member]

Hi Michael,

I am successfully able to make connection to HANA DB using php. I created ODBC connection using DSN and its working for me.

I follow the steps as you told me. and its working.

[Former Member]

Had similar problems.

Documented my learnings here http://scn.sap.com/community/developer-center/hana/blog/2013/01/21/php-rocks-on-sap-hana-too#comment...

[rama_shankar3]

Please go through the install / admin guide for HANA.  Basically, you will use the HANA client and and system DSN to connect to HANA DB.

[Former Member]

Hi Naveen,

Take a look at the following thread;

http://scn.sap.com/thread/3276145

Hope that helps.

[Former Member]

Hi Michael,

Do you know how to connect PHP to HANA DB on Windows 64 bit-machine, with DSN or without DSN ??

[Former Member]

Hi Naveen,

Again I do not develop in php, but can't you just install the HANA Client tools on the server which will give you the ODBC drivers. Create an ODBC connection.

Then from your php application do the following

$conn=odbc_connect('myHana','suername','password');

$sql="SELECT NAME FROM CUSTOMERS";

$rs=odbc_exec($conn,$sql);

[former_member184713]

My guess is that you are trying to use the 32bit driver on your 64bit application. They have different name. 64bit driver is HDBODBC, and 32bit driver is HDBODBC32. As long as you have the odbc driver installed, it should work.

For 64bit driver on a 64bit computer, you can check in the registry in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\