I would like to connect to an access database using ODBC and PHP.
However, I am a beginner and am unsure how to start.. I have set up the ODBC driver but this is merely on my computer, not on the server... how do I make the connection?? help!
PHP with ODBC and Access
Moderator: General Moderators
Mhh well to connect to a Access DB
..that s it.. then you can do whatever you want
Here you can have all the info (left column) about odbc commands

Code: Select all
$connect = odbc_connect("db_name", "user", "password") or die("Connection failed");
//here you make the query you want : for exemple i m Selecting (ALL) my field from my table
$query = "SELECT * FROM my_table";
$queryexe = odbc_do($connect, $query);Here you can have all the info (left column) about odbc commands
Well instead of being blunt, just explain in details what you need. Draco might be able to help you then.nads1982 wrote:thats not what I asked...
You want to know if you can connect with the Access interface to the MySQL database? If that's it, the ODBC drivers will work fine locally. For a distant server your provider must accept persistant connections and give you the address of the server.