update two databases simultanoeusly

[swot]

Hi guys,
i was wondering how the following problem can be attempted.
I have two databases with the same structure.
they both have a table Students.

now from my program i have to update the table from both the databases at the same time with the same data.
i use stored procedures to update the table.

can i connect to two databases at same time in delphi.
if yes,how can i do that and also update both of them together at same time

thanks...waiting eagerly for your reply

 

[StevenK]

Could you not have a procedure that you call to perform the two updates together ? You could make use of 2 TQuery components for the INSERT/UPDATE actions, each of these being connected to a different TDatabase component pointed to the databases in question.
Would this work for you ?
Hope it helps .

Steve