Helpful Information

Category: Programming Languages

mdb file access

Hello,
I have mdb FILE and want to READ information from it. How may I do it?
Thank you.

[This message has been edited by starelni (edited 06-29-99).]

You need to specify an odbc datasource then you can use the following code to connect:[code]

$sql="SQL STATEMENT HERE";
$connection=odbc_connect(dsn,user,password);
odbc_exec($connection, $sql);

This will open up the database for read/write you can now manipulate the chosen variables.

------------------
Stirling Hughes
DesignMultimedia
http://www.designmultimedia.com

To create a new datasource, open control panel > ODBC Date Sources. Select the System DSN tab select "Add", and ueses the access drivers. It should be pretty self explanatory from there.

A good place to start with the ODBC function calls is just looking up the functions in the php manual.

Hi.
I wonder how to set up ODBC, and add DSN in linux/apache.
Thanks in advice.

http://www.stata.com/support/faqs/data/odbcmu.html
check that out