asp to asp.net connection

[bookouri]

here is the connection im using for my existing asp pages. How can I convert this to asp.net so that it actually works???

<%
dim myconnection
dim rsnamelist
dim sqlstring
dim requestName
set myconnection = nothing
set myconnection = server.createobject("ADODB.connection")
myconnection.open "Provider=OraOLEDB.Oracle;Data Source=mydb;" &_
"User ID=userid;Password=userpwd;"
%>

Seems simple enough, but
I have spent all day trying to use online examples and i can NOT get any of them to work at all. I give up..

I can connect all day using sqldatasource controls in things like Web Expressions or Visual Studio so my web server can connect to my oracle database... but im trying to figure out how to make my connection in code...

 

[jmeckley]

ado.net objects. IDbConnection/Command/Parameter/Transaction etc.

I have an FAQ on the subject. the link is in my signature.

Jason Meckley
Programmer

faq855-7190
faq732-7259

 

[bookouri]

thanks, ill take a look at that.