configuring odbc with php & oracle.

There are some steps for configuring odbc with php & oracle.

Req: HTTPD, PHP, Oracle should be installed and functioned properly.

Step 1. Install rpm package of unixODBC, which is available in rhel dvd.

step 2. $ odbcinst -j

unixODBC 2.2.7
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /home/auser/.odbc.ini

step 3. For Oracle you need to copy all the libs to /usr/lib

cp /usr/lib/oracle/11.1/client/lib /usr/lib/

step 4. /etc/odbcinst.ini Contents:

[Oracle]
Description = Oracle ODBC Connection
Driver = /usr/lib/oracle/11.1/client/lib/libsqora.so.11.1
Setup =
FileUsage =
CPTimeout =
CPReuse =

[Sybase]
Description = Sybase ODBC Driver
Driver = /opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
FileUsage = -1

step 5. /etc/odbcinst.ini Contents:

[Oracle]
Description = Oracle ODBC Connection
Driver = /usr/lib/oracle/11.1/client/lib/libsqora.so.11.1
Setup =
FileUsage =
CPTimeout =
CPReuse =

[Sybase]
Description = Sybase ODBC Driver
Driver = /opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
FileUsage = -1

Step 6. Testing DSN connections
bash-2.05$ isql -v my_dsn username password
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>

Step 7. PHP Script to Test ODBC Connectivity:


$query = “select * from table_name”;

$conn = odbc_pconnect(“DSN”, “username”, “password”);

if(!$conn) die(“Connection failed”);

if($result = odbc_exec($conn, $query)) {

echo “Query returned : ” . odbc_num_rows($result) . “rows”;

odbc_result_all($result);

}

?>