The most important item here is the Server address - make sure that you enter the correct IP address for the server that’s running the database. For example, the following screen shot shows a DSN that has been set up to access the example Northwind database running on MS Sql Server: Install the ODBC driver and set up a DSN as instructed in the Read Me file. We recommend the drivers offered by Actual Technologies. The following instructions assume that you are using an Actual Technologies driver. In order to access an ODBC source from a Mac, you must first install an ODBC driver - these do not come as standard with the Mac OS operating system.

Select any appropriate options, such as Read Only.Įnter a Login Name and Password and click OK. Locate the object you want to open (database, spreadsheet, etc.) and select it. In the Setup dialogue, enter a Data Source Name and Description. In the Create New Data Source dialogue, select the appropriate driver for the data source (e.g., Microsoft Access Driver).

Please consult your database or systems administrator for assistance if necessary.ĬONFIGURING A DSN ON WINDOWS 2000 THE ODBC CONTROL PANELĭouble-click the Data Sources (ODBC) icon. If you are using a different operating system, the actual steps might be a bit different. As an example of the configuration process, we will take you through the steps for configuring ODBC on Windows 2000. ODBC is a Microsoft protocol, so it’s built in to the Windows operating system. If you do not already have one set up, following are basic instructions. If your data source is an ODBC source (database, spreadsheet, etc.) running on Windows, you will need to set up a User Data Source Name (DSN).

Dbisam Odbc Driver Windows