ASP连接ACCESS
<!-- #include file="adovbs.inc" -->
<%
<%
Set conn=Server.CreateObject("ADODB.Connection")
conn.CommandTimeout = 0
conn.ConnectionTimeout = 0
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPATH("../数据库位置")&";Persist Security Info=False"
conn.open strconn
conn.CommandTimeout = 0
conn.ConnectionTimeout = 0
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPATH("../数据库位置")&";Persist Security Info=False"
conn.open strconn
%>
ASP连接MSSQL
<!-- #include file="adovbs.inc" -->
<%
Set conn=Server.CreateObject("ADODB.Connection")
Dim StrServer,StrUid,StrPwd,StrDbName
StrServer="'数据库服务器名"
StrUid="您的登录帐号"
StrPwd="'您的登录密码"
StrDbName="您的数据库名称 "
strconn="driver={sql server};server="&strserver&";uid="&struid&";pwd="&strpwd&";database="&strdbname&""
conn.open strconn
<%
Set conn=Server.CreateObject("ADODB.Connection")
Dim StrServer,StrUid,StrPwd,StrDbName
StrServer="'数据库服务器名"
StrUid="您的登录帐号"
StrPwd="'您的登录密码"
StrDbName="您的数据库名称 "
strconn="driver={sql server};server="&strserver&";uid="&struid&";pwd="&strpwd&";database="&strdbname&""
conn.open strconn
%>
c#连接MSSQL(也许应该是ADO的另一个写法吧)
workstation id=机器名;packet size=4096;user id=用户名;data source=服务器;persist security info=True;initial catalog=数据库;password=密码