Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Update Both Databases(Local Mssql And Online Mysql) In Both The Ways

forums › forums › SQLyog › SQLyog Comments › Update Both Databases(Local Mssql And Online Mysql) In Both The Ways

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • June 13, 2012 at 9:51 am #12702
      pardhu
      Member

      I want to create DSN for online database using mysql ODBC 3.5.1

      i have a website using php/mysql. This is online shopping website for books

      and i have one book show room..that books database is running by mssql

      if any one purchase one book from shop , it will automatically update in “stock” column of that book in mssql database. Like 10 to 9

      Now I want update that same book quantity in mysql also

      so i am using linked server of mssql and mysql odbc driver for mysql DSN

      using that i created DSN name for “localhost” mysql given server name as “localhost” created DSN name and i given that DSN name in linked server using 2 different queries i am updating local MSSQL to local MYSQL viceversa..

      but actuall task is update local MSSQL database to online MYSQL, For that one i have to create DSN name first, right? when i am given http://www.example.com as server name it is giving error “SQL server error”. So i want to create DSN name for online database…please help me

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.