ASP - Connecting to Oracle 9i

R

Randy

Hello All,
I'm trying to connect to an Oracle 9i database on a 2000 Pro box using my XP
Pro development machine. I've got Oracle client 9i (and .NET 2003) on my dev
XP box and Oracle 9i client and database on the 2000 box.
I can right click on the oracleDataAdapter and Preview Data and get data
from the table I specified.
However, I'm doing a simple ASP page with a datagrid on it. I've got the
oracleDataAdapter, oracleConnection and a dataSet. In the code (in the
page_load) I do a...

oracleConnection1.Open();
oracleDataAdapter1.Fill(dataSet1);
DataGrid1.DataBind();

Now when I run it and it steps on the oracleConnection1.Open(); line I get
(in the browser) the error...
Exception Details: System.Exception: System.Data.OracleClient requires
Oracle client software version 8.1.7 or greater.

Can someone please tell me what I'm doing wrong?

Thanks
 
R

Randy

I found the problem...
I had to go into the oracle home directory on my dev machine and reset
authenticated users to read and execute. Rebooted and it all works as
expected...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,994
Messages
2,570,223
Members
46,812
Latest member
GracielaWa

Latest Threads

Top