Ms Sql Server Odbc Driver Must Be

The driver must be registered with the driver manager and DSNs are defined in the driver managers configuration files.

Note that the ODBC Manager must match the bitness of the ODBC driver.

The most recent version of the CData ODBC Driver for SQL Server 2019 is 64-bit only.

Select the DSN and click the Configure button to set connection properties as name-value pairs.

User: The username provided for authentication with SQL Server.

Password: The password associated with the authenticating user.

You can find this by logging into the Azure portal and navigating to SQL databases (or SQL data warehouses) - Select your database - Overview - Server name.

Database: The name of the database, as seen in the Azure portal on the SQL databases (or SQL warehouses) page.

The driver library is the.dylib file located in the lib subfolder of the installation directory, by default in ApplicationsCData ODBC Driver for SQL.

Driver ApplicationsCData ODBC Driver for SQLliblibsqlodbc.dylib.

If you need to connect to SQL Server from an application that can use only the ANSI ODBC API, click iODBC Demo Ansi.

Select the DSN on the corresponding tab and test the connection.

Ms Sql Server Odbc Mac Are Configured

By default, the CData ODBC Drivers for Mac are configured to use UTF-32 which is compatible with iODBC, but other Driver Managers may require alternative encoding.

For example, to import Japanese characters in an ANSI application, you can specify the code page in the config file ApplicationsCData ODBC Driver for SQLlibcdata.odbc.sql.ini.

Ms Sql Server Odbc Driver For Mac