RE: [PHP] Access to MYSQL via ODBC?

Yes I found it!!: http://www.cynergi.net/exportsql/ thanks you again!! mweb > ---------- 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 11:00:05 -0500 > Subject : 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 > > > >