Image of cartoon people walking around in different directions.

We help IT Professionals succeed at work.

Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy

Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif

Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster

CTP, Sr Infrastructure Consultant

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting

Research

Professional Opinions

Ask a Question

Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

oracle 8i with vs 2005

Alfredo Luis Torres Serrano asked on 3/12/2009

Oracle Database .NET Programming Enterprise Software

7 Comments1 Solution847 ViewsLast Modified: 12/19/2013

Hi esperts,

I had been trying many differents ways with this:

I have Visual Studio 2003,2005 And 2008.
I work at Visual Basic, In the company they have a Remote server with Oracle 8i.
I have downloaded and installed Oracle for .Net providers 9,10g and 11g without any solutions.

What i need is nomatter how is to connect Visual Studio to open a databse throu an SQL query in oracle to obtain a recordset in a datareader or to execute a SQL without any return.

Any help or onyone experienced on this issue.

The points will be assigned once the conneciton is made.
Thanks in advance for your help

Something like this:
 
        Dim oradb As String = "Data Source=Server IP ;User Id=MyId;Password=MyPassword;"
        Dim con As New Oracle.DataAccess.Client.OracleConnection
        con.ConnectionString = oradb
        con.Open()