RE: [PHP-DB] MS ACCESS & PHP
| From: | Andrew Hill | Date: | Tue, 26 Sep 2000 13:14:50 +0000 |
| Subject: | RE: [PHP-DB] MS ACCESS & PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3092@lists.php.net to get a copy of this message | ||
Hi Troy,
One way to do it is via ODBC. You can check out the PHP-ODBC HOWTO at
www.iodbc.org.
If you are on Windows, you can just use the Access driver directly. If your
PHP is on linux, etc, then you can use a piggyback aproach. With Openlink's
Drivers, for instance, you would set up the Linux machine as a client,
Windows as a server, with regards to the ODBC components, and then:
1. create a DSN on the Win box, using MS Driver for Access, call it 'foo'
for this example.
2. create a DSN on the Linux box (in the odbc.ini file) with
ServerType=ODBC, Hostname=Windowsbox, Database=foo
Hope this helps!
Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Professional Services Consultant
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider
> -----Original Message-----
> From: troy@briscodesign.com [mailto:troy@briscodesign.com]
> Sent: Tuesday, September 26, 2000 8:14 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] MS ACCESS & PHP
>
>
> Does anyone know how (if at all possible) to connect a database
> done with Microsoft Access 2000 to PHP? I've done the whole thing
> with connecting to MySQL, but I was wondering if I could do the
> same with Access.
>
> Would it use like a basic ODBC connection?
>
> thanks a bunch,
>
> [ troy campano ]
> [ troy@briscodesign.com ]
>
>
>
>
>
>
> [:==>Troy Campano<==:]
> [:==>Web Site Designer/Programmer<==:]
>
> ******End Of Email*****************
> We have now combined our company with
> The D.E.V. (development of electronic
> virtuosity) and will be offering web
> based solutions to help our customers
> manage their sites through a browser.
> Some solutions are E-Commerce Product
> Management, Database Managemant, and Web
> Based Email. Once completed, The D.E.V.
> will be hosted on our server at
> http://dev.briscodesign.com
>
> [ The BriscoDesign Team ]
> www.briscodesign.com
> ________________________________________________________________________
>
> Get your own free, private space on the Web at
> http://www.intranets.com.
>
> --
> 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
>
>