Article Preview
Buy Now
| PDF: |
Databases for REAL
All About ODBC
Connecting to ODBC databases with REAL Studio
Issue: 8.6 (September/October 2010)
Article Description: No description available.
Article Length (in bytes): 3,537
Starting Page Number: 80
RBD Number: 8612
Resource File(s): None
Related Web Link(s):
http://support.apple.com/downloads/ODBC_Administrator_Tool_for_Mac_OS_X
http://www.actualtechnologies.com
http://www.sqlsummit.com/ODBCVend.HTM
Known Limitations: None
Excerpt of article text...
People often ask me which databases work with REAL Studio. If you use ODBC, the answer is simple: "any of them!" I've successfully used REAL Studio to connect to the following databases:
Microsoft SQL Server
Microsoft Access
Oracle
IBM iSeries
FoxPro
What is ODBC?
ODBC is an acronym for Open DataBase Connectivity. It was originally created in 1992 to make it easier for any OS to connect to databases. It is fully supported by Windows, Mac OS X, and Linux making it perfect for use with REAL Studio.
To connect to a database using ODBC, you need an ODBC driver for the database. Because all ODBC drivers implement the same API, anything that uses the ODBC API (including REAL Studio) can then connect to the database without having to provide its own native database drivers.
On Windows, you manage your ODBC connections using the ODBC Data Source Administrator control panel (see Figure 1). By default, Windows includes a few ODBC drivers and most database products will also install their own ODBC drivers for you.
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.
|
