UC知道我在做sql数据库连接的时候,总是有这个错误
来源：百度知道 编辑：UC知道 时间：2024/07/04 02:44:50
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '2003070505' 附近有语法错误。
/elve/数据库连接/display-sql1.asp, 第 8 行
我的ASP程序是:
<%@language="vbscript"%>
<%
set conn=server.createobject("adodb.connection")
conn.open "dsn=sql_2003070505;uid=sa;pwd=elvenight"
commandtext="select * from 2003070505"
set rs=conn.execute(commandtext,recordsaffected,adcmdtet)
response.write"<center><font size=6 color=Green><b>"&"2003级电子商务5班学生信息查询"&"</b></font></center>"
response.write"<center>"
response.write"<table border=10>"
response.write"<tr>"
for i=0 to rs.fields.count-1
response.write("<td>"&rs(i).name&"</td>")
next
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '2003070505' 附近有语法错误。
/elve/数据库连接/display-sql1.asp, 第 8 行
我的ASP程序是:
<%@language="vbscript"%>
<%
set conn=server.createobject("adodb.connection")
conn.open "dsn=sql_2003070505;uid=sa;pwd=elvenight"
commandtext="select * from 2003070505"
set rs=conn.execute(commandtext,recordsaffected,adcmdtet)
response.write"<center><font size=6 color=Green><b>"&"2003级电子商务5班学生信息查询"&"</b></font></center>"
response.write"<center>"
response.write"<table border=10>"
response.write"<tr>"
for i=0 to rs.fields.count-1
response.write("<td>"&rs(i).name&"</td>")
next
你试一试
<%@language="vbscript"%>
<%
'------------------------------------------------------------
SQLServerName = "127.0.0.1" '服务器名称或地址
SQLDBUserName = "sa" '数据库帐号
SQLDBPassword = "elvenight" '数据库密码
SQLDBName = "sql_2003070505" '数据库名称
'数据库连接
On Error Resume Next '容错声明
response.buffer=true
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open"Provider=sqloledb;user id="&SQLDBUserName&";password="&SQLDBPassword&";initial catalog="&SQLDBName&";data source="&SQLServerName&";"
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错，请检查连接字串。"
Response.End
End If
%>
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from 2003070