What to check if erwin ODBC connection fails when you click erwin icon below in Query Tool?
When you get ODBC connection error, it is most likely due to the following reasons:
1. Lack of privileges. Please make sure you installed erwin with system admin privileges. Please note that during initial installation of erwin, an ODBC server is also installed and it also creates two Data Sources, named "ERwin_r9" and "ERwin_r9_Current". If erwin is installed with inadequate privileges, this ODBC server may not be set correctly, and as a result ODBC Data Sources for erwin will not work.
2. Something missing in the connection between ERwin and the ERwin ODBC (such as, no ERwin_r9 and Erwin_r9_current listed in System DSN below - this could also be a result of # 1 above:
3. Something is blocking port 19987. Please click Configure to test the connection.
If connection from your ODBC Data Source not success, you need to test the Service Port using the utility below:
4. You may also want to check if the ODBC Driver is running. This is available under Tools | Options, under Reporting tab. This should be set to "Stop ..." as it means that it is already started and can be stopped. This can also happen if you have more than one instance of erwin running at the same time on the same PC: