Running HeidiSQL & SQL Driver

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.

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

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.

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.

I use SQL Server 2008 Express

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.

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