Post reply

connect mysql with ms sql server?

  • March 18, 2006 at 4:06 pm

    #112393

    can i have connection between mssql server and mysql and update data in both?

  • March 20, 2006 at 2:32 pm

    #627721

    Yes. You can create an ODBC connection to MySQL using MyODBC. SQL Server you can use the OLEDB provider. In order to have a linked server connection from SQL Server to MySQL, you'd need the MyODBC drivers installed on the SQL Server itself.

    Product Page for MyODBC

    K. Brian Kelley
    @kbriankelley

  • March 21, 2006 at 6:54 am

    #627848

    thank u very much.i m a newbie but i work for a big company here in greece so...things are pretty hard for me.i appreciate your help

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply