今天有位朋友问到了,关于conn.asp文件内容,这里我作统一整理说明。一直以来主要写asp与php,所以这里只作这两种写法总结,
常用的各类库连接文件写法。
ASP:
by:zhoz http://log.zhoz.com/
ASP来说,首先当然是SQL server了,注意这里我作成了类方法,如果不想用方法,就直接去掉function和end function,把变量写进去。下同。
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
%>
用DSN连接:
set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename"
%>
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
用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
%>
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
%>
dBase 连接方法:
set adocon=Server.Createobject("adodb.connection")
adocon.open"Driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=------------;"
%>
mySQL 连接方法:
set adocon=Server.Createobject("adodb.connection")
adocon.open"Driver={mysql};database=yourdatabase;
uid=username;pwd=yourpassword;option=16386;"
%>
PHP:
by:zhoz http://log.zhoz.com/
最经典组合首选mysql了!连接也比较简单。
$conn = mysql_connect("localhost","root","password") or die("无法连接数据库");
mysql_select_db("table" ,$conn) or die ("找不到数据源");
?>
PostgreSQL也比较常用。
// 连接,选择数据库
$dbconn = pg_connect("host=localhost dbname=publishing user=www password=foo")
or die('Could not connect: ' . pg_last_error());
?>
OrcaleWindows 用户需要至少 Oracle 8.1 版才能使用 php_oci8.dll。
$conn = oci_connect('hr', 'hr', 'orcl');
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
?>
Access
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("data/db.mdb");
$conn->Open($connstr);
?>
差不多就这些了,其它的嘿嘿我也没用过了。以后用到了,再补充吧。