The Invantive UniversalSQL Server has been tested with release 25.0.45 using ODBC.
Release 25.0.45 offers very limited ODBC connectivity. Use of JDBC or a SQL Server driver is recommended instead.
| Version | Status Test ODBC Admin | LibreOffice Base | Visual Studio | Power BI |
|---|---|---|---|---|
| ODBC Driver 13 for SQL Server | Failed | - | - | - |
| ODBC Driver 17 for SQL Server | Success | Partial | Success | Partial |
| SQL Server | Failed | - | - | - |
| SQL Server Native Client 11.0 | Failed | - | - | - |
ODBC Driver 13 for SQL Server
Version: 2017.140.1000.169
File: MSODBCSQL13.dll
Date: 22-08-2017
All settings default.
Test results:
Microsoft ODBC Driver for SQL Server Version 14.00.1000
Running connectivity tests...
Attempting connection
[Microsoft][ODBC Driver 13 for SQL Server]Failed to read prelogin response.
[Microsoft][ODBC Driver 13 for SQL Server]Client unable to establish connection
TESTS FAILED!
ODBC Driver 17 for SQL Server
Version: 2017.1710.06.01
File: MSODBCSQL17.dll
Date: 31-01-2024
Microsoft ODBC Driver for SQL Server Version 17.10.0006
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
INFO: A network alias was found for the DSN server. 'Protocol: DBMSSOCN; Address: acme-fortnox.database.invantive.com' was used to establish the connection.
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
SQL Server
Version: 10.00.26100.3624
File: SQLSRV32.dll
Date: 14-05-2025
Microsoft SQL Server ODBC Driver Version 10.00.26100
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS FAILED!
SQL Server Native Client 11.0
Version: 2011.110.7462.06
File: SQLNCLI11.dll
Date: 06-01-2018
Microsoft SQL Server Native Client Version 11.00.7462
Running connectivity tests...
Attempting connection
[Microsoft][SQL Server Native Client 11.0]Failed to read prelogin response.
[Microsoft][SQL Server Native Client 11.0]Client unable to establish connection
TESTS FAILED!
ODBC Driver 17 for SQL Server: LibreOffice Base
Tables visible:
Table data view:
Fails with:
The data content could not be loaded.
Communication link failure
Same error with SQL View query.
ODBC Driver 17 for SQL Server: Visual Studio
Success:
ODBC Driver 17 for SQL Server: Power BI
Partial, tables and data missing.
