Question

ASP global文件数据库配置。

Application("DB_ConnectionString")="Provider = ; Persist Security Info = True;User ID = sa; Password =123456)!; Initial Catalog = hrdb; Data Source =localhost:80"
Application("KM_Product_ConnectionString")="Provider = ; Persist Security Info = True;User ID = sa; Password =123456)!; Initial Catalog = hrdb; Data Source =localhost:80"

我的数据库名是MOLLY-PC 表明是：hrdb 用户名：sa 密码：123456 IIS（端口80）和sql2000 都装在本地。可是我不管怎么配置都是提示连不上库

请高人帮忙配置

Answer 1

'sql数据库连接参数：数据库名(SqlDatabaseName)、用户密码(SqlPassword)、用户名(SqlUsername)、
'连接名(SqlLocalName)（本地用local，外地用IP），80端口是默认的，可以不用写
Const SqlDatabaseName = "MOLLY-PC"
Const SqlPassword = "sa"
Const SqlUsername = "123456"
Const SqlLocalName = "(local)"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"

另外补充一下，数据库名字最好不要用中横线，如果上边的还不行的话，可以把数据库名改成 MollyPc看看效果

Answer 2

为了新手任务