这段ASP代码连不上数据库,报错说什么OJDBC不支持什么属性 很急 帮帮我
<%MM_conn_STRING = "Driver={SQL Server};server=(local);uid=sa;pwd=sa;database=student;"
Set conn = Server.Createobject("ADODB.Connection")
conn.open MM_conn_STRING
exec="select * from TABLE"
set rs=server.createobject("adodb.recordset")
Rs.open exec,conn,1,1
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%do while not rs.eof%> <tr>
<td> <%=rs("name")%> </td>
<td> <%=rs("tel")%> </td>
<td> <%=rs("message")%> </td>
<td> <%=rs("time")%> </td>
</tr> <%
rs.movenext
loop
%>
</table> --------------------编程问答--------------------
--------------------编程问答-------------------- 能不能详细说说咱俩的有什么不同??? --------------------编程问答-------------------- 微软集成的数据库访问方式 --------------------编程问答-------------------- ODBC:
MM_conn_STRING = "Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=student;User Id=sa;Password=sa;"
MM_conn_STRING = "Driver={SQL Server};server=(local);uid=sa;pwd=sa;database=student;"
OLEDB:
MM_conn_STRING = "Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=student;User Id=sa;Password=sa;"
其实本质都是ODBC
补充:.NET技术 , ASP.NET