Connecting to Remote Advantage Database server from Java
<p>We are migrating a project from Dotnet to Java. The connection string in dot net is as follows </p>

<pre><code>Data Source=\\ip:port\timesoft$\TP8\COMPANY\KCLMAIN\KCLMAIN.add;ServerType=REMOTE;User ID=ITUSER;SecurityMode=IGNORERIGHTS;Password=123456;
</code></pre>

<p>In Java we have written a test program to check the connectivity, which is a follows</p>

<p>I have added the adsjdbc.jar (v8.1)</p>

<pre><code>Class.forName("com.extendedsystems.jdbc.advantage.ADSDriver");
    connection = DriverManager.getConnection("jdbc:extendedsystems:" +
    advantage://ip:port/timesoft$/TP8/COMPANY/
    KCLMAIN/KCLMAIN.add;user=ITUSER;password=123456");
</code></pre>

<p>or with catalog</p>

<pre><code>Class.forName("com.extendedsystems.jdbc.advantage.ADSDriver");
connection = DriverManager.getConnection("jdbc:extendedsystems:" +
advantage://ip:port;catalog=//ip:port/timesoft$/TP8/COMPANY/
KCLMAIN/KCLMAIN.add;user=ITUSER;password=123456");
</code></pre>

<p>But it throws connection reset error, please suggest what is wrong.
Also, I'm not able to set the SecurityMode=IGNORERIGHTS; and ServerType=REMOTE; in drivermanager.getconnection. if we pass these it says unknown parameter.</p>