PHP/iODBC/unixODBC

[Anon]

I've installed php via the rpm, and then openlink's odbc drivers, unixODBC, unixODBC-devel, and php-odbc rpms in that order. I'm just a little confused as to what I really need, and how everything works together and in what order. I've installed and removed so many packages over the past few days. I still can't connect to my access database with php, in fact it throws an error on the windows machine when I try to connect from the linux box/php. I can use the odbctest program provided with iODBC to connect and it works fine.

Are the're any good tutorials out there that can give me an overview of how all this works, like is iODBC actually provided by OpenLink Software, and what i unixODBC vs iODBC vs php-ODBC, etc.

[Anon]

Hi Justin,

You might want to see the guidelines in the iODBC.org website maintained by OpenLink Software. The URL is:

http://www.iodbc.org/odbc-phpHOWTO.html

I do not have the details here but it might be the case that your php environment does not refer to the OpenLink iODBC driver manager. Something to the effect of:

<?php

putenv("LD_LIBRARY_PATH=/usr/local/src/odbcsdk/lib");

putenv("ODBCINSTINI=/path/to/odbcinst.ini"); //this location will be determined by your driver install.

putenv("ODBCINI=/path/to/odbc.ini"); //odbc.ini contains your DSNs, location determined by your driver install.

$dsn="DSN=DSN_NAME"; // this is a valid DSN‚ can be tested in odbctest

$user="username";

$password="password";

If the problem still persists please take advantage of our free online support service for initial connection/configuration problems and log a support case. This can be accessed from the following URL:

http://oplweb2.openlinksw.com/product/registerq4.asp?hname=techreq

Best Regards,

Ashok Rautela
Professional Services Consultant
OpenLink Software
Tel: [phone]
http://www.openlinksw.co.uk