8 Replies Latest reply: Aug 27, 2013 5:32 AM by Simon Tait RSS

    Expressor SQL connection

    Henrik Matz

      I'm trying to connect to a local SQL 2012 server, and I get the following error:

       

      SQLSTATE:[08001], Code:[0], Msg:[expressor][ODBC SQL Server Wire Protocol driver]Connection refused. Verify Host Name and Port Number.

       

      I have no problem connecting from Excel or SQL server Manager Studio.

      The SQL server and Expressor is a local installation (on the same pc).

      I have disconnected the firewall.

       

      I works nicely when creating a ODBC DSN using the driver "SQL Server Native Client 11.0".

       

      Could it be that the driver used in the drop down is "SQL Server"?

       

      Best regards

       

      Henrik