DSN on a Linux Server?!?!

[Anon]

I have PHP running on Apache/Linux. I need a DSN to connect to an MS-Access 2000 database. Is it possible to create an ODBC DSN under Linux just as in MS-Windows? If yes, then whats the procedure?

Any help is appreciated!

[Anon]

Sure,

Depending on what ODBC driver manager you use, you will have slightly different setups, but basically an odbc.ini file will contain your DSN, a putenv("ODBCINI=/path/to/odbc.ini"); in your script will locate it for php.

You will need to compile the ODBC layer in, which basically just binds the Driver Manager to PHP, so you still need a driver.

There is a HOWTO on ODBC-PHP at www.iodbc.org that goes into this in some depth.

Hope this helps!

Best regards,

Andrew

Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider