How to Connect one form to two database [message #303713] |
Sun, 02 March 2008 04:46 |
a5hhk
Messages: 17 Registered: August 2007
|
Junior Member |
|
|
HI
I want to connect one form to two database
db1 and db2
So Can I coneect the form to two database so that the data
will go to both database in the same time.
Thanks
|
|
|
Re: How to Connect one form to two database [message #303750 is a reply to message #303713] |
Sun, 02 March 2008 11:54 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
No (as far as I can tell). But, among other mechanisms, you might create a database trigger which will "transfer" records from one database to another one (via database link). Or, you might create a materialized view which will be refreshed upon committing records in a table.
|
|
|