ActualODBC

Using ActualODBC

Many common desktop applications allow you to directly access data in your database by using ODBC technology. Whether you want to create a report using FileMakerPro, perform numerical analysis using Microsoft Excel pivot tables, or create client/server applications using Microsoft Access, ODBC drivers let you include data from your database in your documents.

ODBC connectivity to OpenBase databases is provided by Actual Technologies. The latest Windows and Mac OS X versions of OpenBase ODBC drivers can be downloaded from http://www.actualtechnologies.com .

By default, the ODBC drivers are installed in a non-expiring evaluation mode. While in evaluation mode, the driver is fully functional except that it only returns 3 rows from any query. This mode allows you to verify that you can connect to your database and that your application works with the driver before purchasing a license. Once a license key has been entered, the driver will return all rows from all queries.

License keys are purchased directly from Actual Technologies. Various individual and quantity license arrangements are available. For more information, send an e-mail to moc.seigolonhcetlautca|ofni#moc.seigolonhcetlautca|ofni .

Installing the Drivers

The OpenBase drivers are designed for easy installation and setup. Separate installers are available for Windows and Mac OS X. Installation normally only takes a few minutes.

Windows

1. Locate and launch the Windows installer for the OpenBase ODBC driver named setup.exe
2. When the installer wizard appears, press the Next button
3. On the “Ready to Install” panel, press the Install button to begin the installation
4. Once installation is complete, press the Finish button to close the installer

You are now ready to configure a data source name (DSN).

Mac OS X

1. Locate and launch the Mac OS X installer for the OpenBase ODBC driver named Actual_OpenBase.mpkg
2. When the installer setup assistant appears, press the Continue button until you reach the panel “Select Destination” panel. Select the hard drive containing your System folder and press Continue.
3. On the “Installation Type” panel, press the Install button to begin the installation.
4. You will need to provide the user name and password of an OS X account with administrator access on your Mac.
5. Once the installation is complete, press the Close button to exit the installer.

You are now ready to configure a data source name (DSN).

Configuring a Data Source Name (DSN)

In order to connect to the OpenBase database from an application such as Microsoft Excel, you must first create a DSN, which specifies the address of the OpenBase server and the name of the database to which you will connect.

Windows

1. From the Windows “Start” menu, select “Control Panel” (may be under “Settings” menu)
2. Open the Administrative Tools folder
3. Open the “Data Sources (ODBC)” application
4. When the ODBC Data Source Administrator application appears, press the Add button to create a new User DSN.
5. Select Actual OpenBase from the list and press Finish
6. Enter the name of the DSN (name it whatever you like – most people just use the name of the database) and the database name. If your OpenBase database resides on a different server, enter the IP address of that server – otherwise use “localhost”.
7. Press OK to save the new DSN
8. Press OK to exit the ODBC Data Source Administrator application.

You are now ready to connect to your database using your application. See your application’s documentation for details.

Mac OS X

1. From the Utilities folder in the Applications folder, launch the OpenLink / iODBC Administrator (NOTE: do not use the application “ODBC Administrator” provided by Apple with Mac OS X. It has a bug that will not permit you to configure your DSN).
2. When the OpenLink ODBC Administrator window appears, press the Add button to create a new User DSN.
3. Select Actual OpenBase from the list and press Finish
4. Press the Continue button to advance to the Data Source panel.
5. Enter the name of the DSN (name it whatever you like – most people just use the name of the database).
6. If your OpenBase database resides on a different server, enter the IP address of that server – otherwise use “localhost”.
7. Press the Continue button to advance to the Database panel.
8. Enter the name of your database and press Continue.
9. To test your connection, press the Test button, and enter your user ID and password when prompted.
10. Press Done to save the new DSN.
11. Press OK to exit the ODBC Administrator application

You are now ready to connect to your database using your application. See your application’s documentation for details.

Technical Support

Technical support for the ODBC drivers is provided by Actual Technologies. If you have an issue or a question, send an e-mail to moc.seigolonhcetlautca|troppus#moc.seigolonhcetlautca|troppus .

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License