Is there an easy way to test my Voyager ODBC configuration to make sure my connection works?

Question

How to test the Voyager ODBC configuration to make sure the connection to the Voyager server works.

Answer

Use the Windows "ODBC Data Source Administrator" application as shown below.

Note that successful testing requires that the ODBC drivers are installed and that you have a correct tnsnames.ora file in the proper location on your PC.

1. Determine your ODBC version (32-bit or 64-bit) - but note that Voyager only supports 32-bit.
2. Go to Windows Search and type in: ODBC.
3. Select the appropriate "ODBC Data Sources" Application for your version of the drivers (32-bit or 64-bit) to open the "ODBC Data Source Administrator" application.
   
   
    
4. On the "System DSN" tab of the "ODBC Data Source Administrator" application, select "VGER" and click the "Configure" button.
   
   
    
5. In the "Oracle ODBC Driver Configuration" window enter "VGER" for both the Data Source Name and the TNS Service Name.
6. Enter your Read-Only user name (e.g., ro_xxxdb) for the User ID.
7. Click the "Test Connection" button.
   
   
    
8. In the "Oracle ODBC Driver Connect" screen make sure your "Service Name" is VGER.
9. Enter your Read-Only User Name and its Password.
10. Click the "OK" button.
    
    
     
11. You will see "Connection successful" returned if your connection configuration is correct.
    
    
    

• Article last edited: 21-Feb-2020