RE: [PHP] myODBC

Thanks, was just trying to figure out what I really needed to download/install to run mySQL with PHP on my W2K box. jb -----Original Message----- From: cmoewes@moewes.com [mailto:cmoewes@moewes.com] Sent: Thursday, January 25, 2001 9:26 AM To: Jason Bouwmeester; php-general@lists.php.net Cc: php-general@lists.php.net Subject: Re: [PHP] myODBC myODBC lets you connect to a mysql databas3e via the ODBC protocol. So you can create a mysql database connection (on a windows machine) and use that connection in a MSAccess environment. Or pull data directly from mysql into an Excel spreadsheet. Plus i am sure ASP and stuff like that can use it as well (by why would you care about ASP???) ;) On Thu, Jan 25, 2001 at 09:08:36AM -0700, Jason Bouwmeester wrote: > myODBC - what is that useful for, or is there anywhere I can get > documentation or a description on it? > > Thanks again, > jb > > -----Original Message----- > From: Pavel Kalian [mailto:pkalian@ssw.cz] > Sent: Thursday, January 25, 2001 8:55 AM > To: Jason Bouwmeester > Cc: php-general@lists.php.net > Subject: Re: [PHP] SQL Server DB to mySQL DB > > > 1. Generate SQL script for your database in the MS SQL Server Enterprise > Manager > 2. Modify generated SQL to be compatible with MySQL > 3. Run the script on your MySQL server > > Pretty easy if you aren't using any feature of MS SQL that MySQL doesn't > support (for example stored procedures) > > Another way is to connect both the servers to Access using ODBC and just > copy the tables - it's the easiest way to do that but resulting MySQL tables > are quite screwed up. > > Pavel > > ----- Original Message ----- > From: "Jason Bouwmeester" <jason@intervisual.com> > To: <php-general@lists.php.net> > Sent: Thursday, January 25, 2001 4:44 PM > Subject: [PHP] SQL Server DB to mySQL DB > > > > Is there an easy way to do this? I know that SQL Server can export a comma > > delimited file, can mySQL import this? I imagine the PHP will be easy to > > modify as long as the field names are the same. > > > > Thanks, > > jb > > > > Jason Bouwmeester > > New Media Consultant > > InterVisual > > > > Suite 200, 709 - 11th Ave SW > > Calgary, AB T2R 0E3 > > Ph: 403.264.9199 > > Fax: 403.264.9225 > > www.intervisual.com > > "Internet Solutions Developer" > > > > -- > > 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 > > > > -- > 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 > -- Christopher R. Moewes-Bystrom cmoewes@moewes.com http://www.moewes.com http://www.linuxnovice.org