Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1336
  • Last Modified:

Connecting to ORACLE with VB.NET 2005 with Terminal Services

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?
0
BobSacks
Asked:
BobSacks
  • 3
  • 2
1 Solution
 
AutoeformsCommented:
here is a link to the  the connection string samples for oracle.

http://www.connectionstrings.com/?carrier=oracle

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

Also here is link to Oracle info

http://www.oracle.com/technology/tech/windows/odpnet/index.html


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.

greg
0
 
BobSacksAuthor Commented:
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!

Thanks!!!
0
 
BobSacksAuthor Commented:
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?
0
 
AutoeformsCommented:
i would believe that is all you should need.

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

greg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now