Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connecting to ORACLE with VB.NET 2005  with Terminal  Services

Posted on 2007-11-15
5
Medium Priority
?
1,332 Views
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?
0
Comment
Question by:BobSacks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:Autoeforms
ID: 20292232
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
 

Author Comment

by:BobSacks
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!

Thanks!!!
0
 

Author Comment

by:BobSacks
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?
0
 
LVL 8

Accepted Solution

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

greg
0
 
LVL 8

Expert Comment

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

greg
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.

670 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