簡介

我們在使用數據庫的時候，首先需要打開這個數據庫。 我們可以找到集中類型的數據庫，每個都使用不同的連接方式。 下面列舉了一下主要的數據庫的連接字符串 A：使用ODBC方式 1:dBASE連接字符串 strConnection = _T("Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;" "Dbq=c:\\DatabasePath;"); 2:Excel連接字符串 strConnection = _T("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;" bq=C:\\DatabasePath\\DBSpreadSheet.xls;DefaultDir=c:\\databasepath;"); 3：Text連接字符串 strConnection = _T("Driver={Microsoft Text Driver (*.txt; *.csv)};" "Dbq=C:\\DatabasePath\\;Extensions=asc,csv,tab,txt;"); 4:Visual FoxPro連接字符串 strConnection = _T("Driver={Microsoft Visual Foxpro Driver};UID=;" ourceType=DBC;SourceDB=C:\\DatabasePath\\MyDatabase.dbc;Exclusive=No"); strConnection = _T("Driver={Microsoft Visual Foxpro Driver};UID=;" "SourceType=DBF;SourceDB=C:\\DatabasePath\\MyDatabase.dbc;Exclusive=No"); 5：Access連接字符串 strConnection = _T("Driver={Microsoft Access Driver (*.mdb)};" "Dbq=c:\\DatabasePath\\dbaccess.mdb;Uid=;Pwd=;"); 6：:SQL Server連接字符串 strConnection = _T("Driver={SQL Server};Server=MyServerName;" "Trusted_Connection=no;" "Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword;"); 7:Oracle連接字符串 strConnect = _T("Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;" "Uid=MyUsername;Pwd=MyPassword;"); 8：MySQL連接字符串 strConnect = _T("Driver={MySQL ODBC 3.51 Driver};Server=localhost;" "Database=MyDatabase;User=MyUserName;Password=MyPassword;Option=4;"); 9：SyBase連接字符串 strConnect = _T("Driver={Sybase System 10};Srvr=MyServerName;Uid=MyUsername;" "Pwd=myPassword;"); 10：SqlAnyWhere連接字符串 strConnect = _T("ODBC;Driver=Sybase SQL Anywhere 5.0;" "DefaultDir=C:\\DatabasePath\;Dbf=C:\\SqlAnyWhere50\\MyDatabase.db;" "Uid=MyUsername;Pwd=MyPassword;Dsn=\"\";"); B：使用OLE方式 1：SQL Server連接字符串 標準的：strConnect = _T("Provider=sqloledb;Data Source=MyServerName;" "Initial Catalog=MyDatabaseName;" "User Id=MyUsername;Password=MyPassword;"); 2：MySQL 連接字符串 strConnection = _T("Provider=MySQLProv;Data Source=test"); 3：AS400連接字符串 strConnect = _T("Provider=IBMDA400;Data source=myAS400;User Id=myUsername;" "Password=myPassword;"); 4：DB2連接字符串 使用TCPID strConnect = _T("Provider=DB2OLEDB;Network Transport Library=TCPIP;" "Network Address=130.120.110.001;" "Initial Catalog=MyCatalog;Package Collection=MyPackageCollection;" "Default Schema=MySchema;User ID=MyUsername;Password=MyPassword;"); 使用APPC strConnect = _T("Provider=DB2OLEDB;APPC Local LU Alias=MyLocalLUAlias;" "APPC Remote LU Alias=MyRemoteLUAlias;Initial Catalog=MyCatalog;" "Package Collection=MyPackageCollection;Default Schema=MySchema;" "User ID=MyUsername;Password=MyPassword;"); 5:Microsoft Jet連接字符串 標準的：strConnect = _T("Provider=Microsoft.Jet.OLEDB.4.0;" "Data Source=C:\\DatabasePath\\MmDatabase.mdb;" "User Id=admin;Password=;"); 6：使用OLE連接某一個Excel表 strConnect = _T("Provider=Microsoft.Jet.OLEDB.4.0;" "Data Source=C:\\DatabasePath\\DBSpreadSheet.xls;" "Extended Properties=\"\"Excel 8.0;HDR=Yes;\"\";"); 注意 HDR=Yes 是第一行是字段，會自動過濾 7：OLAP連接字符串 strConnect = _T("Provider=MSOLAP;Data Source=MyOLAPServerName;" "Initial Catalog=MyOLAPDatabaseName;"); 8：Oracle連接字符串 trConnect = _T("Provider=MSDAORA;Data Source=MyOracleDB;User Id=myUsername;" "Password=myPassword;"); 8：Data Link Connections字符串 strConnection = _T("File Name=c:\\DataBasePath\\DatabaseName.udl;"); 文章轉至英文網站：http://www.codeproject.com/Articles/2304/ADO-Connection-Strings

本文地址：http://www.xszlo.com/article/2012-12-02/7557.html，轉發請保留這個地址，謝謝

轉載于:https://www.cnblogs.com/xszlo/archive/2013/03/04/2943344.html

總結

以上是生活随笔為你收集整理的ODBC、OLE连接各种数据库的连接字符串的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。