28,391
社区成员
发帖
与我相关
我的任务
分享oracle数据库和asp程序不在同一服务器上，怎么写连接代码？急！！
<%
'连接数据库
set orasession=createobject("OracleInprocServer.XOraSession")
set oradatabase=orasession.dbopendatabase("10.187.16.52|orcl","system/manager",0)
%>
'连接数据库
set orasession=createobject("OracleInprocServer.XOraSession")
set oradatabase=orasession.dbopendatabase("10.187.16.52|orcl","system/manager",0)
%>
...全文
请发表友善的回复…
发表回复
wjh6of6agriculture 2003-08-24
- 打赏
- 举报
ConnString="Driver={Oracle ODBC Driver};Server=数据库服务器名;Uid=ADMIN;Pwd=ok"
kmpanda 2003-08-24
- 打赏
- 举报
dim objconnection
dim objrecordset
dim varsql
set objconnection = server.createobject ("adodb.connection")
with objconnection
.connectionstring= "provider=MSDAORA;data source=数据库连接字府串;user id=用户名;password=密码;"
.open
end with
varsql="select * from al where (f_type='新闻报道' and f_pass=1 and f_locate=1) order by f_id desc" set objrecordset=objconnection.execute(varsql)
dim objrecordset
dim varsql
set objconnection = server.createobject ("adodb.connection")
with objconnection
.connectionstring= "provider=MSDAORA;data source=数据库连接字府串;user id=用户名;password=密码;"
.open
end with
varsql="select * from al where (f_type='新闻报道' and f_pass=1 and f_locate=1) order by f_id desc" set objrecordset=objconnection.execute(varsql)
771122 2003-08-24
- 打赏
- 举报
不对呀！
xuya 2003-08-24
- 打赏
- 举报
set oradatabase=orasession.dbopendatabase("10.187.16.52","system/manager",0)
