几款常用mysql,access,mssql数据库连接代码

绍3种adodb连接mysql教程数据库教程的方法
 //------------配置数据库 ----------------
$databank       = 'mysql';
$mydbhost        = "localhost";                //配置主机
$mydbuser        = "root";                       //数据库用户
$mydbpw            = "123456";                //数据库密码
$mydbname        = "bianchen";             //数据库密码
$mydbcharset    = "utf8";

//方法一

$db           = adonewconnection($databank);
$db->debug = false;
$db->connect($mydbhost, $mydbuser, $mydbpw, $mydbname);         //指定adodb使用mysql数据库
$db->execute('set names utf8');

//方法二

$db = newadoconnection($databank);
$db->connect($mydbhost, $mydbuser, $mydbpw, $mydbname);
$db->execute("set names 'utf8'");

//方法三

$db = newadoconnection($databank.'://'.$mydbuser.':'.$mydbpw.'@'.$mydbhost.'/'.$mydbname.'');

str = "dsn=mysql;driver={mysql odbc 3.51 driver};server=127.0.0.1;port=3307;uid=root;pwd=;database=vtigercrm502"   
set conn = server.createobject("adodb.connection")   
conn.open str

<%
set conn = server.createobject("adodb.connection")
conn.connectionstring = "driver={mysql odbc 3.51 driver};"_
& "server=localhost;"_
& " database=gaorui;"_
& "uid=root;pwd=luo; option=3;stmt=set names gbk"
conn.open
sql = "select * from user"
set rs = conn.execute(sql)
%>

<%
set conn = server.createobject("adodb.connection")
conn.open "driver={mysql odbc 3.51 driver};server=127.0.0.1;port=3306;database=gaorui;user=root;password=luo;stmt=set names gbk"
sql = "select * from user"
set rs = conn.execute(sql)
%>