新手提问.连数据库问题.

chenjun716 2006-09-14 09:43:58

<%
openpara = "driver = {SQL Server};server = 192.168.4.44; uid=sa; pwd=; database = gayz#"
set conn = Server.CreateObject("ADODB.Connection")
conn.open openpara
%>

Microsoft VBScript 编译器错误错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序

Untitled-5.asp，行4 ---->>conn.open openpara

...全文

198 13 打赏收藏转发到动态举报

写回复

用AI写文章

13 条回复

切换为时间正序

请发表友善的回复…

发表回复

chenjun716 2006-09-14

打赏
举报

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<%
openpara = "driver = {SQL Server};Data Source = HP; uid=A; pwd=B; database = GB"
set conn = Server.CreateObject("ADODB.Connection")
conn.open openpara
%>
</body>
</html>

以上的openpara是从C++Builder中的ADO的连接字符串是提出来的.在CB中连接正常.为什么在用ASP在IIS里连不上呢?
提示如下:

Microsoft VBScript 编译器错误错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft JScript 编译错误错误 '800a03ec'

缺少 ';'

/GAYZ/Untitled-4.asp，行12

set conn = Server.CreateObject("ADODB.Connection")
----^

按提示:少End.少;.????????

肯请各位兄弟姐妹帮忙!!

chenjun716 2006-09-14

打赏
举报

ODBC我也设置了

chenjun716 2006-09-14

打赏
举报

Params = "Provider=SQLOLEDB.1"
Params = Params & ";Data Source=" & "192.168.4.44"
Params = Params & ";User ID=" & "sa"
Params = Params & ";Password=" & ""
Params = Params & ";Initial Catalog=" &"gayz"
Set Conn= Server.CreateObject("ADODB.Connection")
Conn.Open Params

试试

Microsoft VBScript 编译器错误错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft JScript 编译错误错误 '800a03ec'

缺少 ';'

/GAYZ/Untitled-1.asp，行16

Set Conn= Server.CreateObject("ADODB.Connection")