1.使用OleDB方式连接
MSSQL
<add key="db_config" value="Provider=SQLOLEDB;Data Source=服务器IP;Initial Catalog=数据库;User ID=用户名;Password=密码"/>
ACCESS2003
<add key="db_config" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\*.mdb;Persist Security Info=False;Jet OLEDB:Database Password=你的密码"/>
ORACLE(需按照oracle客户端,tnsnames文件中建立连接)
<add key="db_config" value="Provider=OraOLEDB.Oracle;Data Source=tnsnames连接名;user id=用户名;password=密码"/>
OleDbConnection conn = new OleDbConnection(“连接语句”);