> Everytime I open the project in ide, tables assigned to second
> database are linked to database1. What's happening here?

Try setting the session's AllowDefaultConnection to false.

Geoff, I thought you took care of this problem?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Sandeep" <sandeep@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 15, 2001 5:07 PM
Subject: [IBO] IBO Transactions


> I've got two database components in two different data modules in
> an application. I have a form with 4 tables of which 2 are using the
> first database component and the other two second database
> component.
>
> I also have an transaction component on this form and this is
> default transaction for all four tables. The transaction's
> IB_Connection is assigned 1st database and IBConnection1 is
> assigned 2nd database.
>
> Everytime I open the project in ide, tables assigned to second
> database are linked to database1. What's happening here?
>
> Regards
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@...
> http://www.cfl.co.nz