Connecting to 2 ora. DB with same name using Centura?

[gayal]

1. Use Centura code.
2. Connect to source oracle database server.
3. Connect to destination oracle database server(?).
4. Pull records from src. db. table.
5. For every record,
Insert that record into dest db table.

I need to do the above. But, the challenge, for me, here is... the names of src and dest. databases are SAME. so, how can I assign that name to the SqlDatabase variable when I prepare the second result set? In oracle, is there any way, I can refer to 2 database having the same name(residing on diff. box)? What are settings in the sql.ini file?

I am new to Oracle and need help on this pls.

Thanks in advance.

Regards,
gayal.

[Jeff Luther]

Maybe check with your SysAdmin person but your client machine should have a TNSNAMES.ORA file that lists the DBs you can connect to by their 'external' name then some directives as to where they are.

Presumably you can rename your DB names for each so they're different and describe which server is which. I think you already have a problem: If you have 2 DBs names FOO, and you:
Set SqlDatabase = 'FOO'
the SqlConnect() call (I'm guessing) would connect to the first one in the list.