RE: [PHP] Access to MYSQL via ODBC?
| From: | Andrew Hill | Date: | Tue, 13 Nov 2001 15:48:52 +0000 |
| Subject: | RE: [PHP] Access to MYSQL via ODBC? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-74455@lists.php.net to get a copy of this message | ||
Mweb,
Same --with-iodbc, just install a different ODBC driver.
Use the OpenLink Multi-Tier driver, "piggybacked" on the MS Access driver.
Install the Multi-Tier driver with Linux as your client, Win32 as your
server, and Access as your db.
Then:
1. configure a system DSN on the Win32 box using the ODBC Administrator and
the MS driver for Access. For the example we'll call it "foo".
2. configure a DSN on the Linux box in the odbc.ini file. ServerType =
ODBC, Hostname = [win32 ip address], Database = foo.
All other parameters should be self-explanatory.
Connections may be verified using "odbctest" application.
Be sure to use the syntax "DSN=DSN_NAME" in odbctest.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: mweb [mailto:mweb@inwind.it]
> Sent: Tuesday, November 13, 2001 10:45 AM
> To: ahill@openlinksw.com
> Cc: php-general@lists.php.net; mysql@lists.mysql.com
> Subject: RE: [PHP] Access to MYSQL via ODBC?
>
>
> GREAT, THANK YOU!
>
> Now the only step left is how to convert (on Linux) the MS access
> database to MySQL...How?
>
> mweb
>
> > ---------- Initial message -----------
> >
> > From : "Andrew Hill" <ahill@openlinksw.com>
> > To : "mweb" <mweb@inwind.it>, "phplist"
> <php-general@lists.php.net>, "mysqllist" <mysql@lists.mysql.com>
> > Cc :
> > Date : Tue, 13 Nov 2001 10:27:15 -0500
> > Subject : RE: [PHP] Access to MYSQL via ODBC?
> >
> > Sure, this is entirely possible.
> > Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then
> > install the MyODBC driver.
>
>
>
>