Ce contenu n'est pas disponible dans la langue sélectionnée.
8.6. Configure ODBC Options on Microsoft Windows
Prerequisites
- You must have logged into the workstation with administrative rights.
- You must have used the Control Panel’s Data Sources (ODBC) applet to add a new data source name.Each data source name you configure can only access one VDB within a Teiid System. To make more than one VDB available, you need to configure more than one data source name.
- From themenu, select -> .
- The Control Panel displays. Double-click Administrative Tools.
- Double-click Data Sources (ODBC).
- The ODBC Data Source Administrator applet displays. Click the tab associated with the type of DSN you want to add.
- The Create New Data Source dialog box displays. In the Select a driver for which you want to set up a data source table, select .
- Click.
- In the Data Source Name edit box, type the name you want to assign to this data source.
- In the Database edit box, type the name of the virtual database you want to access through this data source.
- In the Server edit box, type the host name or IP address of your Teiid runtime.
Note
If you are connecting via a firewall or NAT address, you must enter either the firewall address or the NAT address. - In the Port edit box, type the port number to which the system listens for ODBC requests. (By default, Red Hat JBoss Data Virtualization listens for ODBC requests on port 35432.)
- In the User Name and Password edit boxes, supply the user name and password for the Teiid runtime access.
- Leave SSL Mode to disabled. (SSL connections are unsupported at present.)
- Provide any description about the data source in the Description field.
- Click on thebutton and configure the options. Tick , , , and and set to 255, to 8190, and to dd_:.On the second page, click, , , and set the to 0x0.
- Click.You can optionally clickto validate your connection if Red Hat JBoss Data Virtualization is running.
Name | Description |
---|---|
and | Should not be used. |
Use | and andIt is recommended that | is enabled and are disabled.
SSL mode | See Security Guide https://access.redhat.com/documentation/en/red-hat-jboss-data-virtualization/6.4/paged/security-guide/ |
Use | andShould be used to better manage resources when large result sets are used. |
Logging/debug settings can be utilized as needed.
Settings that manipulate datatypes, metadata, or optimizations such as
, , , , are ignored by the server and have no client side effect.
Any other setting that does have a client-side effect, such as
, may be used if desired but there is currently no server-side usage of the setting.