The ODBC AdministratorIf 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 applicationsIf 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.