SetODBC Help
Learn how to troubleshoot and navigate common issues with ODBC connections in SetODBC with this helpful guide.
The Set ODBC program allows you to create/delete User IDs with which you establish Other Database Connections (ODBC). VSI provides instructions for creating the User and establishing the connection. VSI does not support 3rd party reporting, querying, etc… using the ODBC connection.
See Also: ODBC Installation Instructions for Progress 11.7/RecTrac 3.1.
See Also: RecTrac Dictionary Listing
To Create an ODBC User and Establish an ODBC Connection:
- Enter a User ID in the ODBC User ID field. This must a User ID in your RecTrac database.
- Enter a password in the ODBC Password and re-enter it in the Confirm Password field. This is the password for the User ID you entered above.
- Enter the RecTrac DB Host Name. This is the name of your RecTrac server.
- Enter the Port Number of the RecTrac database to which you wish to connect.
- If connecting to the Live database, then enter the port number of your RecTrac Live databse. By VSI-default, this is port 4000. Your setup may vary (i.e. you may be using port 4050 for the RecTrac Live databse, etc….)
- If connecting to the Demo database, then enter the port number for your RecTrac Demo database. By VSI-default, this is 4003. Your setup may vary (i.e. you may be using port 4053 for the RecTrac Demo database, etc….)
- Enter the name of your RecTrac database. By VSI-default, this is RecTrac, but your setup may vary. (i.e. your database name could be rectrac, RECtrac, RECTRAC, etc…
- Expand the Drop-down list for Process Optionand select:
- Add ODBC User - To create the new User listed in the ODBC User ID field.
- Remove ODBC User - To remove the User listed in the ODBC User ID field.
- Click the Combo Box icon and select the Database Tables to Read.
- Click Process ODBC Options. The process runs on the AppServer; you will be notified when the process is complete.
- Click X to exit the program.
SetODBC_Tab1
ODBC User ID (SetODBC_UserID)
Enter a User ID. This must a User ID in your RecTrac database. This field is case-sensitive.
See Also: ODBC Installation Instructions for Progress 11.7/RecTrac 3.1.
DeleteODBC Password (SetODBC_Password)
Enter a password and re-enter it in the Confirm Password field. This is the password for the User ID you entered.
This field is case-sensitive.
DeleteConfirm Password (SetODBC_ConfirmPassword)
Re-enter the password. This is the password for the User ID you entered.
This field is case-sensitive.
DeleteDB Host Name (SetODBC_DBHostName)
Enter the RecTrac DB Host Name. This is the name of your RecTrac server.
DeleteDB Port (SetODBC_DBPortNumber)
Enter the Port Number of the RecTrac database to which you wish to connect.
- If connecting to the Live database, then enter the port number of your RecTrac Live databse. By VSI-default, this is port 4000. Your setup may vary (i.e. you may be using port 4050 for the RecTrac Live databse, etc….)
- If connecting to the Demo database, then enter the port number for your RecTrac Demo database. By VSI-default, this is 4003. Your setup may vary (i.e. you may be using port 4053 for the RecTrac Demo database, etc….)
DB Name (This value is case sensitive) (SetODBC_DBName)
Enter the name of your RecTrac database. By VSI-default, this is RecTrac, but your setup may vary. (i.e. your database name could be rectrac, RECtrac, RECTRAC, etc…
DeleteProcess Option (SetODBC_ProcessOption)
Expand the Drop-down list and select:
- Add ODBC User - To create the new User listed in the ODBC User ID field.
- Remove ODBC User - To remove the User listed in the ODBC User ID field.
Select Tables To Read (SetODBC_TablesToRead)
Click the Combo Box icon and select the Database Tables to Read.
THEN
Click Process ODBC Options. The process runs on the AppServer; you will be notified when the process is complete.
Refer to the RecTrac Dictionary Listing as needed.
Delete