Mac OS X client access to Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and Sybase Support for all network protocols and server operating environments, which are supported by the database vendors' communications products. ODBC driver for SQL Server can be used with 32-bit and 64-bit applications on both x32 and x64 platforms, so there is no need to additionally configure the driver, applications or environment. Fully Unicode Driver. Devart ODBC Driver for SQL Server provides a high-performance and feature-rich connectivity solution for ODBC-based applications to access SQL Server databases from Windows, macOS, Linux, both 32-bit and 64-bit. The Actual SQL Server ODBC Driver lets you access your company's Microsoft SQL Server and Sybase databases from within Microsoft Excel and FileMaker Pro. Brother hl 1112 driver for mac.
The following instructions assume you already have a SQL Server database running somewhere that your Mac has network access to. Just FYI, Microsoft's instructions for installing the latest drivers are here.
Install FreeTDS and unixODBC
The connection to SQL Server will be made using the unixODBC driver manager and the FreeTDS driver. Best app to open winmail dat on mac. Installing them is most easily done using
homebrew , the Mac package manager:
Edit the freetds.conf configuration file
Ensure the
freetds.conf file is located in directory /usr/local/etc/ , which will be a symlink to the actual file as installed by Homebrew. Check the specific location of the freetds.conf file by running tsql -C . The default file already contains a standard example configuration, but all you need to do is add your server information to the end, as follows:
There are other key/value pairs that can be added but this shouldn't usually be necessary, see here for details. The
host parameter should be either the network name (or IP address) of the database server, or 'localhost' if SQL Server is running directly on your Mac (e.g. using Docker). A TDS version of 7.3 should be OK for SQL Server 2008 and newer, but bear in mind you might need a different value for older versions of SQL Server. For more information on TDS protocol versions see Choosing a TDS protocol version. Do not use TDS versions 8.0 or 9.0 though. Oddly, they are not newer than version 7.4. They are actually obsolete aliases for older TDS versions and their use is discouraged.
Test the connection using the
tsql utility, e.g. tsql -S MYMSSQL -U myuser -P mypassword . If this works, you should see the following:
At this point you can run SQL queries, e.g. 'SELECT @@VERSION' but you'll need to enter 'GO' on a separate line to actually execute the query. Type
exit to get out of the interactive session.
Edit the odbcinst.ini and odbc.ini configuration files
Nofication badge app icon mac. Download doom 3 for mac free. Run
odbcinst -j to get the location of the odbcinst.ini and odbc.ini files (probably in the directory /usr/local/etc/ ). Edit odbcinst.ini to include the following: Taylormade 2007 burner tp drivers for mac.
Edit
odbc.ini to include the following:
![]()
Note, the 'Driver' is the name of the entry in
odbcinst.ini , and the 'Servername' is the name of the entry in freetds.conf (not a network name). There are other key/value pairs that can be included, see here for details.
Check that all is OK by running
isql MYMSSQL myuser mypassword . You should see the following:
You can enter SQL queries at this point if you like. Type
quit to exit the interactive session.
Connect with pyodbc
It should now be possible to connect to your SQL Server database using pyodbc, for example:
From Devart:
Sql Server Odbc Driver Download
Devart ODBC Driver for SQL Server provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQL Server databases from Windows, Linux and Mac OS X, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with SQL Server fast, easy and extremely handy. Key Features: - Direct Connection. Database applications based on our solution get an opportunity to establish connection to SQL Server in Direct Mode. Direct Mode gives your applications an unrivalled advantage - connection to SQL Server databases directly via TCP/IP avoiding SQL Server Client. That improves performance of your applications, their quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application. - Secure connection support via SSH protocol, SSL protocol and HTTP. - Development Platforms Variety. ODBC driver for SQL Server doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, Linux and Mac OS X, both 32-bit and 64-bit. - ODBC Conformance. Our ODBC driver provides full support for common ODBC interface: * ODBC Data Types support * ODBC API Functions support In addition, we provide support for Advanced Connection String parameters. - support for IPv6 protocol - Database Compatibility. Our driver is compatible with: * SQL Server 2014 * SQL Server 2012 (including Express edition) * SQL Server 2008 R2 (including Express edition) * SQL Server 2008 (including Express edition) * SQL Server 2005 (including Express edition) * SQL Server 2000 (including MSDE) - Microsoft Power BI Desktop and Microsoft Visual FoxPro Compatibility.
Sql Server Odbc Driver For MacWhat do you need to know about free software?Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |