Could not initiate communication with the server.

Could not initiate communication with the server.

Postby dave_helmut » Thu 19 May 2005 02:08

hi,

I have an ASP.NET application using C# and dbProvider and MySqlConnection.

If I have "localhost" in the connect string, I can connect to the database from the local machine. However, if I have anything else in the connect string I get this error:

"Could not initiate communication with the server."

My goal is to connect to my MYSQL server from a remote machine, but I am having this problem. The local machine also gets this error if it puts its IP address or its own COMPUTERNAME in the connect string.

Ever see this?

Thanks!

Dave
dave_helmut
 
Posts: 1
Joined: Thu 19 May 2005 02:02

Postby Serious » Thu 19 May 2005 15:40

Please send us a call stack of this exception.
Serious
 

Postby Guest » Thu 19 May 2005 15:44

Code: Select all
Server Error in '/stringproject' Application.
--------------------------------------------------------------------------------

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 59:
Line 60:          MySqlConnection conn = new MySqlConnection(ConnectionString);
Line 61:          conn.Open();
Line 62:
Line 63:          MySqlCommand cmd = new MySqlCommand(SQLCommand, conn);


Source File: c:\inetpub\wwwroot\stringproject\contacts.aspx.cs    Line: 61

Stack Trace:


[Exception: Could not initiate communication with the server.]
   eInfoDesigns.dbProvider.MySqlClient.DbCommunication.DbComm.Open(String User, String Password)
   eInfoDesigns.dbProvider.MySqlClient.MySqlConnection.CreateConnection()
   eInfoDesigns.dbProvider.MySqlClient.MySqlConnection.Open()
   stringproject.contacts.Search(String WhereClause) in c:\inetpub\wwwroot\stringproject\contacts.aspx.cs:61
   stringproject.contacts.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\stringproject\contacts.aspx.cs:41
   System.Web.UI.Control.OnLoad(EventArgs e)
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Page.ProcessRequestMain()


Guest
 

Postby Guest » Thu 19 May 2005 15:45

Understand that the C# application is being executed with IIS on machine B, and the MySQL service is running on machine A.
Guest
 

Postby Serious » Mon 23 May 2005 12:19

According to stack trace what you use is definitely not MySQLDirect .NET Data Provider. We do not support 3rd party products. For more information about MySQLDirect .NET look here
Serious
 

Postby Guest » Tue 31 May 2005 18:07

Serious wrote:According to stack trace what you use is definitely not MySQLDirect .NET Data Provider. We do not support 3rd party products. For more information about MySQLDirect .NET look here


Is not eInfoDesigns and Cole Labone and the same?

I downloaded the files from the link you provided and tried to install it and it said I already have it installed.

Is not eInfoDesigns.dbProvider made by core labs? What is the name of the object you expected to see in the stack trace?

thanks!

Dave
Guest
 

Postby Serious » Wed 01 Jun 2005 06:40

You can have MySQLDirect .NET installed, but you use another product. We do not solve problems with eInfoDesigns provider.
The full connection name is CoreLab.MySql.MySqlConnection.
If you have MySQLDirect .NET installed you can find multiple examples in the /CoreLab/MySQLDirect .NET/Samples folder.
Serious
 


Return to dotConnect for MySQL