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