Licence: Commercial; platforms: Mac OS X, Linux, Windows; Python versions. MxODBC is compatible with the Sybase ASE ODBC drivers on. Sybase support for ADO.NET, OLE DB, and ODBC. Adaptive Server version 15.0 contains new ODBC and OLE DB drivers developed by Sybase. The third-party rebranded ODBC and OLE DB Driver Kits included with previous versions are no longer shipped.

Although I haven't had need to do so for freelance jobs, I do administer several Windows-based and MS SQL Servers at my day job. It's helpful to be able to connect directly to these servers from my Mac desktop in addition to using Apple RDC to manage and work against them directly via Management Studio and Sybase Central. I had previously installed and on an OS X 10.4 desktop. This old Tiger was replaced by a new machine running Lion recently. I tried installing unixODBC and FreeTDS using on the new machine, but was unable to connect to Sybase servers. I found which refreshed my memory on the installation steps. Vinh notes problems with MacPorts, too.

With a refreshed memory and some trial and error, I was able to get everything up and running again. For future reference, here are the steps from the latest installation and configuration of unixODBC and FreeTDS on OS X Lion. Installation RequirementsYou'll need Apple's developer tools, so be sure you have XCode installed. A commenter on Vinh's post noted errors experienced before installing gawk, which I had already installed via MacPorts. I downloaded all packages with wget from the command line. Configure and Build unixODBC and FreeTDS from SourceFreeTDS will work with either iODBC or unixODBC, but I've not had luck with iODBC. Hitfilm 3 free download.

Build and install unixODBC first and then FreeTDS. I built and installed everything in the standard location, /usr/local, feel free to change the path to suite your needs.

Cd /usr/local/src unixODBCNothing special here. Wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.1.tar.gztar xvfz unixODBC-2.3.1.tar.gz cd unixODBC-2.3.1./configuremakesudo make install FreeTDSI followed Vinh's recommendation of installing the latest development version, so I grabbed the latest FreeTDS nightly snapshot. Wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/current/freetds-current.tgzConfigure the installer with the proper version and path to unixODBC./configure -with-tdsver=8.0 -with-unixodbc=/usr/localmakesudo make installCheck the FreeTDS install with tsql. Download free yomi full game print and play games. Tsql -CCompile-time settings (established with the 'configure' script)Version: freetds v0.92.dev.20120312freetds.conf directory: /usr/local/etcMS db-lib source compatibility: noSybase binary compatibility: noThread safety: yesiconv library: yesTDS version: 5.0iODBC: nounixodbc: yesSSPI 'trusted' logins: noKerberos: noIf you have Sybase or MS db-lib installed locally, check out the FreeTDS documentation for instructions on further configuration options. ConfigurationTo get up and running for basic usage, you'll need to define your servers and DSNs in the freetds.conf and odbc.ini files, respectively. Either create and edit these at the system-level in /usr/local/etc or just for you in your home directory.

For more advanced language and connection needs, you'll also want to configure locales.conf and pool.conf.Vinh states that he needed to use TDS version 8.0 for MS SQL Server connections. I found that I needed to use TDS version 5.0 for Sybase connections.Here's a basic Sybase server DSN defined in /.odbc.ini. The default section contains default (surprise) values to be used by servers. Each host's DSN may override or extend the default values.

defaultDriver=/usr/local/lib/libtdsodbc.soTDSVersion=5.0Port=5000;UseCursor=1;Trace=Yes;Tracefile=/tmp/odbc.logSybaseDSNDescription=Sybase ASE 12.5 or 15 ServerServerName=HOSTNAMEDatabase=DATABASEAnd here's the corresponding Sybase server entry in /.freetds.conf. The ServerName in the odbc.ini's DSN needs to match a HOSTNAME defined in the freetds.conf file! As with the odbc.ini file's default section, the global definitions in freetds.conf apply to all servers defined, unless the server section defines the value. Uncomment the dump and debug values to log connection output if have problems connecting.

Contents.Sybase was acquired by SAP in 2010. The products below are now available as SAP products.Note that there are Sybase ASE and Sybase SQL Anywhere systems.