Connecting to SQL Server

To connect from DataMagic to SQL Server, Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) version 19 is required.

For details on MSOLEDBSQL, see the Microsoft web site.

For DSN connection, use the Windows standard SQL Server client.

We have identified an issue where if Microsoft ODBC Driver for SQL Server that is separately supplied by Microsoft is used for DSN connection, XML type data is not converted correctly.

Note

  • Use MSOLEDBSQL and VC++ Redistributable Package included in the installation module.

  • If you install MSOLEDBSQL in a 64 bit environment, install both the VC++ Redistributable Package for X64 and for x86.

  • Use 32-bit or 64-bit MSOLEDBSQL as is appropriate for your DataMagic software.

Available databases

For details about the SQL Server versions to which DataMagic can connect, access the following URL and check the website:

URL:  https://www.hulft.com/

 

Assigning a TCP/IP port number

Assign a static TCP/IP port number for SQL Server on the connection destination. If the port number is assigned dynamically, DataMagic cannot establish connections.

Note

If the OS where you are installing a DB Server does not authorize TLS 1.1 or earlier communications, the following error will occur in the connection from DataMagic Server.

End code

: 93

Description

: Failed to confirm the database connection.

Details code

: 4

Detailed message

: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]This is an SSL security error.(0112-0008).

If this error occurs, authorize communication for TLS 1.1 or earlier. For details about settings, contact the vendor of the OS.