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.

Running HeidiSQL & SQL Driver

BigBaz's profile image BigBaz posted 4 months ago in General Permalink

Hi

Every time I open HeidiSQL it shows a message saying I'm using an old driver to access MS SQL and gives a link to where I can get a newer driver. This I have done (several times now) and installed that new driver. But still I get the message on start up, like it can't see that I now have the driver it recommended I use.

ansgar's profile image ansgar posted 4 months ago Permalink

After installing the newer driver, you should be able to use the appropriate MSOLEDB library in the session manager:

Description

BigBaz's profile image BigBaz posted 4 months ago Permalink

I had done that on 2 of the connections I use. On checking, though, the 3rd one was still set to OLEDB! My bad, but thanks for the quick response.

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.
faustino's profile image faustino posted 3 months ago Permalink

Hi I have the same problem. After installing msoledbsql_18.3.0.0_x64.msi from the given link which shows up as MSOLEDBSQL at Library and trying to open a MS SQL database it get the error: SQL Fehler (0): SQL Server Network interface Error Locating Server/Instance Specified [xFFFFFFFF] Login timeout expired.

faustino's profile image faustino posted 3 months ago Permalink

I use SQL Server 2008 Express

BigBaz's profile image BigBaz posted 3 months ago Permalink

I used SQL Server 2014 Management Studio before I got HeodiSQL to connect OK. It connects to a Microsoft SQL Server Standard (64bit) on Windows NT 6.3 (9600). Sounds pretty old but does the job. This Server is with my Hosting company.

faustino's profile image faustino posted 3 months ago Permalink

I found the solution for local SQL Server 2008 Express:

  1. In SQL Server Manager 'named pipes' must be activated
  2. In Windows services & applications 'SQL server browser' must be activated
  3. In HeidiSQL the name of the pipe '\.\pipe\MSSQL$SQLEXPRESS\sql\query' must be put at Host/IP

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