468,545 Members | 1,873 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,545 developers. It's quick & easy.

code to connect jsp page to oracle 9i

52
hi,
im new to programming in jsp and i need to connect to oracle db.
i could connect to ms access using the following code

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:cust_pr oj");
st=con.createStatement();
but, i dont know how to connect to oracle.
Please help. also, what seetings to i need to set in control panel for the connection?
Mar 5 '07 #1
2 6419
i also have same problem with oracle 9i connection..

if you get solution to this problem plz reply me

thanks
May 2 '07 #2
fizeau
1
hi
iam working with oracle 10g and asp.net (c#) and i can connect to my oracle data base throw the below code
try it may it work with you :

OracleConnection oraclConn = new OracleConnection(ConfigurationManager.ConnectionSt rings["ConnectionString"].ToString());
OracleDataAdapter oraclDataAdapt = new OracleDataAdapter("select id ,name , description from adressbooktemp where USERID ="+usrId , oraclConn);
DataSet oraDataSet = new DataSet();
oraclDataAdapt.Fill(oraDataSet);
GridView1.DataSource = oraDataSet;
GridView1.DataBind();

if it works with u just tell me :D
May 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by TK | last post: by
2 posts views Thread by Hari Om | last post: by
4 posts views Thread by Ellen K. | last post: by
2 posts views Thread by Booker Washington | last post: by
3 posts views Thread by Greg Strong | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.