Asp.Net with Mysql

[Denster]

Has anybody experienced any problems using a Mysql Database with an ASP.Net web site? I have been struggling for months to get a web site up and running and although nearly complete there are still issues saving to the database. To compound matters, running through the code on my PC linking to remote database works fine, its just when I upload to the server where problems occur. I'm beginning to wonder if Mysql is the Tool to use with a .NET web site, but this was the cheaper option at the time.

 

[ca8msm]

There is no technical reason why you can't use MYSQL with an ASP.NET application. If the code works locally but not on the host, then it's an issue with your host.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[Denster]

I have been in constant contact with my host and all I get is, they havent experienced any problems before. If this isnt a Microsoft interacting with a non Microsoft problem them maybe its time to look for a new Host.

 

[ca8msm]

If this isnt a Microsoft interacting with a non Microsoft problem

It isn't. There is no reason why you shouldn't be able to interact with any database as long as you have the appropiate drivers.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[jshurst]

I've used .NET with mysql before. Did you download the .NET provider classes from the mysql site? Also, I'm assuming that you changing your connection string before deploying right? (web hosts usually give database server instances crazy names...)