كيف يمكنني ان اقوم بالربط بين asp وبين oracle 9i

هذا هو الكود :

set conn=server.createobject("adodb.connection")
dns="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=system;Password=manager;Data Source=MyOracle"
conn.Open dns

(f)

Using the connection code written by brother Mohamed,here is how to get the names and salaries from the table EMP.This table is under the account scott

<%

set conn=server.createobject("adodb.connection")
dns="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=scott;Password=tiger;Data Source=javadata"
conn.Open dns
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.open "Select*from EMP",conn,3,3

DO WHILE NOT rs.EOF
    Response.Write  rs("ENAME") & " " & rs("SAL") & "
"
    rs.MoveNext
LOOP

rs.close
conn.close
set rs=nothing
set conn=nothing
%>

change data source in the connection string from "javadata" to your host string,in other words your server name

Hope this helps

Madani