I wan to make a visual basic appliucation to Connect to Oracle Database 11g production server and get the the query output from it

Question

1.00/5 (2 votes)

See more:

VS2010

Currently in my company i have to follow these steps....

Login to the server using putty client on ssh, using username and password of server.
type "sqlplus" to enter into oracle db.
Run query ex:(select * from f_table where table.p.time > yesterday_date and table.p.time <= today_date;).
Output result save in putty output logs on my pc.

Want i want is this.... I want to build a application in visual basic that connect to server and then database using user/pass of both server(using ssh) and oracle db(using db username/password) and sql query run automatically on DB and return the output into a log file in my pc.

..........

is this possible or how much of this possible...... i have expertise in Visual studio and always prefer visual basic programming......

Thanks in Advance....

Posted 28-Feb-15 1:09am

Member 11487120

Updated 28-Feb-15 2:35am

Sergey Alexandrovich Kryukov

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2015-02-28T06:53:00

Solution 1

Start reading the documentation: Getting Started with Oracle Data Provider for .NET (VB.NET Version) [^]

Posted 28-Feb-15 6:53am

Maciej Los

Comments

Member 11487120 28-Feb-15 14:27pm

this will work if i have database server direct ip...but right now i have to goto some remote server usin ssh by using some username and pass and then type sqlplus and database username and password....and then run some query...