Given an IP address, what is the procedure for contacting a DB at that address.

We have a DB instance runningn here, and so can contact it easily using SQL Plus. But now we want to try to put data into a table in a DB running on another facility’s network. They have given us the IP address, and have verified that we are using Advanced Security Option (ASO). They have told us the structure, and so on.

What is the procedure for putting data into that table, and retrieving those data to verify the feasibility of using their DB?

They have told us:

    Our external IP will be 199.nn.nnn.nn1 (the n’s are real #s)
    Connection will be required to use ASO/SSL encryption on TCP:9000

How do I utilize this info?

For connection you can use

strConnection = "Driver={DRIVER NAME};Server=<SERVER_NAME>;Address=199.nn.nnn.nn1; Port=9000;Database=<DATABASENAME>;Uid=myUsername;P wd=myPassword;Integrated Security=SSPI;Persist Security Info=False");

__________________
Vikash Kumar Singh

This will work in code. But if you are using SQL*Plus what would you do?