Can't connect to localhost

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
ogonommo
Posts: 1
Joined: Fri 20 Mar 2020 21:14

Can't connect to localhost

Post by ogonommo » Fri 20 Mar 2020 21:27

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!

alexa

Re: Can't connect to localhost

Post by alexa » Mon 23 Mar 2020 11:05

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?

alab
Posts: 2
Joined: Thu 04 Jun 2020 13:55

Re: Can't connect to localhost

Post by alab » Thu 04 Jun 2020 14:11

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

alexa

Re: Can't connect to localhost

Post by alexa » Thu 04 Jun 2020 15:02

Could you please provide us the server's version?

alab
Posts: 2
Joined: Thu 04 Jun 2020 13:55

Re: Can't connect to localhost

Post by alab » Fri 05 Jun 2020 04:28

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.

alexa

Re: Can't connect to localhost

Post by alexa » Sat 06 Jun 2020 11:34

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.

Post Reply