原来可以连接上数据库,昨天出了ORA-12514错误,没有弄好后,我就卸载了oracle,重新装了,就连接不上数据库了,但用pl/sql 、SQL* PLUS可以连接上,就是程序连接不上,,网上找了其他连接方式,,连接不上会报错,,但原来的方式不会报错,也没效果,,一直耗着
系统是2003,,程序是ASP的代码如下:
connstr = "Provider=OraOLEDB.Oracle;Data Source=DATABASE;User ID=SYSTEM;PASSWORD=pwd;Persist Security Info=True"
系统是2003,,程序是ASP的代码如下:
connstr = "Provider=OraOLEDB.Oracle;Data Source=DATABASE;User ID=SYSTEM;PASSWORD=pwd;Persist Security Info=True"
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
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = 指向你的安装目录)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = G:\OraHome_1)
(SID_NAME = orcl)
) )