这么晚了,麻烦在的大哥大姐帮忙,急用asp+odbc+oracle???

patch 2002-08-26 11:58:10

asp和oracle位于两台服务器上
在asp所在机器上配置odbc数据源,如何设置其中的oracle服务器地址
是只用oracle所在机器的ip即可,还是需要别的??

...全文

130 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

patch 2002-08-27

打赏
举报

能用中文给描述以下吗??

saucer 2002-08-27

打赏
举报

on your web server , use the Oracle's Net Configuration Assistant to create a Local Net Service Name for your remote Oracle server, then use ODBC Administrator to create a system DSN

shadowkiss 2002-08-27

打赏
举报

要在asp的那台服务器上装好oracle的客户端，并配好 SQL NET easy configuration

shadowkiss 2002-08-27

打赏
举报

oracle 建议你用 oracle 自带的OLE对象来连接，

可以达到asp连接oracle数据库最高的效率

方法举例:

set orasession=createobject("oracleinprocserver.xorasession")
set oradatabase=orasession.dbopendatabase("pa1003","pafman/pafman",0)
'注意: 数据库在此打开!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1
sql = "select clink,ctitle,cdest,cdptcde,to_char(ddate,'mm-dd HH24:mi') ddate1,ddate from kdptinfo where cdest<>'经理信息' and cdest<>'新闻栏' and cdest<>'群马笑秋风' and cdest<>'群马业绩通报' order by ddate desc"
set oradynaset = oradatabase.dbcreatedynaset(sql,0)
if oradynaset.recordcount > 0 then
j=0
do until oradynaset.eof
response.write "<table>"
response.write "<font color='#FF9966'>◇ </font>"
if oradynaset.fields("cdest")="部门主页" then
response.write "<a href=bmzy\" & oradynaset.fields("clink") & " target=_blank>"
else
response.write "<a href=" & oradynaset.fields("clink") & " target=_blank>"
end if
if oradynaset.fields("ddate")>=Date then
response.write "<font color='#FF0000'>"
end if
response.write oradynaset.fields("ctitle")
if oradynaset.fields("ddate")>=Date then
response.write "</font>"
end if
response.write "</a>"
response.write " (" & oradynaset.fields("cdptcde") & " " & oradynaset.fields("ddate1") & ")"
response.write "</table>"
j=j+1
if j>=12 then
exit do
end if
oradynaset.movenext
loop
end if
'注意：数据库还未关闭!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
oradynaset.close'先把数据集关闭
set oradynaset=nothing

'关闭数据库
oradatabase.close
set oradatabase=nothing
set orasession=nothing