...
To install the ODBC you need to Run the ODBC "setup.exe" located in the root of the RX-Universe folder (C:\RxUniverse\ODBC\Install). Please note that the "ACUODBC" product requires a licensing key that is available at a charge.
...
- The Query Wizard will launch and give the option of the data fields that can be imported and Select the tables you needed for your query and click "Next" (in this example we use:OMLENS)
(For a list of all XFD files available follow the link here:→ https://rxuniverse.atlassian.net/wiki/display/RXUN/ODBC+XFD+FilesDescription)
- Click "Next", unless you require to Filter Data.
...
- Query result will be populated in Excel indicating a successful ODBC setup.
ODBC Interface May Cause Slowdown
The ODBC interface may cause some slowdown on the server; these steps might help speed things up:
- Open the ODBC Data Source Administrator box.
- Go to the “Tracing Tab”.
- Click “Stop Tracing Now”.
- Go to the System DNS tab, and pick Omics6 and then “configure”.
- Open the “Tracing” tab and select “Stop All”.