Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Connecting to ORACLE with VB.NET 2005  with Terminal  Services

Posted on 2007-11-15
5
Medium Priority
?
1,333 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 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

972 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