Problem connecting to MySQL server with DbExplorer
Problem connecting to MySQL server with DbExplorer
Hi,
I'm having difficulties connecting to my MySQL server which is on a remote server. I've connected successfully with MySQL Administrator so I know that the connection string is correct.
Is this a known problem or am I doing something wrong?
I'm running MySQL 4.1.7 and using the latest MySQLDirect.NET release.
Some help would be greatly appreciated, I've been going crazy over this all day...
I'm having difficulties connecting to my MySQL server which is on a remote server. I've connected successfully with MySQL Administrator so I know that the connection string is correct.
Is this a known problem or am I doing something wrong?
I'm running MySQL 4.1.7 and using the latest MySQLDirect.NET release.
Some help would be greatly appreciated, I've been going crazy over this all day...
Here's my connectionstring, with a masked password ;)
Host=slottsservern;User Id=mats;Password=xxx;
It's a pretty standard connectionstring. I've tried using the ip of the servern but I get the same error.
It's really bugging me since I can connect to it from mysqladministrator but I really want to use DbExplorer.
It's a pretty standard connectionstring. I've tried using the ip of the servern but I get the same error.
It's really bugging me since I can connect to it from mysqladministrator but I really want to use DbExplorer.
-
- Posts: 8
- Joined: Sun 10 Dec 2006 02:40
I'm having the same problem. However the message says ..........
Can't connect to MySQL server on '192.168.0.2' (10061)
When I view more information in the Visual Studio debugger it says:
DeviceApplication1.exe!DeviceApplication1.Form1.CreateMySqlConnection() Line 41 + 0x6 bytes C#
Further in the debugger............
HostInfo 'oMySqlConn.HostInfo' threw an exception of type 'System.InvalidOperationException' string {System.InvalidOperationException}
Further Still..............
- base {"Connection must be opened."} System.SystemException {System.InvalidOperationException}
My connection is also basic, it is ......
using CoreLab.MySql; (at the top)
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "User ID=root;" + "Password=root;" + "Host=192.168.0.2;" + "Port=3306;" + "Protocol=TCP;";
oMySqlConn.Open();
I'm am using the Pocket PC emulator with Visual Studio 2005 pro, MySQLDirect .NET mobile and a MySQL database. It does not run, I have also put these statements in a "try" and "catch" block to catch the exception but it still does not work.
I have:
- disabled My firewall
- disabled SSL support or named pipe
- Ensure that TCP/IP connection is enabled on port 3306
Can anyone give me so pointers?? I'm pretty sure the connection string is correct but for some reason the connection status stays closed even tho I have used the oMySqlConn.Open(); command. Does anyone know if something else is blocking the port or stopping the connection??
PLEASE HELP ASAP!!!!!!
Can't connect to MySQL server on '192.168.0.2' (10061)
When I view more information in the Visual Studio debugger it says:
DeviceApplication1.exe!DeviceApplication1.Form1.CreateMySqlConnection() Line 41 + 0x6 bytes C#
Further in the debugger............
HostInfo 'oMySqlConn.HostInfo' threw an exception of type 'System.InvalidOperationException' string {System.InvalidOperationException}
Further Still..............
- base {"Connection must be opened."} System.SystemException {System.InvalidOperationException}
My connection is also basic, it is ......
using CoreLab.MySql; (at the top)
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "User ID=root;" + "Password=root;" + "Host=192.168.0.2;" + "Port=3306;" + "Protocol=TCP;";
oMySqlConn.Open();
I'm am using the Pocket PC emulator with Visual Studio 2005 pro, MySQLDirect .NET mobile and a MySQL database. It does not run, I have also put these statements in a "try" and "catch" block to catch the exception but it still does not work.
I have:
- disabled My firewall
- disabled SSL support or named pipe
- Ensure that TCP/IP connection is enabled on port 3306
Can anyone give me so pointers?? I'm pretty sure the connection string is correct but for some reason the connection status stays closed even tho I have used the oMySqlConn.Open(); command. Does anyone know if something else is blocking the port or stopping the connection??
PLEASE HELP ASAP!!!!!!
-
- Posts: 8
- Joined: Sun 10 Dec 2006 02:40
-
- Posts: 8
- Joined: Sun 10 Dec 2006 02:40
I get the error during the debug stage of the compilation. Visual Studio will compile the code and deploy to the pocket pc emulator. It will then start to load and the dbugger will kick in a re-open Visual Studio saying the it can connect to the database (it say further down the tree that a connection must be opened - every though I using the myconnection.Open(); command)
Is it anything to do with having the trial version?
Can you let me know how all the setting in MySQL administrator need to be setup?
Thanks
Could you reply asap please because I can test it right now (Or could you send me contact a number to [email protected])
Is it anything to do with having the trial version?
Can you let me know how all the setting in MySQL administrator need to be setup?
Thanks
Could you reply asap please because I can test it right now (Or could you send me contact a number to [email protected])