// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- Standard Connection 
         

using System.Data.Odbc;
           
            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Driver={SQL Server};" + 

                          "Server= color="red">ServerName;" + 

                          "DataBase= color="red">DataBaseName;" +
            

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
          
           

// ODBC -- Trusted Connection 
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Driver={SQL Server};" + 

                          "Server= color="red">ServerName;" + 

                          "DataBase= color="red">DataBaseName;" +
            

                          "Uid=;" + 

                          "Pwd=;"; 

            conn.Open();
            

             // or

            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Driver={SQL Server};" + 

                          "Server= color="red">ServerName;" + 

                          "DataBase= color="red">DataBaseName;" +
            

                          "Trusted_Connection=Yes;"; 

            conn.Open();
            

           

// OleDb -- Standard Connection 
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=SQLOLEDB;" + 

                          "Data Source= color="red">ServerName;" +
            

                          "Initial Catalog= color="red">DataBaseName;" 
            + 

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// OleDb -- Trusted Connection 
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=SQLOLEDB;" + 

                          "Data Source= color="red">ServerName;" +
            

                          "Initial Catalog= color="red">DataBaseName;" 
            + 

                          "Integrated Security=SSPI;"; 

            conn.Open();
            

           

// OleDb -- via IP Address 
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=SQLOLEDB;" + 

                          "Network Library=DBMSSOCN;" + 

                          "Data Source= color="red">xxx.xxx.xxx.xxx,1433;" 
            + 

                          "Initial Catalog= color="red">DataBaseName;" 
            + 

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// .NET DataProvider -- Standard 
          Connection

using System.Data.SqlClient;
            

            SqlConnection conn = new 
            SqlDbConnection();
            conn.ConnectionString = 

                          "Data Source= color="red">ServerName;" +
            

                          "Initial Catalog= color="red">DataBaseName;" 
            + 

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// .NET DataProvider -- Trusted 
          Connection

using System.Data.SqlClient;
            

            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = 

                          "Data Source= color="red">ServerName;" +
            

                          "Initial Catalog= color="red">DataBaseName;" 
            + 

                          "Integrated Security=SSPI;"; 

            conn.Open();
            

           

// .NET DataProvider -- via IP Address
         

using System.Data.SqlClient;
            

            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = 

                          "Network Library=DBMSSOCN;" + 

                          "Data Source= color="red">xxx.xxx.xxx.xxx,1433;" 
            + 

                          "Initial Catalog= color="red">DataBaseName;" 
            + 

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = "Dsn= color="red">DsnName";
            conn.Open();
            

           

// ODBC -- Standard Security 
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                "Driver={Microsoft Access Driver (*.mdb)};" + 

                "Dbq= color="red">c:\myPath\myDb.mdb;" + 

                "Uid=Admin;Pwd=;"; 

            conn.Open();
            

           

// ODBC -- Workgroup (System Database)
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                "Driver={Microsoft Access Driver (*.mdb)};" + 

                "Dbq= color="red">c:\myPath\myDb.mdb;" + 

                "SystemDb= color="red">c:\myPath\myDb.mdw;"; 

            conn.Open();
            

           

// ODBC -- Exclusive Use

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                 "Driver={Microsoft Access Driver (*.mdb)};" + 

                 "Dbq= color="red">c:\myPath\myDb.mdb;" + 

                 "Exclusive=1;"; 

                 "Uid=Admin;Pwd=;"; 

            conn.Open();
            

           

// OleDb with MS Jet -- Standard 
          Security

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                       "Provider= color="red">Microsoft.Jet.OLEDB.4.0;" 
            + 

                       "Data Source= color="red">c:\mypath\myDb.mdb;" 
            + 

                       "User id=admin;" + 

                       "Password=";
            conn.Open();
            

           

// OleDb with MS Jet -- Workgroup 
          (System Database)

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                       "Provider= color="red">Microsoft.Jet.OLEDB.4.0;" 
            + 

                       "Data Source= color="red">c:\mypath\myDb.mdb;" 
            + 

                       "System Database= color="red">c:\mypath\myDb.mdw;";
            

            conn.Open();
            

           

// OleDb with MS Jet -- With Password
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                       "Provider= color="red">Microsoft.Jet.OLEDB.4.0;" 
            + 

                       "Data Source= color="red">c:\mypath\myDb.mdb;" 
            + 

                       "Database Password= color="red">Secret;"
            conn.Open();
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- New Microsoft Driver 
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                       "Driver={Microsoft ODBC for Oracle};" + 

                       "Server= color="red">OracleServer.world;" +
            

                       "Uid= color="red">UserName;" + 

                       "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- Old Microsoft Driver 
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                "Driver={Microsoft ODBC Driver for Oracle};" + 

                "ConnectString= color="red">OracleServer.world;" +
            

                "Uid= color="red">UserName;" + 

                "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- Oracle Driver

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                "Driver={Oracle ODBC Driver};" + 

                "Dbq= color="red">myDataBase;" +  
            // define in tsnames.ora

                "Uid= color="red">UserName;" + 

                "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// OleDb -- Microsoft Driver 
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=MSDAORA;" + 

                          "Data Source= color="red">ServerName;" +
            

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// OleDb -- Oracle Driver -- Standard 
          Connection

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=OraOLEDB.Oracle;" + 

                          "Data Source= color="red">ServerName;" +
            

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// OleDb -- Oracle Driver -- Trusted 
          Connection

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=OraOLEDB.Oracle;" + 

                          "Data Source= color="red">ServerName;" +
            

                          "OSAuthent=1;";
            conn.Open();
            

             // or 

            

            using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=OraOLEDB.Oracle;" + 

                          "Data Source= color="red">ServerName;" +
            

                          "User id=/" + 

                          "Password=;"; 

            conn.Open();
            

           

// .NET DataProvider from Microsoft 

          // -- Standard Connection 

         

using System.Data.OracleClient;
            

            OracleConnection conn = new 
            OracleConnection();
            conn.ConnectionString = 

                          "Data Source= color="red">ServerName;" +
            

                          "User id= color="red">UserName;"; 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// .NET DataProvider from Microsoft 

          // -- Trusted Connection 

         

using System.Data.OracleClient;
            

            OracleConnection conn = new 
            OracleConnection();
            conn.ConnectionString = 

                          "Data Source= color="red">Servername;" +
            

                          "Integrated Security=Yes;"; 

            conn.Open();
            

           

// .NET DataProvider from Oracle 

          // -- Standard Connection 

         

using Oracle.DataAccess.Client;
            

            OracleConnection conn = new 
            OracleConnection();
            conn.ConnectionString = 

                          "Data Source= color="red">ServerName;" +
            

                          "User id= color="red">UserName;"; 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// .NET DataProvider from Oracle 

          // -- Trusted Connection 

         

using Oracle.DataAccess.Client;
            

            OracleConnection conn = new 
            OracleConnection();
            conn.ConnectionString = 

                          "Data Source= color="red">Servername;" +
            

                          "Integrated Security=Yes;"; 

            conn.Open();
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC without DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Driver={IBM DB2 ODBC DRIVER};" + 

                          "DataBase= color="red">DataBaseName;" +
            

                          "HostName= color="red">ServerName;" + 

                          "Protocol= color="red">TCPIP;" + 

                          "Port= color="red">PortNumber;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// OleDb -- Microsoft Driver 
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                       "Driver=DB2OLEDB;" + 

                       "Network Transport Library= color="red">TCPIP;" 
            + 

                       "Network Address= color="red">xxx.xxx.xxx.xxx;" 
            + 

                       "Package Collection= color="red">CollectionName;" 
            + 

                       "Initial Catalog= color="red">DataBaseName;" 
            + 

                       "User id= color="red">UserName;" + 

                       "Password= color="red">Secret;"; 

            conn.Open();
            

           

// OleDb -- IBM Driver

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                        "Driver=IBMDADB2;" + 

                        "DataBase= color="red">DataBaseName;" + 

                        "HostName= color="red">ServerName;" + 

                        "Protocol= color="red">TCPIP;" + 

                        "Port= color="red">PortNumber;" + 

                        "Uid= color="red">UserName;" + 

                        "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// .NET DataProvider from IBM 

         

using IBM.Data.DB2;
            

            Db2Connection conn = new Db2Connection();
            conn.ConnectionString = 

                          "DataBase= color="red">DataBaseName;" +
            

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;" + 

            conn.Open();
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- MyODBC Driver -- local 
          database

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                        "Driver={MySql};" + 

                        "Server=localhost;" + 

                        "Option=16834;" + 

                        "DataBase= color="red">DataBaseName;" 

            conn.Open();
            

           

// ODBC -- MyODBC Driver -- remote 
          database

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                        "Driver={MySql};" + 

                        "Server= color="red">db.domain.com;" + 

                        "Option=131072;" + 

                        "Port=3306;" + 

                        "Stmt=;" + 

                        "DataBase= color="red">DataBaseName;" + 

                        "Uid= color="red">UserName;" + 

                        "Pwd= color="red">Secret;" 

            conn.Open();
            

           

// ODBC -- MySQL ODBC 3.51 Driver 
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                 "Driver={MySql ODBC 3.51 Driver};" + 

                 "Server= color="red">ServerName;" + 

                 "Option=16834;" + 

                 "Port=3306;" + 

                 "Stmt=;" + 

                 "DataBase= color="red">DataBaseName;" + 

                 "Uid= color="red">UserName;" + 

                 "Pwd= color="red">Secret;" 

            conn.Open();
            

             // or 

            

            using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                 "DRIVER={MySql ODBC 3.51 Driver};" + 

                 "SERVER= color="red">ServerName;" + 

                 "DATABASE= color="red">DataBaseName;" + 

                 "USER= color="red">UrerName;" + 

                 "PASSWORD= color="red">Secret;" 

            conn.Open();
            

           

// OleDb

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                        "Provider=MySqlProv;" + 

                        "Data Source= color="red">ServerName;" + 

                        "User id= color="red">UserName;" + 

                        "Password= color="red">Secret;" 

            conn.Open();
            

           

// .NET DataProvider from CoreLab 

         

using CoreLab.MySql;
            

            MySqlConnection conn = new MySqlConnection();
            conn.ConnectionString = 

                          "Host= color="red">ServerName;" + 

                          "DataBase= color="red">DataBaseName;" +
            

                          "Protocol= color="red">TCP;" + 

                          "Port= color="red">3306;" + 

                          "Direct= color="red">true;" + 

                          "Compress= color="red">false;" + 

                          "Pooling= color="red">true;" + 

                          "Min Pool Size= color="red">0;" + 

                          "Max Pool Size= color="red">100;" + 

                          "Connection Lifetime= color="red">0;" +
            

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;" + 

            conn.Open();
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- Sybase System 12 (12.5) ODBC 
          Driver

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Driver={SYBASE ASE ODBC Driver};" + 

                          "Srvr= color="red">ServerName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- Sybase System 11 ODBC Driver
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                       "Driver={SYBASE SYSTEM 11};" + 

                       "Srvr= color="red">ServerName;" + 

                       "Uid= color="red">UserName;" + 

                       "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- Intersolv 3.10 ODBC Driver
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                    "Driver={INTERSOLV 3.10 32-BIT Sybase};" + 

                    "Srvr= color="red">ServerName;" + 

                    "Uid= color="red">UserName;" + 

                    "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- SQL Anywhere

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                     "ODBC;" + 

                     "Driver={Sybase SQL Anywhere 5.0};" + 

                     "DefaultDir= color="red">c:\myfolder\;" + 

                     "Dbf= color="red">c:\mypath\dbname.db;" + 

                     "Uid= color="red">UserName;" + 

                     "Pwd= color="red">Secret;" + 

                     "Dsn="""";";      // Must be included!

            conn.Open();
            

           

// OleDb -- Sybase Adaptive Server 
          Enterprise (ASE)

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=Sybase.ASEOLEDBProvider;" + 

                          "Server Name= color="red">ServerName,5000;" 
            + 

                          "Initial Catalog= color="red">DataBaseName;" 
            + 

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

             // optionally, replace 

            // 'Server Name' with 'Srvr', and 

            // 'Initial Catalog' with 'Catalog'

            

           

// .NET DataProvider from Sybase 
         

using Sybase.Data.AseClient;
            

            AseConnection conn = new AseConnection();
            conn.ConnectionString = 

                          "Data Source= color="red">ServerName;" +
            

                          "Initial Catalog= color="red">DataBaseName;" 
            + 

                          "User id= color="red">UserName;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- EasySoft ODBC Driver -- local 
          machine

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                  "Driver={Easysoft IB6 ODBC};" + 

                  "Server= color="red">localhost;" + 

                  "DataBase= color="red">localhost:C:\MyPath\DbName.gdb;" 
            + 

                  "Uid= color="red">UserName;" + 

                  "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- EasySoft ODBC Driver -- 
          remote machine

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                  "Driver={Easysoft IB6 ODBC};" + 

                  "Server= color="red">ServerName;" + 

                  "DataBase= color="red">ServerName:C:\MyPath\DbName.gdb;" 
            + 

                  "Uid= color="red">UserName;" + 

                  "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- Intersolv ODBC Driver -- 
          local machine

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                  "Driver=" + 

               "{INTERSOLV InterBase ODBC Driver (*.gdb)};" + 

                  "Server= color="red">localhost;" + 

                  "DataBase= color="red">localhost:C:\MyPath\DbName.gdb;" 
            + 

                  "Uid= color="red">UserName;" + 

                  "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC -- Intersolv ODBC Driver -- 
          remote machine

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                  "Driver=" + 

               "{INTERSOLV InterBase ODBC Driver (*.gdb)};" + 

                  "Server= color="red">ServerName;" + 

                  "DataBase= color="red">ServerName:C:\MyPath\DbName.gdb;" 
            + 

                  "Uid= color="red">UserName;" + 

                  "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC DSN -- INFORMIX 3.30 ODBC Driver
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Host= color="red">HostName;" + 

                          "Server= color="red">ServerName;" + 

                          "Service= color="red">ServerName;" + 

                          "Protocol= color="red">olsoctcp;" + 

                          "Database= color="red">DataBaseName;" +
            

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC without DSN -- INFORMIX 3.30 
          ODBC Driver

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn="";" + 

                          "Driver={INFORMIX 3.30 32 BIT};" + 

                          "Host= color="red">HostName;" + 

                          "Server= color="red">ServerName;" + 

                          "Service= color="red">ServerName;" + 

                          "Protocol= color="red">olsoctcp;" + 

                          "Database= color="red">DataBaseName;" +
            

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC Informix-CLI 2.5 ODBC Driver
         

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                      "Driver={Informix-CLI 2.5 (32 Bit)};" + 

                      "Server= color="red">ServerName;" + 

                      "DataBase= color="red">DataBaseName;" + 

                      "Uid= color="red">UserName;" + 

                      "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// OleDb -- IBM Informix OleDb Provider
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                    "Driver=IFXOLEDBC;" + 

                    "Data Source= color="red">DataBaseName 
            color="black">@ServerName;" + 

                    "User id= color="red">UserName;" + 

                    "Password= color="red">Secret;"; 

                    "Persist Security Info= color="red">true;"; 

            conn.Open();
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC without DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                   "Driver={Microsoft Excel Driver (*.xls)};" + 

                   "Driverid=790;" + 

                   "Dbq= color="red">C:\MyPath\SpreadSheet.xls;" +
            

                   "DefaultDir= color="red">C:\MyPath;"; 

            conn.Open();
            

           

// OleDb with MS Jet

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                "Driver=Microsoft.Jet.OLEDB.4.0;" + 

                "Data Source= color="red">C:\MyPath\SpreadSheet.xls;" 
            + 

               @"Extended Properties= color="red">""Excel 8.0;HDR=Yes""";
            

            conn.Open();
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                          "Dsn= color="red">DsnName;" + 

                          "Uid= color="red">UserName;" + 

                          "Pwd= color="red">Secret;"; 

            conn.Open();
            

           

// ODBC without DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

             "Driver={Microsoft Text Driver (*.txt; *.csv)};" + 

             "Dbq= color="red">C:\MyPath\;" + 

             "Extensions= color="red">asc,csv,tab,txt;"; 

            conn.Open();
            

             // Use: sql = "Select * From MyTextFile.txt"
            

           

// OleDb with MS Jet

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                  "Driver=Microsoft.Jet.OLEDB.4.0;" + 

                  "Data Source= color="red">C:\MyPath\;" + 

                  "Extended Properties=" + 

                    @" color="red">""text;HDR=Yes;FMT=Delimited""";
            

            conn.Open();
            

             // Use: sql = "Select * From MyTextFile.txt"
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = "Dsn= color="red">DsnName";
            conn.Open();
            

             // Use: sql = "Select * From MyDb.dbf"
            

           

// ODBC without DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                 "Driver={Microsoft dBASE Driver (*.dbf)};" + 

                 "Driverid=277;" + 

                 "Dbq= color="red">C:\MyPath\";
            conn.Open();
            

             // Use: sql = "Select * From MyDb.dbf"
            

           

// ODBC DSN

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = "Dsn= color="red">DsnName";
            conn.Open();
            

           

// ODBC without DSN -- Database 
          container (dbc)

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                  "Driver={Microsoft Visual FoxPro Driver};" + 

                  "SourceType=DBC;" + 

                  "SourceDB= color="red">C:\MyPath\MyDb.dbc;" + 

                  "Exclusive= color="red">No"; 

            conn.Open();
            

           

// ODBC without DSN -- Free table 
          directory

using System.Data.Odbc;
            

            OdbcConnection conn = new 
            OdbcConnection();
            conn.ConnectionString = 

                  "Driver={Microsoft Visual FoxPro Driver};" + 

                  "SourceType=DBF;" + 

                  "SourceDB= color="red">C:\MyPath;" + 

                  "Exclusive= color="red">No"; 

            conn.Open();
            

           

// OleDb -- Database container (dbc)
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=VFPOLEDB;" + 

                          "Data Source= color="red">C:\MyPath\MyDb.dbc;" 
            + 

                          "Collating Sequence=machine;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();
            

           

// OleDb -- Free table directory 
         

using System.Data.OleDb;
            

            OleDbConnection conn = new 
            OleDbConnection();
            conn.ConnectionString = 

                          "Driver=VFPOLEDB;" + 

                          "Data Source= color="red">C:\MyPath\;" +
            

                          "Collating Sequence=general;" + 

                          "Password= color="red">Secret;"; 

            conn.Open();