Microsoft OLE DB Provider for ODBC Drivers (0x***********)
Microsoft OLE DB Provider for ODBC Drivers (0x***********)
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
SqlDatabaseName = "modernweb"
SqlPassword = "sa"
SqlUsername = "sa"
SqlLocalName = "127.0.0.1"
ConnStr = "Provider = Sqloledb; ;User ID=" & SqlUsername & ";Password =" & SqlPassword & " ;Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStrs
参考答案:Provider = Sqloledb; ;User ID
这儿怎么两个分号
去掉一个