![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The 64-bit ODBC driver for TIBCO Object Service Broker allows a 64-bit application to access and modify TIBCO Object Service Broker table data and run stored procedures. The 64-bit ODBC driver is implemented using a 3-tier architecture. A "thin" 64-bit ODBC driver communicates via TCP/IP with a SQL service that in turn passes data access request to TIBCO Object Server Broker SDK using TIBCO Object Service Broker SDK for Java. The SQL service used by the 64-bit ODBC service is the same SQL service used by the JDBC driver and literally can be shared with JDBC drivers.On Windows systems, the SQL Service is installed as a Windows Service and is automatically started each time you reboot your machine. The services report problems in log files located in the directory jdbc/service/logging. When running production systems, you should periodically clear these directories of old log files.On UNIX systems, scripts are provided that enable a system administrator to set the SQL Service up to run as a daemon process. See Running the SQL Service.The ODBC driver for TIBCO Object Service Broker uses a number of connection attributes to connect to a TIBCO Object Service Broker node. These attributes are provided via an ODBC Data Source Name (DSN) that the caller references at connection time. The attributes supported by the 64-bit ODBC driver are the same as the connection parameters for the ODBC driver for 32-bit applications. Please refer to Keyword Description for a description of the attributes.The Microsoft ODBC Data Source Administrator is used to create ODBC data sources. However, on 64-bit Windows systems there are two versions of the administrator tool, one for 32-bit application and one for 64-bit application. For the 64-bit ODBC driver, use the Data Source Administrator that's located in the "Administrative Tools".
1. Open the ODBC Data Source Administrator from Administrative Tools menu in the control panel.
2. Click the Add... button.
3. In the Create New Data Source dialog, select the 64-bit TIBCO ODBC driver for the current release. For example, for the 6.0.0 release, select the driver named TIBCO OSB 6.0.0.0 ODBC 64-bit Adapter.
4. Click the Finish button. The TIBCO OSB ODBC Data Source Setup dialog appears. For example:
5. In the Data Source Name and Descriptions boxes, enter a name of your data source and, optionally, a description for this data source.
6. Set the Service Host name to the name of the machine where the SQL service is running. Normally this name is set to localhost.
7. Note: The Use LDAP check box and other tabs of the data source editor are currently not supported.
8. Set the Service Port to the port number of the SQL service port. By default the TIBCO client installer sets this to 19988.
9. Set the Service Data Source to OSB. Please note that Service Host and Service Port must be set if you wish to browse what Service Data sources are available.
10. In the Custom Properties field, enter the connection attributes required to connect to the TIBCO Object Service Broker node. Please refer to Keyword Description for a description of the attributes.
11. Optionally, click on the Test Connection button to verify that the data source is functional.
When testing a data source please remember that the SQL service and your TIBCO Object Service Broker must be started to successfully test a data source.
12. Click Apply to immediately save the values you have entered during the editing processes.
13. Click OK to close the data source editor.You can edit an existing data source by selecting a data source in the ODBC Data Source Administrator and clicking the Configure button. The dialog displayed is the same dialog used to create a data source.The 64-bit ODBC, 32-bit ODBC, and the JDBC drivers share the same backend implementation. Error codes, messages, implementation of stored procedures, and table behavior are the same across the interfaces.The string supplied by way of SQLDriverConnect or SQLBrowseConnect must contain the mandatory substring:DRIVER={"driver-name"};ServerDataSource=OSB;HOST=TIBCO-SQL-Service-host-name;PORT=TIBCO-SQL-Service-port;
• driver-name is the name of the 64-bit TIBCO OSB driver for ODBC.
• TIBCO-SQL-Service-host-name is the name of the host where the TIBCO SQL Service is running.
• TIBCO-SQL-Service-port is the port number of the TIBCO SQL Service.The mandatory substring is followed by a substring constructed according to the rules in Constructing the Connect String and Keyword Description. For example:DRIVER={"TIBCO OSB 6.0.0.0 ODBC 64bit Adapter"};ServerDataSource=OSB;HOST=localhost;PORT=19988;OSBHOST=localhost;OSBPORT=9068;UID=HURON1;PID=HURON1;The 64-bit ODBC driver bases its ODBC conformance levels on those supported by OpenAccess Software’s OpenAccess™. Currently, the TIBCO Object Service Broker Adapter for JDBC-ODBC uses OpenAccess 7.0. Refer to the OpenAccess manual for more information.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |