Working with ODBC databases on a Mac
October 03, 2006
Mac OS X | Web Building

The ODBC Administrator

If you do much work with databases on a PC you'll be familiar with the ODBC Data Source control panel in Windows. But where is the corresponding control panel on a Mac?

It is an application, called "ODBC Administrator," and hidden in the Utilities folder inside the Applications folder.

You will first need to install a driver for whatever database you are trying to access, and those can be purchased from companies like ActualTechnologies

No need to set up a datasource for some applications

If you are simply trying to access the database for development purposes (writing and testing queries, quick reports, etc.), definitely try Aqua Data Studio. It's a free IDE for database developers, with lots of functionality. It is almost as good as Toad on the PC, but considerably cheaper!

Aqua Data Studio does not require you to install drivers or configure the ODBC data sources - all that support is integrated within the application. Version 7 has RDBMS Support: for Oracle - 11g/10g/9i/8i, DB2 iSeries, DB2 LUW - 9/8/7, MS SQL Server - 2005/2000/7/MSDE, Sybase ASE - 15/12.x/11.x, Sybase Anywhere - 10/9/8, Sybase IQ - 12.x, Informix IDS - 11/10/9.x/7.x, PostgreSQL - 8.x/7.x, MySQL - 5/4.x/3.x, Apache Derby 10.x, Generic JDBC Platform, Generic ODBC.

Ads by Google

Posted by ellen at October 03, 2006 11:42 AM

Ads by Google

 RSS   |   Contact Me

Ads by Google

Ads by Google