Wrox Programmer Forums
Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 21st, 2007, 02:26 PM
Friend of Wrox
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default Connecting to remote Oracle DB

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?
Old August 21st, 2007, 11:23 PM
Authorized User
Join Date: Jul 2007
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to vksingh24

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
Old August 22nd, 2007, 03:46 PM
Friend of Wrox
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting Remote Oracle through PHP5 phpguru0000 Pro PHP 1 June 23rd, 2006 05:17 AM
connecting web server and remote db server via asp moreyt Classic ASP Databases 0 May 31st, 2005 12:13 AM
Connecting to Oracle without Oracle Client mahaveerar VB Databases Basics 0 February 22nd, 2005 05:18 PM
Connecting to Oracle without Oracle Client mahaveerar Excel VBA 0 February 22nd, 2005 03:55 PM
error while connecting to Oracle DB Lakshmi KS Classic ASP Databases 1 January 21st, 2004 01:21 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.