The new OS from Mac is here in OS X El Capitan. Apple's 12th OS release is the OS X El Capitan.Named after a rock formation in the Yosemite National Park, USA, OS X El Capitan continues and focuses on stability, performance and security in which OS X Yosemite started. Mainly fix some build issues (old MingW, Mac OS X, VMS). Version 1.0 Release Candidate 2: The second release candidate for. Download and install the latest version. Download and configure FreeTDS. Copy the latest libtool into the freetds-ver directory. Run make clean && make && make install. Cd to PREFIX/lib and run.
XAMPP is an easy to install Apache distribution containing MariaDB, PHP, and Perl. Just download and start the installer. It's that easy.
Uninstalling freetds from OS X Mavericks. Ask Question Asked 4 years, 6 months ago. Active 4 years, 6 months ago. Viewed 585 times 4. Does anyone know how to uninstall freetds from OS X? I have installed it from source by following instructions: tar zxvf freetds-stable.tgz cd freetds-'0.91'./configure -prefix=/usr/local make sudo make install. Getting it to work on MAC OS X. Wed 16 October 2002. Lilback rolled up his sleeves and solved this. But, it's not baby simple, because you have to use bleeding edge tools. The latest stable release of libtool, which FreeTDS uses to generate its configure script, doesn't do what you need. But, as a dynalib builder, you're used to that, eh?
XAMPP for Windows7.2.33, 7.3.22 & 7.4.10
Version Checksum Size 7.2.33 / PHP 7.2.33 What's Included? - md5
- sha1
154 Mb 7.3.22 / PHP 7.3.22 What's Included? - md5
- sha1
155 Mb 7.4.10 / PHP 7.4.10 What's Included? - md5
- sha1
156 Mb Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.2.33, phpMyAdmin 5.0.2, OpenSSL 1.1.1, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.105 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.0.1 PortableIncludes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.3.22, phpMyAdmin 5.0.2, OpenSSL 1.1.1, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.105 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.0.1 PortableIncludes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.4.10, phpMyAdmin 5.0.2, OpenSSL 1.1.1, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.105 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.0.1 PortableWindows 2008, 2012, Vista, 7, 8 (Important: XP or 2003 not supported)Windows XP or 2003 are not supported. You can download a compatible version of XAMPP for these platforms here.XAMPP for Linux7.2.33, 7.3.22 & 7.4.10
Version Checksum Size 7.2.33 / PHP 7.2.33 What's Included? - md5
- sha1
150 Mb 7.3.22 / PHP 7.3.22 What's Included? - md5
- sha1
152 Mb 7.4.10 / PHP 7.4.10 What's Included? - md5
- sha1
150 Mb Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.2.33 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.3.22 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.4.10 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4Most all distributions of Linux are supported, including Debian, RedHat, CentOS, Ubuntu, Fedora, Gentoo, Arch, SUSE.XAMPP for OS X7.2.33, 7.3.22, 7.4.10, 7.2.33, 7.3.22 & 7.4.10
Version Checksum Size 7.2.33 / PHP 7.2.33 What's Included? - md5
- sha1
161 Mb 7.3.22 / PHP 7.3.22 What's Included? - md5
- sha1
162 Mb 7.4.10 / PHP 7.4.10 What's Included? - md5
- sha1
161 Mb 7.2.33 / PHP 7.2.33 What's Included? - md5
- sha1
357 Mb 7.3.22 / PHP 7.3.22 What's Included? - md5
- sha1
355 Mb 7.4.10 / PHP 7.4.10 What's Included? - md5
- sha1
357 Mb Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.2.33 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.3.22 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.4.10 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.2.33 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.3.22 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.4.10 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.2, OpenSSL 1.1.1g, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Add-ons
Applications
Install your favorite apps on top of XAMPP. Bitnami provides a free all-in-one tool to install Drupal, Joomla!, WordPress and many other popular open source apps on top of XAMPP.
OS X native modules have been deprecated. Please use XAMPP-VM for OS X and the Linux version of the add-ons. Check our FAQs for more info.
Installation¶
Linux¶
On Linux you can choose between (for the two former choices, when you start thethe pymssql installation process it will look for and pick the header files andlibraries for FreeTDS in some usual system-wide locations):
- Use the FreeTDS installation provided by the packages/ports system.
- Build it and install yourself.
- Use the bundled static FreeTDS libraries:These static libraries are built on a x86_64 Ubuntu 14.04 system by using thefollowing sequence:orand then:Changed in version 2.1.2: Version of FreeTDS Linux static libraries bundled with pymssql is0.95.81 obtained from branch Branch-0_95 of the official Gitrepository. Up to 2.1.1 the version of FreeTDS bundled was 0.91.
Mac OS X (with Homebrew)¶
Windows¶
- You can:
- Use binaries we maintain at https://github.com/ramiro/freetds/releasesThose are built with SSL support via OpenSSL (see below) and iconv (viawin-iconv statically linked).Choose the .zip file appropriate for your architecture (
x86
vs.x86_64
) and your Python version (vs2008
for Python 2.7,vs2010
for Python 3.3 and 3.4,vs2015
for Python 3.5). Download and uncompressit taking note of the path to the directory which contains the DLL files. - Or you can build it yourself.
- If you chose the FreeTDS binaries linked above then you’ll need to installOpenSSL. The binaries you’ll need can be downloaded fromhttp://www.npcglib.org/~stathis/blog/precompiled-openssl/Choose the right .7z file for your Python version (
vs2008
for Python 2.7,vs2010
for Python 3.3 and 3.4,vs2015
for Python 3.5). Download anduncompress it taking note of the path to the directory which contains the DLLfiles.This is needed because the FreeTDS DLLs are compiled with the feature to useSSL-wrapped connections to SQL Server (and Azure for which it’s a mandatoryrequirement) turned on. - If applicable, add the directories that hold the above DLLs to your
PATH
environment variable.
Note
FreeTDS is now linked in dynamically on Windows
pymssql version 2.1.2 includes a change in the official Windows binaries:FreeTDS isn’t statically linked as it happened up to release 2.1.1, as thatFreeTDS copy lacked SSL support.
Given the fact OpenSSL is a relatively fast-moving target and a sensitive onesecurity-wise, we’ve chosen to not link it statically either so it can beupdated independently to future releases which include security fixes.
We are trying to find a balance between security and convenience and willbe evaluating the situation for future releases. Your feedback is greatlywelcome.
Linux Freetds
Configuration¶
pymssql uses FreeTDS package to connect to SQL Server instances. You have totell it how to find your database servers. The most basic info is host name,port number, and protocol version to use.
The system-wide FreeTDS configuration file is
/etc/freetds.conf
orC:freetds.conf
, depending upon your system. It is also possible to use auser specific configuration file, which is $HOME/.freetds.conf
on Linux and%APPDATA%.freetds.conf
on Windows. Suggested contents to start with is atleast:With this config you will be able to enter just the hostname to
pymssql.connect()
and _mssql.connect()
:Otherwise you will have to enter the portname as in:
To connect to instance other than the default, you have to know either theinstance name or port number on which the instance listens:
Please see also the pymssql module reference, _mssqlmodule reference, and FAQ pages.
For more information on configuring FreeTDS please go tohttp://www.freetds.org/userguide/freetdsconf.htm
Testing the connection¶
If you’re sure that your server is reachable, but pymssql for some reason don’tlet you connect, you can check the connection with
tsql
utility which ispart of FreeTDS package:Note
Use the above form if and only if you specified server alias formydbserver in freetds.conf. Otherwise use the host/port notation:
You’ll be prompted for a password and if the connection succeeds, you’ll seethe SQL prompt:
Download Freetds Mac Os X 10.13
You can then enter queries and terminate the session with
exit
.Download Freetds Mac Os X64
If the connection fails,
tsql
utility will display appropriate message.