RE: [PHP-DB] MS Access file

It's a function of ODBC as to *how* all of that works. Specifically, I don't know and I really don't care. To me, it's like wanting to know *how* a floppy drive formats a floppy when someone clicks the right buttons and/or enters the right MS-DOS command line arguments to commence an initialization of a floppy disk. I know it works. How, I don't care. ODBC (Open DataBase Connectivity) by it's definition carries the name of the machine that the database is present. It carries the name of the database (or in the case of MS Access, probably a *path* to where the .mdb file is). It also carries any user account login/password data as well. It also carries the kind of ODBC driver (like MySQL, MS SQL Server, Oracle, Informix, ODBC, etc.) it is. With all ODBC definitions is a *Data Source Name* commonly referred to as a DSN (a system DSN). That way, from about any machine, you can make a system call to another machine's database by referring to the DSN that you've defined locally. Another thing that can be done is you should be able to chain ODBC DSN's from one machine to the next. That'd allow a call to a local DSN (that connects to another machine as a client does to a server) will in effect refer/connect to a DSN on another machine. -- __ _ Tyler Nally / /__ ____ _(_)___ ____ ____ _________ _ tnally@legion.org / / _ \/ __ / / __ \/ __ \ / __ \/ ___/ __ / 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\____/_/ /_(_)____/_/ \__, / http://www.legion.org /____/ /____/ > -----Original Message----- > From: Grant Johnson [mailto:grant@amadensor.com] > Sent: Wednesday, October 17, 2001 3: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 > >> > >> > >> > > > >