asp如何连接Oracle

mingtiandream 2006-08-17 01:39:04

asp如何连接Oracle

...全文

175 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

jnzsk 2006-09-21

打赏
举报

<%
Set cgsconn=Server.CreateObject("ADODB.Connection")
cgsconn.connectionstring="Provider=OraOLEDB.Oracle.1;Password=004;Persist Security Info=True;User ID=ntc;Data Source=zzc"
cgsconn.open
%>

tete 2006-09-21

打赏
举报

<%
Set cgsconn=Server.CreateObject("ADODB.Connection")
cgsconn.connectionstring="Provider=OraOLEDB.Oracle.1;Password=004;Persist Security Info=True;User ID=ntc;Data Source=zzc"
cgsconn.open
%>
asp不推荐用oracle做后台,oraole的性能不高.还是连sqlserver吧,而且价格便宜!

yangxjn 2006-09-21

打赏
举报

the same to you

kecheng 2006-09-20

打赏
举报

两种都可试试：
conn.asp代码:
<%Set conn=Server.CreateObject("ADODB.Connection")
conn.connectionstring="Driver={Sql Server};Server=(local);UID=sa;password=sa;database=fack"
conn.open
session.timeout=500
%>

conn2.asp代码:
<%
Set cgsconn=Server.CreateObject("ADODB.Connection")
cgsconn.connectionstring="Provider=OraOLEDB.Oracle.1;Password=004;Persist Security Info=True;User ID=ntc;Data Source=zzc"
cgsconn.open
%>