Hello,
Is it possible to use one dbisam odbc driver to access 2 folders containing free tables at the same time without gathering all the tables in one folder, since in my case i have 2 folders 'docs'
and 'logistics', each containing of a collection of free tables.
As I know i can link the odbc driver data source to only one folder which is the dedicated database.
In the application i am implemeting using vb.net and the dbisam odbc driver, i want to be able to access both tables at the same time.
Please advise if it is possible and if not is there ant solution to do that.
Thank you
Hiba

Hi Hiba,

Yes it is possible to do this.

You need to create 2 OdbcConnections one for each folder.
Just change the connection string for each one to point to the required
folder.

Chris Holland


Hiba Hable wrote:
> Hello,
> Is it possible to use one dbisam odbc driver to access 2 folders containing free tables at the same time without gathering all the tables in one folder, since in my case i have 2 folders 'docs'
> and 'logistics', each containing of a collection of free tables.
> As I know i can link the odbc driver data source to only one folder which is the dedicated database.
> In the application i am implemeting using vb.net and the dbisam odbc driver, i want to be able to access both tables at the same time.
> Please advise if it is possible and if not is there ant solution to do that.
> Thank you
> Hiba
>

Hello Chris,
In my vb.net application and using sqldataadapter to excute any sql statment, i cant use except one odbc connection. thus, i cant create 2 odbc connection as u suggested. so any other
solution?
thx

Chris Holland <mail@chrisholland.me.uk> wrote:

Hi Hiba,

Yes it is possible to do this.

You need to create 2 OdbcConnections one for each folder.
Just change the connection string for each one to point to the required
folder.

Chris Holland


Hiba Hable wrote:
> Hello,
> Is it possible to use one dbisam odbc driver to access 2 folders containing free tables at the same time without gathering all the tables in one folder, since in my case i have 2
folders 'docs'
> and 'logistics', each containing of a collection of free tables.
> As I know i can link the odbc driver data source to only one folder which is the dedicated database.
> In the application i am implemeting using vb.net and the dbisam odbc driver, i want to be able to access both tables at the same time.
> Please advise if it is possible and if not is there ant solution to do that.
> Thank you
> Hiba
>

Hi Hiba,

Do you mean VB won'y let you have 2 OdbcConnections in the designer?

If so can you create them manually using something like:

OdbcConnection Connection1 = new OdbcConnection();
OdbcConnection Connection2 = new OdbcConnection();

(or whatever the syntax in VB is)

Chris Holland


Hiba Hable wrote:
> Hello Chris,
> In my vb.net application and using sqldataadapter to excute any sql statment, i cant use except one odbc connection. thus, i cant create 2 odbc connection as u suggested. so any other
> solution?
> thx
>
> Chris Holland <mail@chrisholland.me.uk> wrote:
>
> Hi Hiba,
>
> Yes it is possible to do this.
>
> You need to create 2 OdbcConnections one for each folder.
> Just change the connection string for each one to point to the required
> folder.
>
> Chris Holland
>
>
> Hiba Hable wrote:
>> Hello,
>> Is it possible to use one dbisam odbc driver to access 2 folders containing free tables at the same time without gathering all the tables in one folder, since in my case i have 2
> folders 'docs'
>> and 'logistics', each containing of a collection of free tables.
>> As I know i can link the odbc driver data source to only one folder which is the dedicated database.
>> In the application i am implemeting using vb.net and the dbisam odbc driver, i want to be able to access both tables at the same time.
>> Please advise if it is possible and if not is there ant solution to do that.
>> Thank you
>> Hiba
>>
>

Hiba,

<< In my vb.net application and using sqldataadapter to excute any sql
statment, i cant use except one odbc connection. thus, i cant create 2 odbc
connection as u suggested. so any other solution? >>

Why not just use a different data adapter ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Hiba,

<< In my vb.net application and using sqldataadapter to excute any sql
statment, i cant use except one odbc connection. thus, i cant create 2 odbc
connection as u suggested. so any other solution? >>

<<Why not just use a different data adapter ?>>

i cant use except data adapter in order to excute sql stmts which only takes one connection.so ? any suggestion?

Tim Young
Elevate Software
www.elevatesoft.com

Hiba,

<< i cant use except data adapter in order to excute sql stmts which only
takes one connection.so ? any suggestion? >>

You can use any ODBCCommand objects with a data adapter, and the ODBCCommand
objects can be associated with any connection that you want.

--
Tim Young
Elevate Software
www.elevatesoft.com