How to fix JDBC Bridge Error - No connection could be made because the target machine actively refused it 127.0.0.1:50433

ODBC PowerPack JDBC-ODBC Bridge
1

Problem

If you use ZappySys JDBC-ODBC Bridge in a rare case scenario, you may face the following error.

No connection could be made because the target machine actively refused it 127.0.0.1:50433

Possible Cause

This error usually happens due to two reasons

  1. Default Port 50433 (for JDBC Bridge) is used by another application and is causing conflict with ZappySys JDBC Bridge Driver
    -OR-
  2. Default Port 50433 is part of the reserved port ranges

How to check if port used by another application?

  1. To check which process uses this port, you can use tools like [Resource Monitor] or TcpView.
  2. On Windows, search “Resource monitor” in the start menu and open it. Go to Network Tab > TCP Connections Panel.
  3. Sort by “Local Port” column and find which process is holding port 50433

How to check if the port is in the reserved range?

  1. Open the command line as an administrator
  2. Run the following command
    netsh int ip show excludedportrange protocol=tcp
  3. If you see a range like below, that means 50433 is part of that reserved range.
    50400 50600

Possible Fix

Let’s look at two possible solutions to fix this issue.

Change the default port to another port (For New Version)
If you have ODBC PowerPack v2.0.2 or higher, then you can change the default port.

  1. Go to ZappySys ODBC Installation directory (Usually below location)
    C:\Program Files (x86)\ZappySys\ZappySys ODBC PowerPack
  2. Find the file name JdbcBridge.properties
  3. File not found, create a new file using the below command (Replace 12345 with any random port not used by any application)
echo app.port=12345 > "C:\Program Files (x86)\ZappySys\ZappySys ODBC PowerPack\JdbcBridge.properties"
  1. If the file is already found, just open in any text editor and change the following line if found else add new line (Replace 50433 with any random port not used by any application)
    app.port=50433
  2. Save file changes
  3. Now, try to test JDBC Bridge again, and see if the error is resolved

Restart Windows NAT Driver service

  1. Open the command line as an administrator
  2. Run the following command
    net stop winnat && net start winnat
  3. You will see output like this
C:\Windows\system32> net stop winnat && net start winnat

The Windows NAT Driver service was stopped successfully.

The Windows NAT Driver service was started successfully.
  1. Now try to test JDBC Bridge again see error is resolved