Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > Problem connecting to Oracle database

Reply
Thread Tools

Problem connecting to Oracle database

 
 
Jaime Stuardo
Guest
Posts: n/a
 
      10-19-2005
Hi all...

I have an ASP.NET application where I placed a DataSource control connected
to an Oracle 7.3.4 database using MSDAORA provider.

When I configured the connection string I chose Oracle Database as the data
source and .NET Framework Data Provider for OLEDB as the data provider.

In the connnection string configuration wizard, I can use a query to test
the results and also I could see the connection in Server Explorer tab. I can
see the database tables, views and stored procedures. All that means that I
have a good connection to Oracle.

On the other hand, I placed a Data Grid control in the page, configured to
use the data source control already created. The grid refreshes columns
according to the query I entered in the connection string wizard.

When I run the application, I get the error telling that Oracle client
components weren't found and that I must install Oracle client 7.3.3 or
above. I tried using Oracle provider in connection string but it produces the
same error but concerning Oracle 8 and above.

The fact is that I have Oracle 9i client installed in my machine. I can use
tools such TOAD to query the database, and even, as I told, when I configure
the connection string in Visual Studio I can use queries to see the results.

I use ASP.NET 2.0 and Visual Studio 2005.

Thanks a lot in advance
Jaime

What may be happening?

Thanks a lot in advance,
Jaime
 
Reply With Quote
 
 
 
 
Jaime Stuardo
Guest
Posts: n/a
 
      10-19-2005
I have solved it. It was finally a security problem for the Oracle home folder.

Thanks anyway
Jaime

"Jaime Stuardo" wrote:

> Hi all...
>
> I have an ASP.NET application where I placed a DataSource control connected
> to an Oracle 7.3.4 database using MSDAORA provider.
>
> When I configured the connection string I chose Oracle Database as the data
> source and .NET Framework Data Provider for OLEDB as the data provider.
>
> In the connnection string configuration wizard, I can use a query to test
> the results and also I could see the connection in Server Explorer tab. I can
> see the database tables, views and stored procedures. All that means that I
> have a good connection to Oracle.
>
> On the other hand, I placed a Data Grid control in the page, configured to
> use the data source control already created. The grid refreshes columns
> according to the query I entered in the connection string wizard.
>
> When I run the application, I get the error telling that Oracle client
> components weren't found and that I must install Oracle client 7.3.3 or
> above. I tried using Oracle provider in connection string but it produces the
> same error but concerning Oracle 8 and above.
>
> The fact is that I have Oracle 9i client installed in my machine. I can use
> tools such TOAD to query the database, and even, as I told, when I configure
> the connection string in Visual Studio I can use queries to see the results.
>
> I use ASP.NET 2.0 and Visual Studio 2005.
>
> Thanks a lot in advance
> Jaime
>
> What may be happening?
>
> Thanks a lot in advance,
> Jaime

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem connecting to a oracle database akki ASP .Net 0 10-13-2006 09:02 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
problem connecting to oracle database markusjais@yahoo.de Python 1 03-05-2004 05:46 PM
Re: Error Connecting to Oracle after an Oracle shutdown David Rudder Java 0 07-30-2003 01:22 PM
Re: Error Connecting to Oracle after an Oracle shutdown Juha Laiho Java 0 07-30-2003 10:22 AM



Advertisments