This document outlines the process used to configure the BASIS BBj® ODBC Driver to access files through the PRO/5 Data Server®. It does not contain the specifics of installing the TCP/IP stack, Java or creating the data dictionary. It assumes the TCP/IP network protocol is configured and working properly for reverse name lookup capability, the correct Java JRE or JVM is installed and that the data dictionary is defined. See Troubleshooting PRO/5 Data Server TCP/IP Connections for troubleshooting connection problems. More information on creating a data dictionary is located in the BASIS Online Documentation.

BBj ODBC is one component of BBj and can be installed as a thin client. However, it is required that BBj be installed on at least one machine; it may be on the local Windows PC or on a UNIX Server. Enterprise Manager is another component of BBj. One of its functions is to manage ODBC databases. Enterprise Manager requires a GUI interface, and it is recommended this be installed on one of the Windows workstations.

Note: Not all UNIX operating systems have the appropriate JRE available. Check our Product Availability List and BBj product information as to whether your particular UNIX platform is capable of running BBj.

1. Determine where BBj, BBj ODBC, and BBj Enterprise Manager will be installed.
2. Install the appropriate JRE for your operating system. Information regarding OS requirements to run BBj may be found in the README file.
3. Install the complete BBj product on the designated machine. Specific installation instructions are documented in the Online Manuals.
4. Install BBj Enterprise Manager on one of the Windows workstations. To install a specific BBj component, select the Custom Installation button at the time of installation and choose the required component.
5. Install the BBj ODBC client on all required workstations. To install a specific BBj component (like the ODBC client), select the Custom Installation button at the time of installation and choose the required component.
6. Install the PRO/5 Data Server. Specific installation instructions for the different PRO/5 Data Server OS platforms are documented in the PRO/5 Data Server Guide. The Data Server product is installed on the server where the data files are located.

1. Modify the services file to include an entry for the Data Server. This entry is the PRO/5 service name, and the following defaults are recommended:

   pro5srv  1100/tcp  # PRO/5 Data Server
   

   The services file will need to be modified for the machine on which the Data Server is running. The following shows typical locations for the services file:

   Operating System	Services File Location
   UNIX	/etc/services
   Windows 98	\windows\services
   Windows NT/2000	%SystemRoot%\system32\drivers\etc\services

   Note: %SystemRoot% is the drive and root directory where NT was loaded.

2. Start the Data Server with logging enabled. This example will invoke the Data Server, force it to use port 1100, and log all activity to the file named ds.log in the Data Server's directory. Enabling the log file often helps to determine the cause of connection problems with the TCP/IP client or ODBC Driver. UNIX Data Server:

    
   ./pro5.server -r -l./ds.log -p1100
   

   NT/2000 Data Server PRO/5 Revision 2.04 and higher:

   The PRO/5 Data Server for Windows NT/2000 Revision 2.04 and higher is designed as a Windows NT/2000 Service. To accommodate the differences, the required steps to set up and start the Data Server with logging enabled are:

   1. From the Windows Start menu, open the Control Panel.
   2. Execute the PRO/5 Data Server applet. (This applet sets the parameters contained on the command line in previous releases.)
   3. Select the checkbox next to Enable Event Logging.
   4. Click on the Apply button to accept changes.
   5. Close the window and return to the Control Panel.
   6. Open the Services window, highlight the PRO/5 Data Server in the list and click Start. Note that the Startup Parameters line in the Services window does not have any effect on the PRO/5 Data Server.

The BBj Enterprise Manager may be used to configure ODBC databases on a local or remote server running BBj.

Note: The default user name is admin, and the default password is admin123. LocalHost is the default server, and 2002 is the default port.

1. Register the server running BBj services by right clicking on Enterprise Manager. Select Register Server. Enter the name of the server to register and keep the default port of 2002.
2. Connect to the registered server by double clicking on the server name. Use the default user and password of admin and admin123.
3. Double click on the server name to open the folder, right click on Databases, and select Attach to Existing Dictionary. Enter a name for the database. This name will be case sensitive and must be referenced correctly when creating the DSN in the ODBC Administrator.
4. Enter the path using the PRO/5 Data Server syntax for the DATA and DICTIONARY location:

   /<server_name,port=1100>/usr/bbx/project/data/

   /<server_name,port=1100>/usr/bbx/project/BBDICT/

Note: The port for PRO/5 Data Server by default is 1100 and is not related to the ports that BBj uses for its various components. The server's hostname must be used instead of its IP address, there are no spaces allowed on each line and the leading / and <, > are required. Under NT/2000, this would be the local C: drive of the NT machine where the Data Server is loaded, not the mapped drive to which workstations may have access.

5. Connecting to a PRO/5 Data Server running under UNIX requires that a user be entered with a valid UNIX login. Highlight USERS and right click. Select ADD USER. Enter a valid UNIX login and password. Do not add a root level user; the PRO/5 Data Server will not grant root level permissions.

   Note: Since the admin user for the BASIS Enterprise Manager is typically not a valid UNIX login, you will not be able to attach to the database logged into Enterprise Manager as this user.

6. Connecting to a PRO/5 Data Server running under UNIX will require a ".rhosts" file in this user's home directory. The permissions on this file are required to be 644. This file may be created with any text editor and lists the remote hosts that may access the PRO/5 Data Server. It is the name of the machine running BBj, not the BBj ODBC client machine. If BBj is running on the UNIX server, this would be the name of the UNIXserver registered in step 1. If BBj is running on a Windows machine, it is the name of the Windows machine registered in step 1.

   Sample .rhosts:

   fs1
   fs1.domain.com
   localpc
   localpc.domain.com

   Note: Some UNIX operating systems use a "hosts.equiv" instead of ".rhosts".

7. To test connectivity, disconnect and connect to the remote server as the defined user. Highlight the registered server, right click and select DISCONNECT. Right click again and select CONNECT. Enter the user name and password that was entered in step 5.
8. Highlight the newly created database and double click to see the list of tables. Right click on one of the table names and select VIEW DATA.
9. Information for further troubleshooting is available in the BASIS Knowledge Base, or in the Tech Tips section on Troubleshooting PRO/5 Data Server TCP/IP Connections.

Once the BBj ODBC Driver is installed, and a database is defined in Enterprise Manager, you must also set up a data source in the Windows ODBC Administrator tool, located in Control Panel.

1. Select the appropriate DSN tab that is required for your ODBC application.
2. Click on Add.
3. Select the BBj ODBC Driver.
4. Enter a data source Name. The data source Name is an alias that will be used to refer to your data source. The name should be short and descriptive. An optional Description field is available for extended comments.
5. The most important aspect of the configuration is the Connection section
   
   1. Enter the BBj server registered in Enterprise Manager for the Server field. (Step 1 under Using BBj Enterprise Manager, above.)
   2. Leave the default port of 2001 for the Port field.
   3. Enter the name of USER defined in Enterprise Manager for the User Name field, and enter the correct password in Password field.
   4. Enter the database name defined in Enterprise Manager for the Database field. This field is case sensitive and the name must match exactly the way it was defined in Enterprise Manager.

You are now ready to use the BASIS BBj ODBC Driver from your third-party application. Refer to your application's documentation for specific information on connecting to an ODBC or SQL data source.