Home » RDBMS Server » Networking and Gateways » Steps for Access remote Oracle Db [VB-Oracle-10G] (Oracle 10G)
Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562169] Mon, 30 July 2012 02:42 Go to next message
sawmeonline
Messages: 6
Registered: July 2012
Junior Member
Hello,

I'm using Vb and DB Oracle 10G.

Could you tell me the steps for connect oracle DB through internet.

Thanks,
thenndral
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562171 is a reply to message #562169] Mon, 30 July 2012 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You need an application server like Apache or Oracle application server.
But I don't see the relation between VB and Internet.

Regards
Michel
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562172 is a reply to message #562171] Mon, 30 July 2012 02:56 Go to previous messageGo to next message
sawmeonline
Messages: 6
Registered: July 2012
Junior Member
Hello Michel,

Thanks for your reply.
Actually my requirement, Our Oracle server in one place and the end-user wants to connect my vb application through internet.I don't have an idea about Oracle application server. I need more suggestion.

Thanks again,
thenndral
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562175 is a reply to message #562172] Mon, 30 July 2012 03:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand what you mean by "connect my vb application through internet".
You connect through Internet via a browser not via a VB application.
Can you explain in details your architecture and what you exactly want.

Regards
Michel
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562179 is a reply to message #562175] Mon, 30 July 2012 03:21 Go to previous messageGo to next message
sawmeonline
Messages: 6
Registered: July 2012
Junior Member
Hello Michel,

sorry for poor explanation.

I'm working in a student management system project application using VB with oracle 10G.At present we are using our application within the school[intranet]. this year our school open new branch so our application also use in both main and branch school.[main and branch school is in different location]

I want to connect our student management system application from branch school? I think we can use connection string vb[oracle] to connect. but basically we have to do some settings in main server to connect.
ie. I want to access my remote DB using VB.

I hope explain clearly.

Thanks again,
thenndral.
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562182 is a reply to message #562179] Mon, 30 July 2012 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For Oracle, there is no difference to remotely connect from inside your network or outside it.
The first problem resides to be able to reach the database server from outside your server.
This is more a question of network connectivity, firewall, level of security you want...

What is your current connection string from VB to the database?

Regards
Michel
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562183 is a reply to message #562182] Mon, 30 July 2012 03:53 Go to previous messageGo to next message
sawmeonline
Messages: 6
Registered: July 2012
Junior Member
Thanks for your reply.

my connection string

m_AdoCn.ConnectionString =Provider=MSDAORA.1;Password=sMs1980?**;User ID=thenndral;Data Source=SMSDB

Thanks in advance,
thenndral
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562184 is a reply to message #562183] Mon, 30 July 2012 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So in your remote client, create the same data source, possibly using the IP address instead of the server name (assuming you have neither firewall nor proxy between your private network and the internet).
If you have some firewall to protect you the must use something like Oracle Connection Manager on the firewall to bounce from outside to inside.

Regards
Michel
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562185 is a reply to message #562184] Mon, 30 July 2012 04:32 Go to previous messageGo to next message
sawmeonline
Messages: 6
Registered: July 2012
Junior Member
Well, I create the same datasource.

//If you have some firewall to protect you the must use something like Oracle Connection Manager on the firewall to bounce from outside to inside.// I don't understand this, can please explain more.

Thanks again,
thenndral
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562187 is a reply to message #562185] Mon, 30 July 2012 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A firewall is a server that filters the input coming from outside the local network.
All coming requests can reach the local network only passing through the firewall.
The firewall get the requests and pass them to the appropriate service.

Here are some articles on the subject:
http://it.toolbox.com/wiki/index.php/Connect_Oracle_Behind_a_Firewall
http://www.dbasupport.com/forums/archive/index.php/t-19188.html
http://dbaspot.com/database-discussions/54900-connecting-oracle-through-firewall.html

Regards
Michel
Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562263 is a reply to message #562187] Mon, 30 July 2012 19:00 Go to previous message
sawmeonline
Messages: 6
Registered: July 2012
Junior Member
Hello,

Thanks for the link.
I will try to make it.

Thanks again,
thenndral
Previous Topic: clients connections failed intermittently
Next Topic: How to find all the objects referring to DB Link
Goto Forum:
  


Current Time: Tue Oct 21 15:28:04 CDT 2014

Total time taken to generate the page: 0.29399 seconds