AnsweredAssumed Answered

How to connect to drill via odbc from PHP?

Question asked by hirohata on Nov 27, 2017
Latest reply on Nov 28, 2017 by cathy

Hello,

 

Are there any samples?
I specified DSN with isql and confirmed that I can connect with ODBC, but I do not know how to connect from php.

 

# isql -v "MapR Drill ODBC Driver 64-bit"
+-------------------------------+
| Connected!                   |
|                                       |
| sql-statement                |
| help [tablename]           |
| quit                                |
+-------------------------------+
SQL>

 

My environment is as follows.
- RHEL6.8
- httpd 2.2.15
- PHP 5.3.3
- php-odbc 5.3.3
- php-pear 1.9.4
(DB pakage installed)
- unixODBC 2.2.14
- Drill 1.10


Please show me if there are any other necessary settings.
Thanks in advance,

 

#drill

#odbc

#php

Outcomes