How to Set Up an
ODBC Data Source

ODBCAccess MaximizerSalesForceSalesLogixNetLedger.jpg (1350 bytes)OracleOutlookPalmGroupWiseMaestroLotus NotesWord ACT!FoxProGoldmineSharkWareTeleMagic  

Open Data Base Connectivity is the feature which allows many different database products to talk to each other.  It makes for a more open discussion between them.  It allows many database tools and utilities to use the data, such as Crystal Reports, without being confined to a particular product. 

Database files are basically rows and columns of information.  The rows are the records, and the columns are called fields.  Since each database software works with these, it is natural that there must be some way for them to work together.

For example, Microsoft FoxPro has its own format, but through ODBC can read and write in Access format.  ODBC allows programs to communicate, not only between Microsoft products, but between Lotus, Oracle, Maximizer, and other database manufacturers.

The Open Data Base Connectivity Administrator utility is located in the Windows Control Panel, along with other Administrative Tools.  You may find the executable in:


Let's use the example of setting a source for the software. 

Here's what it looks like when all set up for Maximizer software.


Let's set one up from scratch for Microsoft Access

1. Select the ODBC Administrator, to see this screen.

2. Select the Add.. button, then select the Driver you wish, such as Microsoft Access

3. Select the Select button to choose the Database.

4. Point to the file you want to connect to.

5. Enter the Data Source Name and Description, which can be words of your choice.

6. Select OK to see your ODBC Driver in the list. 

Congratulations!  Now it is available to other programs.

Setting up ODBC to FileMaker Pro

Links for more information

Setting Up an ODBC Data Source (Microsoft Visual FoxPro)
Before you can create remote views or use SQL pass-through, you
must install an ODBC driver and set up an ODBC data source. ... igcustomizing_your_system_after_installation.asp

To set up an ODBC data source
GFI. To set up an ODBC data source. ... Click OK, and exit the ODBC Data Source Administrator.
Your data source is now set up! Home Contents Previous.  ... tosetupanodbcdatasource.htm

IT Help Central - Set up and use an ODBC connection to a database
... Set up and use an ODBC connection to a database. ... Access to obtain access to information
on a database server, it is necessary to install an ODBC data source. ...

Setting Up An ODBC System Data Source Name
Setting Up an ODBC System Data Source Name (DSN). To set up an ODBC DSN.
1. Click ... click OK. 9. In ODBC Data Source Administrator, click OK. ...

123008 - HOWTO: Set Up ODBC Data Sources When Distributing Apps
... This program allows a user to install ODBC drivers and set up or modify ... required
only if your application uses Crystal Reports to access an ODBC data source. ... kb/articles/Q123/0/08.asp

Creating ODBC Data Sources
... as ODBC data sources. The following example shows you how to set up
an ODBC data source for a Sybase Adaptive Server 6 database. ... docs/helpcore/books/instODBC.html


Links by Software