RE: [PHP] Access to MYSQL via ODBC?

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:mweb@inwind.it] > Sent: Tuesday, November 13, 2001 11:02 AM > To: ahill@openlinksw.com > Cc: php-general@lists.php.net; mysql@lists.mysql.com > 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" <ahill@openlinksw.com> > > To : "mweb" <mweb@inwind.it> > > Cc : <php-general@lists.php.net>, <mysql@lists.mysql.com> > > 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: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. > > > > > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net