Hello All,

I am not a Baan user (literally). But would like to get over the following problem.

I have a need to connect to a Baan Informix DB thru JDBC. Version of Baan system is triton 3.10 b. When I contacted baan admin to get information required for JDBC drivers, the person was not very knowledgable and does not know how to provide the information I am asking for.

Basically, I need following things:

port # - port that database is running on
InformixServer
Database name

Since the so-called admin has no clue about the above settings. And I am pretty confident the baan was setup using default values. Hence, I would like to take the boards help to know what would be the defaults for the Baan triton 3.10b?

Also, can any one provide me steps/procedure for finding these values? I can provide the same to the admin, so that I can get the values from admin, if they are different from defaults.

Thanks,
Satish

Before you get too deep into this.

You may wish to know that Informix on Triton will not have any
useable indexes on the tables for your program. Triton uses a "level 1"
database driver, which has a field that containts a "hash index" of which
the informix indexes are built on.

Dave

Thanks for the info dave. But I have new information about the baan system. It does not use informix as I thought earlier, but uses inbuilt database - TBase 6.0.

With the new piece of information, I would like to know if I can connect to this database thru JDBC? If yes, are there any drivers available?

Is there any other mechanism to talking to the database other than baan application?

Any info regarding this is very much appreciated.

Thanks,
Satish

You would have to purchase Baan's ODBC driver which is part of their
Open Architecture suite. Except that it does not work with Triton.

Dave