MYSQL & ASP.NET

[aidan]

All

Have MYSQL and am connecting to it with ASP.NET using a native
DbProvider. I tried the ODBC providers off the site but they are
roughly 5-10 times slower than SQL Server or the Native provider.

Since I have began using them I keep getting the error below. The page
will retriven about 20 records before this comes up.

Any ideas?

Thanks in advance

"Could not initiate communication with the server"

Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Exception: Could not initiate communication
with the server.

Source Error:
Line 98: Dim myCommand As New MySqlCommand(query, myConn)
Line 99:
Line 100: myConn.Open()
Line 101:
Line 102: Dim myReader As MySqlDataReader =
myCommand.ExecuteReader()
Source File: C:\Dev\Asset Register
SW\SourceCode\DotNet\ASP.NET\ASP.NET Asset
Register\AssetRegister\Components\BLL\Sub-Locations.vb Line: 100

Stack Trace:
[Exception: Could not initiate communication with the server.]
eInfoDesigns.dbProvider.MySqlClient.DbCommunicatio n.DbComm.Open(String
User, String Password)
eInfoDesigns.dbProvider.MySqlClient.MySqlConnectio n.CreateConnection()
eInfoDesigns.dbProvider.MySqlClient.MySqlConnectio n.Open()
AssetRegister.ASPNET.ASSETREGISTER.Sub_LocationDB. GetSub_Locations(Int32
intSiteID, Int32 intLocID) in C:\Dev\Asset Register
SW\SourceCode\DotNet\ASP.NET\ASP.NET Asset
Register\AssetRegister\Components\BLL\Sub-Locations.vb:100
AssetRegister.C_Menu.Page_Load(Object sender, EventArgs e) in
C:\Dev\Asset Register SW\SourceCode\DotNet\ASP.NET\ASP.NET Asset
Register\AssetRegister\_Menu.ascx.vb:117
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET Version:1.1.4322.573