小编整理的常见的几种数据库的连接方式，分享给大家
 1.access数据库的dsn-less连接方法:
set adocon=server.createobject("adodb.connection") adoconn.open"driver={microsoft access driver(*.mdb)};dbq="& _ server.mappath("数据库所在路径")
2.access ole db连接方法：
set adocon=server.createobject("adodb.connection") adocon.open"provider=microsoft.jet.oledb.4.0;"& _ "data source=" & server.mappath("数据库所在路径")
3.sql server连接方法：
set adocon=server.createobject("adodb.recordset") adocon.open"driver={sql server};server=(local);uid=***;pwd=***;"& _ "database=数据库名;"
4.sql server ole db连接方法:
set adocon=server.createobject("adodb.connection") adocon.open"provider=sqloledb.1;data source=ritant4;"& _ "user id=***;password=***;"& _ "inital catalog=数据库名"
5.oracle 连接方法:
set adocon=server.createobject("adodb.connection") adocon.open"driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;"
6.oracle ole db 连接方法:
set adocon=server.createobject("adodb.connection") adocon.open"provider=oraoledb.oracle;data source=dbname;user id=admin;password=pass;"
7.dbase 连接方法:
adocon=server.createobject("adodb.connection") adocon.open"driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=------------;"
8.mysql 连接方法:
set adocon=server.createobject("adodb.connection") adocon.open"driver={mysql};database=yourdatabase; uid=username;pwd=yourpassword;option=16386;"
9.visual foxpro 连接方法:
set adocon=server.createobject("adodb.connection") adocon.open"driver={microsoft visual foxpro driver};sourcetype=dbc;sourcedb=*.dbc;exclusive=no;"
10.ms text 连接方法:
set adocon=server.createobject("adodb.connection") adocon.open"driver={microsoft text driver(*.txt; *.csv)};dbq=-----;"&_ "extensions=asc,csv,tab,txt;persist securityinfo=false;"
11.ms text ole db 连接方法:
set adocon=server.createobject("adodb.connection") adocon.open"provider=microsof.jet.oledb.4.0;data source=your_path;"&_ "extended properties'text;fmt=delimited'"