OraFAQ Forum: Networking and Gateways » Steps for Access remote Oracle Db [VB-Oracle-10G]

Home » RDBMS Server » Networking and Gateways » Steps for Access remote Oracle Db [VB-Oracle-10G] (Oracle 10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562169]

Mon, 30 July 2012 02:42

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

Report message to a moderator

Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562171 is a reply to message #562169]

Mon, 30 July 2012 02:46

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562172 is a reply to message #562171]

Mon, 30 July 2012 02:56

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

Report message to a moderator

Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562175 is a reply to message #562172]

Mon, 30 July 2012 03:06

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562179 is a reply to message #562175]

Mon, 30 July 2012 03:21

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.

Report message to a moderator

Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562182 is a reply to message #562179]

Mon, 30 July 2012 03:35

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562183 is a reply to message #562182]

Mon, 30 July 2012 03:53

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

Report message to a moderator

Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562184 is a reply to message #562183]

Mon, 30 July 2012 04:12

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Steps for Access remote Oracle Db [VB-Oracle-10G] [message #562185 is a reply to message #562184]

Mon, 30 July 2012 04:32

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

Report message to a moderator