473,404 Members | 2,195 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

Common problem...Connecto to Oracle database

I don't know how to connect to oracle database by asp.net

Anyone have any simple or step for me to connect??
i have no idea.... i have search from google and get the code
But it seen i have miss some step ....

My case is....school have provided the oracle for me to connect
so i need to install oracle client for my pc??
Mar 27 '06 #1
3 1669
Hello,

If you are using Visual Studio 2003:

--> You can use OleDb

for the connection string:
http://www.connectionstrings.com/

Sample:
http://www.csharphelp.com/archives/archive137.html
http://www.c-sharpcorner.com/Database.asp
If you are using 2005, I think there is an Oracle NameSpace (not 100 %
sure about this).

Good Luck
Braulio

--
/// ------------------------------
/// Braulio DÃ*ez Colaborador DNM
///
/// http://www.dotnetmania.com
/// My Site (.net Tips): http://www.bdiez.com
/// ------------------------------


"Budd" wrote:
I don't know how to connect to oracle database by asp.net

Anyone have any simple or step for me to connect??
i have no idea.... i have search from google and get the code
But it seen i have miss some step ....

My case is....school have provided the oracle for me to connect
so i need to install oracle client for my pc??

Mar 27 '06 #2
Yes you do need the Oracle client.

You can use the Oracle Data Provider for .NET (ODP.NET). Using the
OracleConnection class found in Oracle.DataAcess.dll

This might help
http://www.oracle.com/technology/sam...ect/index.html

Mar 27 '06 #3
do i need to oracle clients???

when i test the connection, it show the error that i didn't have oracle
client and compenet
"Braulio Diez" <br**************@yahoo.es> ¼¶¼g©ó¶l¥ó·s»D:F4********************************* *@microsoft.com...
Hello,

If you are using Visual Studio 2003:

--> You can use OleDb

for the connection string:
http://www.connectionstrings.com/

Sample:
http://www.csharphelp.com/archives/archive137.html
http://www.c-sharpcorner.com/Database.asp
If you are using 2005, I think there is an Oracle NameSpace (not 100 %
sure about this).

Good Luck
Braulio

--
/// ------------------------------
/// Braulio Diez Colaborador DNM
///
/// http://www.dotnetmania.com
/// My Site (.net Tips): http://www.bdiez.com
/// ------------------------------


"Budd" wrote:
I don't know how to connect to oracle database by asp.net

Anyone have any simple or step for me to connect??
i have no idea.... i have search from google and get the code
But it seen i have miss some step ....

My case is....school have provided the oracle for me to connect
so i need to install oracle client for my pc??

Mar 27 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: A. Fuentes | last post by:
Fellow Oracle Netters: I have the following problem: Enviroment: Oracle9i/AIX5.2/Veritas vxvm I am trying to create an Oracle database using RAW devices UNDER the Veritas vxvm.(Veritas...
2
by: Cherrish Vaidiyan | last post by:
Hello all, A warm Xmas greetings to all. I have a small problem with starting up the database. Here my strategy. I have installed Oracle 9i R 2 on Red Hat 9. i created two database on this...
1
by: Cherrish Vaidiyan | last post by:
sir, I have a small error in Listener configuration.I have two system with a database in each. I am using Red Hat 9 and Oracle 9i. so i shall anme the database and system. system 1 - node2 ...
0
by: Linesh Gajera | last post by:
Hi, I have unique problem. I have configured RemotingServer running as Console Application and my Remoting object access Oracle database. My remoting object make call to Oracle database and...
8
by: Alfonso Esteban Gonzalez Sencion | last post by:
I am trying to use Access as a front end for extracting information from an Oracle database. I started using linked tables but I am getting a very curious behaviour. When I consult the linked...
1
by: Golan | last post by:
Hi, I have a PRO*C code that may run also on PCs where Oracle is not installed. In this case ofcourse the code that read & write from the database should be ignored. What should I specify in the...
0
by: Daniel Crespo | last post by:
Hi to all, I'm using adodb for accessing mysql and postgres. My problem relies on the mysql access. Sometimes, when I try to execute a query (using ExecTrans method below), I get this error:...
4
by: BookerW | last post by:
I am not sure which forum I should post this on, but here is the problem. I have a front end web application(VB) on asp,net 1.1 framework. Inside of the code, I have the following lines to...
5
by: Michael Rudolph | last post by:
Hi newsgroup, I have an issue with the configuration of a DB2 federated database (WebSphere Information Integrator) in conjunction with the relational wrapper for Oracle on AIX. DB2 seems to not...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.