电脑上同时按照2005和2008
现在可以调用2005的库 但是调用不了2008的 请问怎么设置才可以
SqlDatabaseName = "t" 'SQL数据库名
SqlPassword = "102300" 'SQL数据库用户密码
SqlUsername = "sa" 'SQL数据库用户名
SqlLocalName = "127.0.0.1" 'SQL主机IP地址(本地可用“127.0.0.1”或“(local)”,非本机请用真实IP)
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr