Products | Versions |
---|---|
TIBCO Data Virtualization | 8.0 and above |
To undeploy the current JDBC-ODBC driver:
Open command prompt, navigate to [TDV SERVER_INSTALL_DIRECTORY]\bin and run the following command:
> server_util.bat -server <enter_server_name> -port <enter_TDV_base port> -user <enter_admin_username> -password <enter_admin_password> -undeploy -name JDBCODBC -version 1
Example for reference:
> server_util.bat -server localhost -port 9400 -user admin -password password -undeploy -name JDBCODBC -version 1
Sample Output:
Listening for transport dt_socket at address: 8005
Success
Note:
The key here is to pass the right name of the adapter. In this case, it is JDBCODBC.
At this point, you will observe that the JDBC-ODBC Bridge adapter is no longer available for selection while creating the data source.
To deploy the JDBC- ODBC Bridge driver:
1. Copy the latest .jar (example: jdbcodbc.jar) file to [TDV SERVER_INSTALL_DIRECTORY]\bin folder
2. Open command prompt, navigate to [TDV SERVER_INSTALL_DIRECTORY]\bin and run the following command:> server_util.bat -server -server <enter_server_name> -port <enter_TDV_base port> -user <enter_admin_username> -password <enter_admin_password> -deploy -package <my_adapter_name>.jar
Example for reference:server_util.bat -server localhost -port 9400 -user admin -password password -deploy -package JDBCODBC.jar
Sample Output:Listening for transport dt_socket at address: 8005
Success