RE: [PHP-DB] MS Access file

Grant, You basically setup a piggyback. 1. Install OpenLink's Multi-Tier drivers, with your Linux box as the client and the Win box as the server, and install the ODBC agent on the Win box. 2. Setup a native DSN on the Windows box, using the MS driver. Let's call it 'foo' for this example. 3. Setup a DSN on the Linux box in the odbc.ini. Specify ODBC as the ServerType, the Win box as the Hostname, and 'foo' as the Database name. Ensure your environment variables are set in your PHP (LD_LIBRARY_PATH, ODBCINI, etc) and you should be good to go. The PHP-ODBC HOWTO at http://www.iodbc.org has more details on setting up iODBC. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Grant Johnson [mailto:grant@amadensor.com] > Sent: Wednesday, October 17, 2001 4:23 PM > To: ahill@openlinksw.com > Cc: zpr; php-db@lists.php.net > Subject: Re: [PHP-DB] MS Access file > > > How does that work? Access reads the file, but Access cannot be > connected to from remote, can it? ODBC is to read data sources, not to > export them. ODBC is on the Linux box, and it can connect to ODBC > compliant databases, but since there is nothing to connect to with > Access, how does it work? Weird.... > > Andrew Hill wrote: > > >That's not entirely true. ODBC will allow you to access the Access db on > >Windows from any PHP machine, be it Windows, Linux, etc. > > > >Setting up PHP to use ODBC on a *nix box requires an ODBC Driver > Manager and > >an ODBC Driver. > >A HOWTO for linking PHP with the driver manager (as well as the driver > >manager itself) can be found at www.iodbc.org. > > > >Let me know if you need additional clarification. > > > >Best regards, > >Andrew Hill > >Director of Technology Evangelism > >OpenLink Software http://www.openlinksw.com > >Universal Data Access & Data Integration Technology Providers > > > >>-----Original Message----- > >>From: Grant Johnson [mailto:grant@amadensor.com] > >>Sent: Wednesday, October 17, 2001 2:51 PM > >>To: zpr > >>Cc: php-db@lists.php.net > >>Subject: Re: [PHP-DB] MS Access file > >> > >> > >>PHP on Windows: ODBC, but the file has to be on the same machine or a > >>network drive.. > >>Since Access is really only a single machine local file thing, to use it > >>elsewhere you need to load the data into an actual database server. I > >>reccomend PostgreSQL. For Windows users, check out MySQL. I have heard > >>it works well on Windows as well as the *nix's. PostgreSQL works on > >>Windows, but it is a little tricky to set up on Windows (super easy on > >>Linux), and since it only works under CygWin, it is noteably slower than > >>on a *nix. CygWin is very cool, but since it is an extra compatibility > >>layer, performance suffers. > >> > >>zpr wrote: > >> > >>>Hi all.. i have a MS Access database file.. and i wonder how > to access it > >>>from > >>>php..? i don't have a SQL server or something like that, is > it possible? > >>> > >>>//Gabriel > >>> > >>> > >>> > >> > >> > >>-- > >>PHP Database Mailing List (http://www.php.net/) > >>To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >>For additional commands, e-mail: php-db-help@lists.php.net > >>To contact the list administrators, e-mail: php-list-admin@lists.php.net > >> > >> > >> > > > >