How, if its possible, can I access two databases simultaneously (for data transfer) when the encryption for each is different?

Roy Lambert

Roy,

> How, if its possible, can I access two databases simultaneously (for data transfer) when the encryption for each is different?

It should be possible to use two different sessions with local settings
and thus different Passwords.

Uli

Uli


AFAIK you can go across databases but not across sessions.

Roy Lambert

Roy,

<< How, if its possible, can I access two databases simultaneously (for data
transfer) when the encryption for each is different? >>

It's not possible to access different databases using different sessions,
therefore you can't.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< How, if its possible, can I access two databases simultaneously (for data
>transfer) when the encryption for each is different? >>
>
>It's not possible to access different databases using different sessions,
>therefore you can't.

Its not a problem yet so I have time to try and think up a solution because I can see my needing it at some point.

Roy Lambert

Tim,

> It's not possible to access different databases using different sessions,
> therefore you can't.

I am a bit confused now. Didn't we discuss exactly this some time ago?

http://www.elevatesoft.com/newsgrp?action=openmsg&group=16&msg=10165&page=2

I realized the access of a second database by creating a second session
and it works.

Uli

Uli


If you look at Tim's answer to my post in that thread

-------------------------------------------------------------------------------------------------------
<< For my benefit in case I ever have to do it with the information in two
different sessions how do you get it from one to the other? >>

He's not transferring the session information directly, he's using a medium
of exchange (registry, .ini) that allows to different sessions to read and
use the same configuration information.  The "read and use" part depends
upon your application, but the EDB Manager is a good example of how to do it
with an .ini file.
--------------------------------------------------------------------------------------------------------------

The problem is that whilst I can create a second session to access the other table and then use Delphi to do things to them I can't reference both of them in the same piece of SQL. To do that you'd have to be able to qualify a table not only with the database but also the session which isn't supported.

Roy Lambert

Roy,

> The problem is that whilst I can create a second session to access the other table and then use Delphi to do things to them I can't reference both of them in the same piece of SQL. To do that you'd have to be able to qualify a table not only with the database but also the session which isn't supported.

That's true (misunderstanding).
But at least you have a sort of "interface" to transport data from one
table to the other.

Uli