Question

如何修改conn.asp数据库连接

我的字符串我是想把数据库搞成我才恢复的SQL数据库要怎么改请大家帮帮忙
<!--#include file="Config.asp"-->
<!--#include file="const.asp"-->
<%
dim Strconn
Dim Conn,ConnStr,DataServer,DataBase,DataUser,DataPass
DataServer = "192.168.1.101"
DataBase = "dsc050622"
DataUser = "sa"
DataPass = "123456"
ConnStr="Provider=SQLOLEDB.1;User ID="&DataUser&";Password="&DataPass&";Initial Catalog="&DataBase&";Data Source="&DataServer&""
Set Conn=Server.CreateObject("ADODb.Connection")
Conn.ConnectionString=ConnStr
Conn.Open

Answer 1

db="db/com02.mdb" '数据库文件位置这不就是要修改的地方吗，写成自己的数据库的地址

Answer 2

Connstr="driver={SQL Server};server=192.168.1.101;uid=sa;pwd=123456;database=dsc050622"
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open connstr