Asp下单到oracle数据库,asp连接数据库oracle

asp连接数据库oracle

1、利用ODBC，性能不是很稳定。

2、利用ADO，有两个驱动，一个是microsoft提供的，一个是oracle提供的。各有优缺点。

3、利用oracle专门给asp的驱动，性能最稳定，速度最快。我一直用这个。

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

赞同