Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

ASP.NET & ORACLE

Hi All Experts,

I would like to develop a small webform in ASP.NET using Oracle database. Please give me some examples references and what are the drivers required to access the oracle database in asp.net pages.

Appreciate your help

Thanks
Ravi
0
ravi_raj123
Asked:
ravi_raj123
4 Solutions
 
Helena Markováprogrammer-analystCommented:
I think that you can visit Oracle technet - the registration is free - http://www.oracle.com/technology/tech/dotnet/index.html
0
 
razoCommented:
of course u need to download oracle client on ur webserver and define the tns names
  Dim p As New OleDb.OleDbCommand
            Dim c As New OleDb.OleDbConnection
c.connectionstring=value = "Provider=MSDAORA;Password=pswd;User ID=login;Data Source=datasource"
0
 
ayha1999Commented:
Hi raj123,

pls. visit the following site;

http://www.connectionstrings.com/

hope this helps.

ayha
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ravi_raj123Author Commented:
I have tried as follows

Dim sConnString As String = "Provider=MSDAORA.1;Password=read123;User ID=vectread; Data Source=APMS"
Dim con As OleDbConnection = New OleDbConnection(sConnString)
con.Open()

and I am getting this error....

Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.

I have installed Oracle 9i client. Pls. help
0
 
razoCommented:
make sure u have in the oracle folder a folder named network
if that exists that u have to open it and then choose the administrator folder and then define the tsn names file

if the network folder doesnt exist that u still have missing components
0
 
ravi_raj123Author Commented:
I have Oracle folder and under it I have Ora92 and it goes like this

C:\oracle >>>Ora92 >>> network >>> Admin >>> tnsnames.ora

I have defined the all tsn names and I am able to connect to the oracle database through sql*plus and toad.

In ASP.NET I am getting the above mentioned error.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now