Interbase 6 and jdbc access

[Joserra]

Hi all,

We have installed (from looong time ago) a interbase 6 in a Windows
machine. Now we need to access data from JAVA. We are atrying every
interclient we found!
Almost all of them (which work in interbase 7.1) now give this error:
ERROR (DataBaseService.java:110) - ERROR DataBaseService
java.sql.SQLException: interbase.interclient.IBException:
[interclient][interbase]connection rejected by remote interface
at interbase.interclient.Connection.remote_ATTACH_DATABASE(Unknown
Source) at interbase.interclient.Connection.connect(Unknown
Source) at interbase.interclient.Connection.<init>(Unknown
Source) at interbase.interclient.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at ...

We thinks this is because of version problem. If we try interclient
2.0.1, the process hangs and nothing happens.
We know the interbase server is working, and there is no problem with
firewalls.
Is it possible to access with JDBC to interbase 6? And, where can we
find that interclient?

Thanks in advance!!

[Quinn Wildman (CodeGear Developer Support)]

The InterClient you need is included with your InterBase product. Make
sure you run <insert name here!> on the InterBase server. I've placed
"insert name here", because I cannot recall what it is called, but it
must be run on the InterBase server when using this version of
InterClient. It's part of the InterClient install, so should be obvious.

[Martijn Tonies]

> The InterClient you need is included with your InterBase product. Make
> sure you run <insert name here!> on the InterBase server. I've placed

The server part of "InterClient" user to be called "InterServer".

> "insert name here", because I cannot recall what it is called, but it
> must be run on the InterBase server when using this version of
> InterClient. It's part of the InterClient install, so should be obvious.

As far as I know, the newer InterClients don't need it anymore,
because they are JDBC type 4 drivers. The older InterClient
needs the server part though.

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

[Quinn Wildman (CodeGear Developer Support)]

Yup, InterServer is the server part. Yup, since InterBase 7.0
InterServer is no longer part of equation. This is because we switched
from a type 3 driver to a type 4 driver.

[Craig Stuntz [TeamB]]

Martijn Tonies wrote:

> As far as I know, the newer InterClients don't need it anymore,
> because they are JDBC type 4 drivers. The older InterClient
> needs the server part though.

Right.

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Useful articles about InterBase development:
http://blogs.teamb.com/craigstuntz/category/21.aspx

[Joserra]

In interbase 6.0 there is no interclient file included.
Anyway, we have fixed the problem with the jdbc driver for firebird
1.5.5, wich seems to be the one just released after the 6.0 went opensource.

Quinn Wildman (CodeGear Developer Support) escribió:

[Quinn Wildman (CodeGear Developer Support)]

It's on my CD ...

Joserra wrote:
> In interbase 6.0 there is no interclient file included....

[Bill Todd]

Quinn Wildman (CodeGear Developer Support) wrote:

> It's on my CD ...

It was on the commercial 6.0 CD but was never released as part of the
open source version of IB. AFAIK, no version of InterClient or
InterServer was every released as open source.

--
Bill Todd (TeamB)

[Joserra]

Fortunatelly, firebird jdbc driver worked for us...

Thanks for the info

Bill Todd escribió: