asp连接oracle报错:“监听进程不能解析在连接描述符中给出的 SERVICE_NAME ”……
如何解决,恳请各位老兄出手帮忙!
源代码:
Set cn = Server.CreateObject("ADODB.Connection")
set rs = server.createObject("adodb.recordset")
cnstr="Provider=MSDAORA.1; Password=sts;User ID=gdykt;Data Source=192.168.0.202;Persist Security Info=True"
sqlstr="select * from T_ZS_XSXX"
rs.open sqlstr,cnstr,1,3
报错:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for Oracle 错误 '80004005'
ORA-12514: TNS:监听进程不能解析在连接描述符中给出的 SERVICE_NAME
/include/conn.asp,行9