Solved

Connecting to ORACLE with VB.NET 2005  with Terminal  Services

Posted on 2007-11-15
5
1,325 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
  • 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 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

776 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