asp連接數(shù)據(jù)庫oracle  
1、利用ODBC，性能不是很穩(wěn)定。  
2、利用ADO，有兩個驅(qū)動，一個是microsoft提供的，一個是oracle提供的。各有優(yōu)缺點(diǎn)。  
3、利用oracle專門給asp的驅(qū)動，性能最穩(wěn)定，速度最快。我一直用這個。
<%  
set   Conn=server.CreateObject("adodb.connection")  


'Conn.open   "dsn=mmaximo;uid=user;pwd=pwd"  

Conn.open   "maximo","user","pwd"  

'dns="Driver={Microsoft   ODBC   for   Oracle};UID=user;PWD=pwd;server=10.128.64.7"  
'Conn.open   dns  


'dns="Provider=MSDAORA.1;Password=pwd;User   ID=user;Data   Source=thpmis;Persist   Security   Info=True"  
'dns="Provider=OraOLEDB.Oracle.1;Password=pwd;User   ID=user;Data   Source=thpmis;Persist   Security   Info=True"  
'Conn.open   dns  

'set   OraSession=Server.CreateObject("OracleInprocServer.XOraSession")  
'set   OraDatabase=OraSession.OpenDatabase("maximo","user/pwd",0)  
'set   ors=OraDatabase.CreateDynaset("select   *   from   workorder",0)  
'response.write   "總共有"   &   ors.recordcount   &   "記錄"  


'on   error   resume   next  
'connstr="dsn=mmaximo;uid=user;pwd=pwd"  
'Conn.open   connstr  
%>  

---------------------------------------------------------------  



方法二：Dim objConn,myDSN
If Not IsObject(objConn) Then
Set objConn = Server.CreateObject("ADODB.Connection")
myDSN = "Provider=OraOLEDB.Oracle;Data Source=Oracle_Shanghai;User ID=scott;PASSWORD=tiger;Persist Security Info=True"
objConn.Open myDSN
End If