主题:[讨论]asp如何远程连接Oracle数据库(本人大四毕业设计急用,谢谢。)
大家好,我的毕业设计是从Oracle上读取数据,我用的是asp语言,由于本人没有接触过Oracle数据库,花了大量时间来连接,就是老出问题 不是没有监听程序就是,没有驱动,这方面不熟,希望大虾帮忙,急急急急急!一下是本人代码:
1.
set conn=server.createobject("adodb.connection")
dns="Driver={Microsoft ODBC for Oracle};UID=jsgzltj;PWD=jsgzltj;server=210.37.40.18"
Conn.open "dns"
set rstobj=server.createobject("adodb.recordset")
set rs=conn.execute("select * from jsgzltj t where xn='2006-2007' and jsxm='梁仲友' and zymc='农学'")
response.write rs(11).value
rs.close
set rs=nothing
conn.close
set conn=nothing
这段代码说我:[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
2.一下这段又说我:ORA-12541: TNS: 无监听程序
set conn=server.createobject("adodb.connection")
Connstr="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;Data Source=210.37.40.18;UID=jsgzltj;PWD=jsgzltj;DataBase=RFITMS"
conn.open connstr
set rstobj=server.createobject("adodb.recordset")
set rs=conn.execute("select * from jsgzltj t where xn='2006-2007' and jsxm='梁仲友' and zymc='农学'")
response.write rs(11).value
rs.close
set rs=nothing
conn.close
set conn=nothing
1.
set conn=server.createobject("adodb.connection")
dns="Driver={Microsoft ODBC for Oracle};UID=jsgzltj;PWD=jsgzltj;server=210.37.40.18"
Conn.open "dns"
set rstobj=server.createobject("adodb.recordset")
set rs=conn.execute("select * from jsgzltj t where xn='2006-2007' and jsxm='梁仲友' and zymc='农学'")
response.write rs(11).value
rs.close
set rs=nothing
conn.close
set conn=nothing
这段代码说我:[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
2.一下这段又说我:ORA-12541: TNS: 无监听程序
set conn=server.createobject("adodb.connection")
Connstr="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;Data Source=210.37.40.18;UID=jsgzltj;PWD=jsgzltj;DataBase=RFITMS"
conn.open connstr
set rstobj=server.createobject("adodb.recordset")
set rs=conn.execute("select * from jsgzltj t where xn='2006-2007' and jsxm='梁仲友' and zymc='农学'")
response.write rs(11).value
rs.close
set rs=nothing
conn.close
set conn=nothing