Message: Could not establish connection

[expired user #2173]'s profile image [expired user #2173] posted 17 years ago in Creating a connection Permalink
I'm trying to open over the internet a database located at my ISP's server. I entered all connection details into HeidiSQL, but as soon as click <Connect> I'll get the following Error:

Could not establish connection! Details:
'' is not a valid integer value



Any ideas?
ansgar's profile image ansgar posted 17 years ago Permalink
Sounds like an error we had with some pre 3.0 version. Are you using the latest 3.0 ?
[expired user #2173]'s profile image [expired user #2173] posted 17 years ago Permalink
I'm using Version 3.0 Rev 572.

I was able to solve part of the problem: my ISP changed something in the resolution of the domain name. So I had the wrong Hostname: 'http://www.mydomain.ch' instead of 'mydomain.ch'. After correction of this, I was able to connect without the errormessage. However I think, this is not a clever errormessage...

By the way: I think the user interface for the connection dialog is not very intuitive. Either I would expect
- the Connect button to execute always <Save+Connect> (I don't see any reason to connect and not to save)
or I would expect the
- Connection Paramters to be in a separate window that can be left either by <Cancel> or <Save>. There could be a <Test>-Button as well.
[expired user #1821]'s profile image [expired user #1821] posted 17 years ago Permalink


By the way: I think the user interface for the connection dialog is not very intuitive. Either I would expect
- the Connect button to execute always <Save+Connect> (I don't see any reason to connect and not to save)



For me it is very intuitive. My FTP program works in the same way actually.
It is logical to me, because a number of problems can cause connection errors and only one of them is a wrong user/pass combination. Usually, once i set a username + password combination i forget it two seconds later. This way, when a connection problem occurs, i can change the settings unlimited without loosing the original ones that i would not be able to remember
ansgar's profile image ansgar posted 17 years ago Permalink

So I had the wrong Hostname: 'http://www.mydomain.ch' instead of 'mydomain.ch'. After correction of this, I was able to connect without the errormessage. However I think, this is not a clever errormessage...



I agree totally. But I have absolutely no clue why you get this error while trying to connect to a not existing hostname. I will have a look if there are any string to integer conversions which may fail at startup. I thought we nuked these cases for 3.0, but anyway.

And I agree with Simkin when he says that "Connect" is the better default button rather than "Save+Connect". The procedure of saving your connection parameters should always be some kind of manual click. I think it's too dumb to always overwrite sessions when you connect. When you're editing some Word document you also don't want to auto-save when you close it, do you? Think of something went wrong while editing, some accidently deleting of lines or so. The same goes for our session parameters which shouldn't be auto-saved. At least that should be an option which can be set in preferences: "Automatically save/overwrite (!) session parameters on connect"

Please login to leave a reply, or register at first.