Devart Forums

I have been able to set this up successfully before but basically I can't get the asp.net provider working, it can't connect to the db...

I get the following error:
I can connect fine from the computer in any other program with the same connection credentials. I've tried both mysql query browser and the dbforge and can query the db fine using the above credentials. I have had this running fine until I upgraded from CoreLab to Devart.

The providers show up correctly in the asp.net administration page under the provider tab. My connection string looks like this:
Any help would be greatly appreciated. If there is a way to get a better error than the one provided please let me know. I have wasted time on trying to find a way to get a better error message but haven't found anything. The error message says it can't connect but doesn't let me know WHY.

ASP.NET Web Site Administration Tool does not support other providers entirely. It is made to use it with Microsoft SQL Provider only.
But it doesn't mean that our provider doesn't work. Check its workability from your code. E.g. try to create a user in our MySQL scheme. If there are any runtime errors, please notify us about them.

Shalex wrote:ASP.NET Web Site Administration Tool does not support other providers entirely. It is made to use it with Microsoft SQL Provider only.
But it doesn't mean that our provider doesn't work. Check its workability from your code. E.g. try to create a user in our MySQL scheme. If there are any runtime errors, please notify us about them.

I see what you're saying. Yes, the provider works but it still throws the exception that it can't connect.

This is a ASP.NET Web Site Administration Tool issue. It detects any provider that contains "SQL" in its name as Microsoft SQL Provider. That's why dotConnect for MySQL is not fully supported by this tool.

Shalex wrote:This is a ASP.NET Web Site Administration Tool issue. It detects any provider that contains "SQL" in its name as Microsoft SQL Provider. That's why dotConnect for MySQL is not fully supported by this tool.

That is unfortunate that microsoft has done this.