-
May 25th, 2002, 01:23 PM
#1
oracle connection
Hi,
Can anyone tell me how can I connect orace database through ASP.NET and C#. I mean I am using c# code in asp.net and want to connect to oracle.
Please help what libraries should I use and how?
Fawaz
-
May 31st, 2002, 06:34 AM
#2
Connecting to oracle
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.OleDb" %>
<script runat="server">
OleDbConnection cn=new OleDbConnection("
PROVIDER=MSDAORA.1;user id=scott;password=tiger;
data source=oracle");
cn.Open();
OleDbDataReader dr=new OleDbDataReader("
select * from emp", cn);
</script>
********
In connection string
User ID : Ur oracle data base user id.
Password : Ur oracle data base Password.
data source : this should be set in server system's oranames.ini file.
-
May 31st, 2002, 06:45 AM
#3
Code:
<%@ Page Language="C#" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.OleDb" %>
<script runat="server">
OleDbConnection cn=new OleDbConnection("PROVIDER=
MSDAORA.1;user id=scott;password=tiger;data source=
oracle");
cn.Open();
OleDbDataReader dr=new OleDbDataReader("
select * from emp", cn);
</script>
In connection string
User ID : Ur oracle data base user id.
Password : Ur oracle data base Password.
data source : this should be set in server system's oranames.ini file.
-
May 31st, 2002, 06:47 AM
#4
Code:
<%@ Page Language="C#" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.OleDb" %>
<script runat="server">
OleDbConnection cn=new OleDbConnection("PROVIDER=
MSDAORA.1;user id=scott;password=tiger;data source=
oracle");
cn.Open();
OleDbDataReader dr=new OleDbDataReader("
select * from emp", cn);
</script>
In connection string
User ID : Ur oracle data base user id.
Password : Ur oracle data base Password.
data source : this should be set in server system's oranames.ini file.
-
May 31st, 2002, 06:58 AM
#5
Code:
<%@ Page Language="C#" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.OleDb" %>
<script runat="server">
OleDbConnection cn=new OleDbConnection("PROVIDER=
MSDAORA.1;user id=scott;password=tiger;data source=
oracle");
cn.Open();
OleDbDataReader dr=new OleDbDataReader("
select * from emp", cn);
</script>
In connection string
User ID : Ur oracle data base user id.
Password : Ur oracle data base Password.
data source : this should be set in server system's oranames.ini file.
-
May 31st, 2002, 07:03 AM
#6
namespace:
System
System.Data
System.OleDb
OleDbConnection cn=new OleDbConnection("
PROVIDER=MSDAORA.1;user id=scott;password=
tiger;data source=oracle");
-
June 4th, 2002, 06:38 AM
#7
hi,
if you want to use a more direct way to access oracle, have a look at http://www.crlab.com/products.html
they provide access via the oci...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|