Question

access数据库转换为sql后代码如何修改

<!--#include file="char.inc"-->
<%
starttime=timer()

DbType = "ACCESS" '链接ACCESS数据库

DbType="ACCESS"
DB = "Data/#$#2543wygkga2011sdafdsfaccess.mdb"
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)

On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr

If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错[代码：01]，请检查数据库链接文件中的连接字串。"
Response.End
End If
%>
原accsee代码如上，sql数据库名为baomi

Answer 1

ConnStr = "Provider=SQLOLEDB.1;Password=密码;Persist Security Info=True;User ID=用户名;Initial Catalog=数据库;Data Source=IP地址或域名"

只要变连接字符串，其它不变