access two servers with one program
Does anyone have a skeleton configuration and program that allows
one program to do reads on different servers on the same box.
General idea of what i want to do -
_______________
onconfig.test\\ | |
>--|i-star/odbc/ ? |===> program_a
onconfig.prod/ |_______________|
Some sort of configuration
to allow each to be accessed
at the same time without a
siamese twin connection. In
other words each server can
be bounced without the other
caring.
program_a
select field1 from testdb@test:customer where custid = 12345;
select fielda from proddb@prod:customer where custid = 12345;