Connection refused - but it works directly from Connection Manager

Hanuta's profile image Hanuta posted 4 years ago in General Permalink

Hi,

i have a strange problem. First, newest msoledbsql_18.2.2.0_x64 Driver is installed. Further i tried several Versions of Heidi, same Problem.

If i go to Connection Manager, open a existing connection to MS SQL Express 2017, everything works fine. But if i use the same connection from Dropdown, or re-open Heidi the connection will be refused (takes to long etc.)

Server-Browser is enabled, it is a named Instance.

With another SQL-Server (real one, not Express) everything works fine...

Plz help me, tia

Regards, Stefan

ansgar's profile image ansgar posted 4 years ago Permalink

Which library has it - SQLOLEDB or the newer MSOLEDBSQL?

Note that just installing the msoledb driver does not change your connection in HeidiSQL to use that driver. You need to select it in the session manager.

Hanuta's profile image Hanuta posted 4 years ago Permalink

Hi!

The driver i used is called "msoledbsql_18.2.2.0_x64", i think that means the newer MSOLEDBSQL?!

I don't know how to select it in the Manager, i put a screenshot here...

1 attachment(s):
  • Unbenannt
ansgar's profile image ansgar posted 4 years ago Permalink

If you update to the latest built installer, you will get a new "Library" dropdown below the "Network type". Use the "32+64 bit installer" from the nightly builds section.

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