asp页面连接数据库出错,请求解答
我在Win2000 server上安装了Oracle9i,链接数据库却出错,请高手解答:
我的页面是这样写的:
<%@ Language=VBScript %>
<html>
<head>
<TITLE> New Document </TITLE>
</head>
<body>
test odbc connect:
<br>
<%
dim dbname,g_re,g_cn,sqlstr
dbname = "DRIVER={Microsoft ODBC for Oracle};UID=webcdr;PWD=1234;SERVER=webbill;"
Set g_cn=server.CreateObject ("adodb.connection")
Set g_re=server.CreateObject ("adodb.recordset")
sqlstr="select * from rb_info "
g_cn.open dbname
g_re.open g_cn,sql
%>
<br>
test success!
</body>
</html>
提示错误如下:
test odbc connect:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
/yym.asp,行15
请问我的问题出在什么地方?该如何解答