我用ASP写的一段程序,连接sql sever数据库SqlLocalName ="(local)"
SqlUsername ="username"
SqlPassword ="password"
SqlDatabaseName="userdb"
ConnStr = "Provider=Sqloledb;User ID=" & SqlUsername & "; Password=" & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source=" & SqlLocalName & ";"On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.open ConnStr以上是连接sql2000时写的,运行正常,现在数据库升级到sql2005,就不能正常访问了,是不是连接写法有变,该怎样修改
SqlUsername ="username"
SqlPassword ="password"
SqlDatabaseName="userdb"
ConnStr = "Provider=Sqloledb;User ID=" & SqlUsername & "; Password=" & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source=" & SqlLocalName & ";"On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.open ConnStr以上是连接sql2000时写的,运行正常,现在数据库升级到sql2005,就不能正常访问了,是不是连接写法有变,该怎样修改
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货