Connecting to ORACLE with VB.NET 2005 with Terminal Services
Posted on 2007-11-15
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?