Hi,

Did you try this syntax?

jdbc:firebirdsql:<IP>/3050:c:\Vol1\lcs\AUEG\Daten\mand2.GDB


Catalin.

On 29 July 2010 15:11, michael.strupp <michael.strupp@...> wrote:

>
>
> Hello
>
> I want to write a java client that uses jdbc to connect to the firebird-db
> over a vpn network.
> I downloaded the jaybird-full-2.1.6.jar and put it to the java build path
> of jdbc in eclipse.
>
> I'm not sure how to build the URL to connect to the db, because of the vpn
> network.
>
> I tried <IP>:c:\Vol1\lcs\AUEG\Daten\mand2.GDB and
> jdbc:firebirdsql://<IP>:c:\Vol1\lcs\AUEG\Daten\mand2.GDB:3050:/mand2 and
> jdbc:firebirdsql://<IP>:c:\Vol1\lcs\AUEG\Daten\mand2.GDB
>
> where <IP> is always the ip to the db server. The path is also correct.
>
> The code looks like that...
>
> private void connectL1()
> {
> try
> {
> Class.forName("org.firebirdsql.jdbc.FBDriver").newInstance();
> }
> catch (InstantiationException e)
> {
> e.printStackTrace();
> }
> catch (IllegalAccessException e)
> {
> e.printStackTrace();
> }
> catch (ClassNotFoundException e)
> {
> e.printStackTrace();
> }
> try
> {
> this.con = DriverManager.getConnection(this.l1IP, this.l1user, this.l1pw);
> }
> catch(SQLException ex)
> {
> ex.printStackTrace();
> System.out.println("SQLException: " +ex.getMessage());
> System.out.println("SQLState: " + ex.getSQLState());
> System.out.println("VendorError: " + ex.getErrorCode());
> }
> }
>
> this.l1user is the DB User und this.l1pw is the password of the user.
>
> And the error message is:
>
> No suitable driver found for <IP>:c:\Vol1\lcs\AUEG\Daten\mand2.GDB
> at java.sql.DriverManager.getConnection(DriverManager.java:602)
> at java.sql.DriverManager.getConnection(DriverManager.java:185)
> at com.inzeit.dbview.DBConnect.connectL1(DBConnect.java:132)
> at com.inzeit.dbview.DBConnect.<init>(DBConnect.java:103)
> at com.inzeit.dbview.DBConnect.main(DBConnect.java:598)
>
> How do i have to build the url to connect to the db-server?
>
> Kind regards,
> Michael
>
>
>


[Non-text portions of this message have been removed]