The SQL Anywhere ODBC driver must be added before you create the ODBC data source.
Installing the CData ODBC Drivers on Mac OS X. The CData ODBC Driver for SQL Analysis Services is preconfigured for the iODBC driver manager, as are many other products like Microsoft Excel. This makes the driver easy to use with these tools. Licensing the Driver. In a terminal run the following commands to license the driver. PsqlODBC - PostgreSQL ODBC driver psqlODBC is the official PostgreSQL ODBC Driver. It is released under the Library General Public Licence, or LGPL. Downloads are available in source and binary formats at the PostgreSQL downloads site.
Caution
Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.
To add the SQL Anywhere ODBC driver
- If necessary, go to http://mac.softpedia.com/progDownload/ODBC-Administrator-Tool-Download-61963.html to download the ODBC Administrator tool.
- Launch the ODBC Data Source Administrator from /Applications/Utilities.
- Select the Drivers tab.
- Click Add.
- In the Description field, type SQL Anywhere 12.
- Click Choose and select the SQL Anywhere ODBC driver in both the Driver File Name and Setup File Name fields. By default, it is located in /Applications/SQLAnywhere12/System/lib32/dbodbc12_r.bundle.The _r in the bundle name indicates that it is the threaded version of the driver. There is also an unthreaded version (dbodbc12.bundle Diaper quest video. ) for use with unthreaded applications.
- Click OK.
You can add the information with a text editor. The ODBC configuration files are located in /Library/ODBC within your home directory. There is an odbcinst.ini file for driver information and an odbc.ini file for data source information.
You can also use the Data Source utility (dbdsn) to create ODBC data sources on Mac OS X. See Data Source utility (dbdsn).
To create an ODBC data source
- Launch the ODBC Data Source Administrator from /Applications/Utilities.
- In the ODBC Data Source Administrator, click the User DSN tab, and then click Add.
- In the Name list, click SQL Anywhere 12.
- Click OK.
- In the Data Source Name field, type Demo12.
- Add the following connection parameters. The connection parameters and values are case insensitive.
Keyword Value UserID DBA Password sql StartLine dbeng12 DatabaseFile /Applications/SQLAnywhere12/System/demo.db ThreadManager ON Driver SQL Anywhere 12 For more information about connection parameters, see Connection parameters. - Click OK.
- Click Apply. Facebook profile view notification chrome extension.
- Press Command+Q to exit the ODBC Data Source Administrator.
See also
-->This article explains how to install the Microsoft ODBC Driver for SQL Server on macOS. It also includes instructions for the optional command-line tools for SQL Server (
bcp
and sqlcmd
) and the unixODBC development headers.This article provides commands for installing the ODBC driver from the bash shell. If you want to download the packages directly, see Download ODBC Driver for SQL Server.
Microsoft ODBC 17
To install Microsoft ODBC driver 17 for SQL Server on macOS, run the following commands:
Important
If you installed the v17
msodbcsql
package that was briefly available, you should remove it before installing the msodbcsql17
package. This will avoid conflicts. The msodbcsql17
package can be installed side by side with the msodbcsql
v13 package.Previous versions
Odbc Driver For Mac Excel 2011 Free
The following sections provide instructions for installing previous versions of the Microsoft ODBC driver on macOS.
ODBC 13.1
Use the following commands to install the Microsoft ODBC driver 13.1 for SQL Server on OS X 10.11 (El Capitan) and macOS 10.12 (Sierra):
Driver files
The ODBC driver on macOS consists of the following components:
Component | Description |
---|---|
libmsodbcsql.17.dylib or libmsodbcsql.13.dylib | The dynamic library (dylib ) file that contains all of the driver's functionality. This file is installed in /usr/local/lib/ . |
msodbcsqlr17.rll or msodbcsqlr13.rll | The accompanying resource file for the driver library. This file is installed in [driver .dylib directory]./share/msodbcsql17/resources/en_US/ for Driver 17 and in [driver .dylib directory]./share/msodbcsql/resources/en_US/ for Driver 13. |
msodbcsql.h | The header file that contains all of the new definitions needed to use the driver. Note: You cannot reference msodbcsql.h and odbcss.h in the same program. msodbcsql.h is installed in /usr/local/include/msodbcsql17/ for Driver 17 and in /usr/local/include/msodbcsql/ for Driver 13. |
LICENSE.txt | The text file that contains the terms of the End-User License Agreement. This file is placed in /usr/local/share/doc/msodbcsql17/ for Driver 17 and in /usr/local/share/doc/msodbcsql/ for Driver 13. |
RELEASE_NOTES | The text file that contains release notes. This file is placed in /usr/local/share/doc/msodbcsql17/ for Driver 17 and in /usr/local/share/doc/msodbcsql/ for Driver 13. |
Resource file loading
The driver needs to load the resource file in order to function. This file is called
msodbcsqlr17.rll
or msodbcsqlr13.rll
depending on the driver version. The location of the .rll
file is relative to the location of the driver itself (so
or dylib
), as noted in the table above. As of version 17.1 the driver will also attempt to load the .rll
from the default directory if loading from the relative path fails. The default resource file path on macOS is /usr/local/share/msodbcsql17/resources/en_US/
Troubleshooting
If you are unable to make a connection to SQL Server using the ODBC driver, see the known issues article on troubleshooting connection problems.
Odbc Driver Manager For Mac
Next steps
After installing the driver, you can try the C++ ODBC example application. For more information about developing ODBC applications, see Developing Applications.
For more information, see the ODBC driver release notes and system requirements.