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

General discussion forum about all databases other than SqlBase.
gayal

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

Post by gayal » 11 Feb 2011, 17:27

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

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

Post by Jeff Luther » 12 Feb 2011, 01:06

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.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests