Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Error connecting to SQL server

CarlosC's profile image CarlosC posted 3 months ago in General Permalink

Hi, I am using HeidiSQL 10.3.0.5771 Portable, and I can not connect to SQL SERVER; after filling the connection info and press OPEN I always got an exception. The exception number is 1,class is EOleException and message is similar to "Arguments are of incorrect type, are outside of acceptable range or in conflict which each other" (translate from PT). Same error with named pipes, TCP/IP, with Windows authentication or SQL authentication. Any suggestion?

TIA Carlos

ansgar's profile image ansgar posted 3 months ago Permalink

You could try the other driver library from the "Library" dropdown.

CarlosC's profile image CarlosC posted 3 months ago Permalink

I only have these providers on the combo: Description

If I select any of these I got an error "Supplier not found".

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 3 months ago Permalink

These dlls are for MySQL/MariaDB connections, not for MS SQL. This is a bug I recently fixed in a nightly build. You need to save your settings once, before you can select one of the SQL Server providers.

CarlosC's profile image CarlosC posted 3 months ago Permalink

Ansgar,

Thank you for your support - saving the settings once, closing the program and open it again solve the issue - and use the correct SQLOLEDB library - previously I only had the 3 MySql/MariaDB DLLs (or a empty combo).

Wish you a Happy 2020!

jadepet567's profile image jadepet567 posted 1 week ago Permalink

I got the same problem still How Do I fix it

jadepet567's profile image jadepet567 posted 1 week ago Permalink

It saids I can't connect to MySQL Server

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