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:[EMAIL PROTECTED]]
> Sent: Thursday, January 25, 2001 8:55 AM
> To: Jason Bouwmeester
> Cc: [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
> --
> 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]
>
--
Christopher R. Moewes-Bystrom
[EMAIL PROTECTED]
http://www.moewes.com
http://www.linuxnovice.org
--
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]
