Examples

For detailed examples using Microsoft Access and Microsoft SQL Server, see Connecting to ODBC databases.

Microsoft Access

Create a host data source in dm,hosts, called msaccess.nw.

OpenDB is running on a computer called server1. On server1, an ODBC DSN called northwind is defined, which points to the Microsoft Access sample database, Northwind.

          msaccess.nw
<001>     08
<002,1>   server1 
<002,2>   3458
<002,3>   
<002,4>   30
<003>     dsn=northwind;
          

Microsoft SQL Server

Create a host data source in dm,hosts, called sqlsvr.host.

OpenDB is running on a computer running Windows with the following TCP/IP address: 123.4.5.6. On that computer, an ODBC DSN called sqlsvrdsn is defined, which points to a Microsoft SQL Server database. See Creating an OSFI host data source for more information.

          sqlsvr.host
<001>     08  
<002,1>   123.4.5.6
<002,2>   3458
<002,3>   
<002,4>   30
<003>     dsn=sqlsvrdsn;uid=sa;database=northwind;
          

Oracle

Create a host data source in dm,hosts, called oracle.host.

OpenDB is running on a computer called server2. On server2, an ODBC DSN called oracle8 is defined, which points to an Oracle database.

          oracle.host
<001>     08
<002,1>   server2
<002,2>   3458
<002,3>   
<002,4>   30
<003>     dsn=oracle8;uid=scott;pwd=tiger;

MySQL

Create a host data source in dm,hosts, called mysql.host.

OpenDB is running on a computer called localhost. On localhost, an ODBC DSN called mysql is defined, which points to a MySQL database.

          mysql.host
<001>     08
<002,1>   localhost
<002,2>   3458
<002,3>   
<002,4>   30
<003>     dsn=mysql;uid=pickuser;pwd=pick;