set conn=Server.CreateObject("adodb.connection")
connstr="Provider=OraOLEDB.Oracle;Password=2003;" & _
"User ID=2003;Data Source=2003;Persist" & _
"Security Info=False"
conn.open connstr
connstr="Provider=OraOLEDB.Oracle;Password=2003;" & _
"User ID=2003;Data Source=2003;Persist" & _
"Security Info=False"
conn.open connstr
driver_name="Provider=MSDAORA.1;Password=密码;User ID=用户名;Data Source=数据库SID;Persist Security Info=True"
set cn = server.CreateObject("adodb.connection")
cn.open driver_name
set rs=server.CreateObject("adodb.recordset")
sql="select * from 表名 "
rs.open sql,cn,1,1
do while not rs.eof
response.write rs("name")&chr(13)&chr(10)
rs.movenext
loop
string connectionString= "";
connectionString = "Provider=MSDAORA;Data Source=XXX;User ZD=XX;Password=XX"; //Create and open a connection using the connection string adoOleDbConnection = new OleDbConnection(connectionString); //Build a SQL statement to query the datasource
string sqlString = "";
sqlString = "Select * From table where passel='"+Passel+"' order by region,addr"; //Retrieve the data using the SQL statement and existing connection
adoOleDbDataAdapter = new OleDbDataAdapter(sqlString, adoOleDbConnection);
string connOStr="Data Source=服务名;User Id=用户名;Password=密码;Integrated Security=no;" ;
OracleConnection myOracleConnection=new OracleConnection(connOStr);
OracleCommand myOracleCommand=myOracleConnection.CreateCommand();
//OracleCommand loginCom = new OracleCommand("USP_LOGIN",Conn);
myOracleCommand.CommandText="select * from 表";