ADO连接串示例..doc

ADO 连接串示例 本页包括?ODBC DSN / DSN-Less,OLE DB Providers, Remote Data Services (RDS), MS Remote 以及 MS DataShape 的 ADO 连接串示例. 也包括 ADO.NET 对于各 .NET Data Provider?(SQLClient, OLEDB 及 ODBC) 的连接串. 这些连接串示例由Microsoft Visual Basic MVP Carl Prothman 编辑 目录 ODBC DSN 连接 DSN 文件 DSN? ODBC 无 DSN 连接 ODBC Driver for Access ODBC Driver for AS/400 ODBC Driver for dBASE ODBC Driver for Excel ODBC Driver for MySQL ODBC Driver for Oracle ODBC Driver for Paradox ODBC Driver for SQL Server ODBC Driver for Sybase ODBC Driver for Sybase SQL Anywhere ODBC Driver for Text ODBC Driver for Teradata ODBC Driver for Visual FoxPro? OLE DB Data Link 连接 Data Link File (UDL)? OLE DB Data Provider 连接 OLE DB Provider for Active Directory Service OLE DB Provider for AS/400 (from IBM) OLE DB Provider for AS/400 and VSAM (from Microsoft) OLE DB Provider for Commerce Server OLE DB Provider for DB2 OLE DB Provider for DTS Packages OLE DB Provider for Exchange OLD DB Provider for Internet Publishing OLE DB Provider for Index Server OLE DB Provider for Microsoft Jet OLE DB Provider for Microsoft Project OLE DB Provider for ODBC Databases OLE DB Provider for OLAP Services OLE DB Provider for Oracle (from Microsoft) OLE DB Provider for Oracle (from Oracle) OLE DB Provider for Simple Provider OLE DB Provider for SQLBase OLE DB Provider for SQL Server OLE DB Provider for SQL Server 通过 SQLXMLOLEDB OLE DB Provider for Sybase Adaptive Server Anywhere OLE DB Provider for Visual FoxPro?  Remote Data Service (RDS) 连接 RDS 数据控件 - 连接属性 RDS 数据控件 - URL 属性? ADO URL 连接 ADO 记录集? MS Remote Provider 连接 MS Remote - Access (Jet) MS Remote - SQL Server? Data Shape Provider 连接??? MS DataShape - SQL Server? .NET Data Provider 连接 SQL Client .NET Data Provider (System.Data.SqlClient) OLE DB .NET Data Provider (System.Data.OleDb) ODBC .NET Data Provider (System.Data.ODBC) ??  　 ODBC DSN 连接 使用一个 ODBC DSN (数据源名称) 需要两步过程.? 1) 你必须首先通过控制面板中的 ODBC 数据源管理器创建 DSN (在 Windows 2000 中从管理工具菜单中).