Access

[Brian56]

Anyone know of a way to connect to MS Access DB ?

Thanks

Brian

 

[sleipnir214]

Running PHP on a Win32 box? Using PHP's ODBC family of functions:

http://www.php.net/manual/en/ref.odbc.php

Running PHP on a unix-like OS? Good luck.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[vbkris]

hey sleipnir, i have a small doubt (Note: i havent searched the access forum. but will do)..

if Access is installed does ADO also get installed? or is it a VB control? cause all examples in acces help use ADO...

Known is handfull, Unknown is worldfull

 

[sleipnir214]

I have no idea. I use PHP from Linux and all my code communicates with database servers by native communications libraries.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[xml2]

Hi,

I'm having a similar problem here too. I have an MsAccess database on a WinXP computer and PHP running on a linux machine. Afters hours of trail&error I don't find a way to let my PHP script connect with the access database.

System DNS is set up and works fine, tried the comments on php.net too (regedit and change path to network path, .. ), but none off them were successfull.

Normally I wouldn't use MsAccess as database but it's for a db migration..

Thanks for your time,

T.

 

[vbkris]

did u try odbc commands? does ur script have permissions for the folder that holds the mdb file???

Known is handfull, Unknown is worldfull

 

[xml2]

what do you mean by "odbc commands"? I've installed unixODBC on the linux server so odbc is supported... I use odbc_connect() to make the connection (but that doesn't work.. )

I don't think windows works with permissions, so guess this is not an issue. (?)

 

[vbkris]

>> I have an MsAccess database on a WinXP computer and PHP running on a linux machine

oops, didnt read it correctly.

the database is on a different machine???

Known is handfull, Unknown is worldfull

 

[xml2]

Correct, the database is on a different machina. I'll explain the situation a little more..

1. WinXP computer with MsAccess database
2. Linux (Mandrake) server with php/mysql/..

2 needs to connect to 1, retrieve the data stored in the MsAccess database and put it in the mysql on 2. The scenario (=script) works fine when everything is on the same machine.. too bad this isn't the real situation..

Hope you guys can help me out here.

 

[vbkris]

the system DSN that u use has a path right? where is it pointing to?

are both the systems connected to the net???

Known is handfull, Unknown is worldfull

 

[xml2]

***) I'v made a System-DNS via the windows control pannel.
- Name: vlor_gebruikers
- Driver: Microsoft Access Driver (*.mdb)
- Then changed the path via regedt32 to \\192.168.1.105\vlor_db\Gebruikers.mdb (See:

http://php.belnet.be/manual/en/function.odbc-connect.php#52556

and

http://php.belnet.be/manual/en/function.odbc-connect.php#52556

***)
To connect with it I have:
function dbODBCConnect() {
$odbc_naam = "\\\\192.168.1.105\\vlor_db\\Gebruikers.mdb";
$connectie = @odbc_connect($odbc_naam,'','');
return $connectie;
}

Thanks for replying

 

[xml2]

Sorry, php.net usernotes are:

http://php.belnet.be/manual/en/function.odbc-connect.php#38471

and

http://php.belnet.be/manual/en/function.odbc-connect.php#52556

 

[ingresman]

Did you get this to work ??. I can't recall that linux has an ODBC driver, but there is an opensource project call mdb tools (

http://mdbtools.sourceforge.net/)

which may help you out