Mweb, This access to mysql conversion tool is availabe at the MySQL site - check the contributed software section for a couple of options.
Alternatively, just run both MySQL and Access on Windows, and access it via ODBC. 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 11:02 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [PHP] Access to MYSQL via ODBC? > > > 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. > > > > > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- 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
