首先当然是SQL server 了，现在SQL server 的市场越来越大了 " function OpenConn(userid,pass,servername) connstring="Provider=SQLOLEDB.1;Password=" & pass & ";Persist Security Info=True;User ID=" & userid &";Data Source=" & servername set conn=server.createobject("ADODB.Connection") conn.open connstring set OpenConn=conn end function "

说到连接数据库，当然不能忘记Oracle "function OpenConn(userid,pass,servername) connstring="Provider=MSDAORA.1;Password=" & pass &";User ID=" & userid & ";Persist Security Info=True" set conn=server.createobject("ADODB.Connection") conn.open connstring set OpenConn=conn end function "

当然还有 Access,ODBC 等等，我就只把 连接字符串放到这里，自己慢慢研究吧

connstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("test.mdb") &";Persist Security Info=False" //ACCESS connstring="Provider=MSDASQL.1;Persist Security Info=False;Data Source=dsn"

MS Access数据库连接

用DSN连接并且没有用户名和密码：

"set conn = Server.CreateObject("ADODB.Connection")conn.open "YourDSNName""

用DSN连接并且有用户名和密码：

"set conn = Server.CreateObject("ADODB.Connection")conn.open "YourDSNName","username","password""

用实际的数据库绝对路径连接：

"Set conn = Server.CreateObject("ADODB.Connection")Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "Strconn=Strconn & "DBQ=e:\yanhang\database.mdb" conn.Open Strconn"

用实际的数据库相对路径连接：

"Set conn = Server.CreateObject("ADODB.Connection")Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "Strconn=Strconn & "DBQ=" & Server.MapPath("/database/yanhang.mdb")conn.Open Strconn"

MS SQL Server数据库连接

用DSN连接：

"set conn = Server.CreateObject("ADODB.Connection")conn.open "DSN=MyDSN;UID=user;PWD=password;
DATABASE=databasename""

不用DSN连接：

"Set conn = Server.CreateObject("ADODB.Connection")DSNtemp="DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;
DATABASE=databasename"conn.open DSNtemp"

FoxPro数据库连接

"Set Conn = Server.CreateObject("ADODB.connection")ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;
SourceDB=C:\yanhang\database.dbc"Conn.Open ConnStr"

Oracle数据库连接：

"set conn=server.createobject("adodb.connection")conn.cursorlocation=adUseClient
DSNTemp="Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang;Data Source=xxx.world"conn.open DSNtemp"