Hi,
I'm stuck now!! I'm trying to setup an interactive script on our conversant that queries tables on a remote database, but am having great difficulties.
I have been following the manual but to no avail. Basically we have edited the tnsnames.ora on the conversant, with the correct info for the remote host.
We can now tnsping the remote db, and log into it using sqlplus.
Then I have setup the link as DB2_Remote in the database administration section of the conversant. In my script I have specified the login name / pw. When i go to add a table to my script from the external host, it just sits there thinking about it then returns an error saying the DIP cannot connect.
Does anybody have any ideas??
I'm stuck now!! I'm trying to setup an interactive script on our conversant that queries tables on a remote database, but am having great difficulties.
I have been following the manual but to no avail. Basically we have edited the tnsnames.ora on the conversant, with the correct info for the remote host.
We can now tnsping the remote db, and log into it using sqlplus.
Then I have setup the link as DB2_Remote in the database administration section of the conversant. In my script I have specified the login name / pw. When i go to add a table to my script from the external host, it just sits there thinking about it then returns an error saying the DIP cannot connect.
Does anybody have any ideas??