Error Connecting Database With Progress ODBC
Symptom
When trying to connect to a Progress database via ODBC, you may receive the following error message:
ERROR [HY000][DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source
Applicable to
BarTender 2019 and later
Progress OpenEdge 10.2B Driver
Solution
The problem is that the Progress ODBC DSN configuration dialog does not provide an option to save the password needed for the connection. Thus, the connection fails.
- Close BarTender.
- Open Registry Editor (regedit.exe from a command prompt).
- Create a backup of your current registry.
- By going to File > Export in Regedit, selecting a file name and a folder and making sure that the Export Range is set to All.
- Go to HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI and click on the DSN name - domdata.
- Add a new string value named Password and set value as the actual password.
- Close registry editor.
- Re open BarTender and try the connection.
If this does not work, please repeat the steps but rename the Registry key in step 5 to PWD and set value as the actual password.