Connecting to ORACLE with VB.NET 2005  with Terminal  Services

Posted on 2007-11-15
Last Modified: 2010-08-05
I  have a client who wants me to connect to a remote ORACLE database using VB.NET 2005.   I have an  IP and login credentials for the ORACLE server.   I have two questions.   First, I am told that, unlike SQL Server, where I can just use the .NET SQL Provider, I need to use the .NET Oracle Provider PLUS I need to set up the Oracle Client.   I'm a little unclear how to do  that.     Second, my cilent is running Terminal  Services, so  the Oracle client is on the Server, but NOT on the workstations.   If I create a .NET app, do I have to install the EXE on  the server?   What do I need to know in order to make this work?    I'm assuming that once I understand the Oracle Client and the Terminal Server issues, the rest of the code is pretty much like SQL Server - right?
Question by:BobSacks
  • 3
  • 2

Expert Comment

ID: 20292232
here is a link to the  the connection string samples for oracle.

Not sure about the provider but that should be pretty easy to test.

Also here is link to Oracle info

As far as terminal services I don't believe need to do anything special. The system admin for the net work should be able to install your app and it will get run just like it was on a regular machine.  My app was installed in a TS environment and i didn't have a single issue.

hope this helps somewhat.


Author Comment

ID: 20292398
My challenges are many here  ;-)  .   I know  very little about Oracle and the Oracle box is only accessible from the client's intranet, so I cannot do squat unless I'm there.    I also don't have a copy of the Oracle client - and it apparently ain't free - so I'm also dead unless I'm at the cilent site.   My client doesn't know  much about it either - they are simply users of an Oracle app that is maintained at a central statewide location..    I'm shooting in the dark here.   Your info is helpful - and gives me hope that I can figure it out.  Give me a day or two to digest- and let's see what other nuggets I get!


Author Comment

ID: 20292525
Greg -

I followed your links and found something called "Oracle Data Provider for .NET", which it appears that I can download.   If I have this, do I still  need the Oracle client - or is this just Oracle's version of the OLEDB provider that Microsoft provides for Oracle?

Accepted Solution

Autoeforms earned 500 total points
ID: 20292554
i would believe that is all you should need.


Expert Comment

ID: 20292590
i would also ask the client for a pc you can remote into so you can do your testing against there database.


Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now