常用数据库的连接串

Oracle:Provider=OraOLEDB.Oracle;Data Source=mydb;User ID=sinory;Password=sinory
Sybase:Driver={SYBASE ASE ODBC Driver};NLN=Winsock;NA=192.168.0.200,4100;Srvr=sinory;DB=sinory;Uid=sinory;pwd=sinory;

Charset=eucgb;Language=chinese

Informix:Driver={IBM INFORMIX 3.82 32 BIT};Host=192.168.0.200;Server=JXCNDB;Service=8765;Protocol=onsoctcp;Database=sinory;

UID=informix;PWD=informix;CLOC=zh_cn.gb;DLOC=zh_cn.gb

MySql:Driver={MySQL ODBC 3.51 Driver};Server=192.168.0.200;Port=3306;Option=131072;Stmt=;Database=sinory;Uid=it;Pwd=sinory;

Access:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=filepath;JET OLEDB:database password=mypass

Excel:Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =filepath;Extended Properties=Excel 8.0 

SQLServer:Data Source=SINORY\\SQLEXPRESS1;Initial Catalog=StuManager;User ID=sa;pwd=sinory

转载于:https://www.cnblogs.com/hjzhang/archive/2009/12/04/2043591.html