Andrew, thanks again for your lightning fast answers. However, I realize that I did not explain the problem completely. Part of it is that I don't have the possibility to network one Win computer and a Linux one.
I only have either Linux or Windows, in any given moment....:-(( Otherwise another solution would have been to leave the access DB run on the Win machine, and access it via ODBC from the Linux one without MySQL at all. Sometime ago I heard a tool that converted offline Access files to MySQL ones but can't find it again now. Is it still around? Has anybody used it? > ---------- Initial message ----------- > > From : "Andrew Hill" <[EMAIL PROTECTED]> > To : "mweb" <[EMAIL PROTECTED]> > Cc : <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Date : Tue, 13 Nov 2001 10:48:52 -0500 > Subject : RE: [PHP] Access to MYSQL via ODBC? > > 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
