i have a webhost with MS SQL installed but i want to use Mysql . I have another webhost which have Mysql Installed . Can i use mysql form another server with ASP.NET Over Internet
Printable View
i have a webhost with MS SQL installed but i want to use Mysql . I have another webhost which have Mysql Installed . Can i use mysql form another server with ASP.NET Over Internet
If that was at all possible through some kind of OleDb Provider, you would need the driver for mySQL on the web server running the aspx. I've never tried it. I imagine though that it is more trouble than it's worth unless you have an existing database in mySQL; even then you could just migrate the data with some fancy php to xml and aspx to sql server.
The MySQL server should allow for remote connections too.