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:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 10:45 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > > To : "mweb" <[EMAIL PROTECTED]>, "phplist" > <[EMAIL PROTECTED]>, "mysqllist" <[EMAIL PROTECTED]> > > 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. > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
