Page 1 of 1

Can't connect to localhost

Posted: Fri 20 Mar 2020 21:27
by ogonommo
Hey, guys,

I'm trying to switch from MySQL Workbench to dbForge Studio 2019 Express, I have just installed it, but I can't find a way to connect to my local base (which is MariaDB). It has the default installation settings(localhost, port 3306, root and password), but whatever I'm trying to put in the Database Connection Properties modal it won't work and I get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify
that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open
a connection to SQL Server)
What am I doing wrong and what is the trick to make this thing work?

Thanks!

Re: Can't connect to localhost

Posted: Mon 23 Mar 2020 11:05
by alexa
We recommend you to check that a firewall doesn't block it.

Are both the applications dbForge and MySQL Workbench located on the same PC?

Re: Can't connect to localhost

Posted: Thu 04 Jun 2020 14:11
by alab
Same with me.
The server is up and running on the same machine as dbforge. I can telnet to it, i can access it with the built in tool - HeidiSQL, i was able to export data to it from MS Access (from another machine). ...and spent the last 4 hours to try set up a connection in dbforge. FYI Firewall is off. According to the manual there should be more fields in the comm. setup window like connection type, port number, etc. Am I missing something or they have been removed and the images in the Documentation center are old?

Edit: I've downloaded the latest version to test it

Re: Can't connect to localhost

Posted: Thu 04 Jun 2020 15:02
by alexa
Could you please provide us the server's version?

Re: Can't connect to localhost

Posted: Fri 05 Jun 2020 04:28
by alab
It's a 10.3.22 64-bit version running on a Win 7 machine. Im my case it must be Windows 7.

One more thing - yesterday I've dowloaded the same MariaDB version and dbForge on my home laptop (Win 10) an it worked. All the fields were there (in the connection setup screen) and I was able to connect.

Re: Can't connect to localhost

Posted: Sat 06 Jun 2020 11:34
by alexa
Could you please perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce this issue and send us the *.log file with the latest date from the folder:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for MySQL\
You can send the reply straight to our support system at supportATdevartDOTcom.