MySql connection fails in ASP .NET but not in C# .NET

Hi, Last two days we've been scraping the Internet for answers, unfortunatly without results. Here's the problem: We have a MySQL database running on a remote server, to which we want to connect from within a ASP .NET website (C#). Helas, we keep on getting the following error: can't connect.Can't connect to MySQL server on 'www.ourserver.biz' (10050) The strange thing about it all is that the database is up and running and is reachable from within our domain by means of several other applications. The connection works fine in VB6 and even in a C# executable. It just doesn't work there where it really needs to work in: ASP .NET!! (For all the connections we use myODBC 3.51 with a DSN) It smells like a security issue, but I just can't figure it out. Please help!! Thanks!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Charles_w_walker22y ago
It sounds like the windows clients are logged into the domain and your Asp.Net users are not because you are allowing anonymous access. My suggestion is to turn off anonymous access (requiring integrated or text login) or add the ASP.Net application's user to your database.