ABOUT ME

    -

    Today
    -
    Yesterday
    -
    Total
    -
    • .NET connection strings 레퍼런스
      .NET 2009. 10. 30. 15:55
      반응형

      출처 :  http://www.dofactory.com/Connect/Connect.aspx

       

      select your database

       MS SQL Server
       MS SQL Express
       MS Access
       Oracle
       IBM DB2
       MySql
       Sybase
       Interbase
       Informix
       Excel
       Text
       dBase Dbf
       Visual FoxPro

        Code samples are in C#. You must provide the values in red


      Microsoft SQL Server



      // ODBC DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- Standard Connection

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Driver={SQL Server};" +
                    "Server=ServerName;" +
                    "DataBase=DataBaseName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- Trusted Connection

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Driver={SQL Server};" +
                    "Server=ServerName;" +
                    "DataBase=DataBaseName;" +
                    "Uid=;" +
                    "Pwd=;";
      conn.Open();

      // or

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Driver={SQL Server};" +
                    "Server=ServerName;" +
                    "DataBase=DataBaseName;" +
                    "Trusted_Connection=Yes;";
      conn.Open();



      Show code

      // OleDb -- Standard Connection

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=SQLOLEDB;" +
                    "Data Source=ServerName;" +
                    "Initial Catalog=DataBaseName;" +
                    "User id=UserName;" +
                    "Password=Secret;";
      conn.Open();



      Show code

      // OleDb -- Trusted Connection

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=SQLOLEDB;" +
                    "Data Source=ServerName;" +
                    "Initial Catalog=DataBaseName;" +
                    "Integrated Security=SSPI;";
      conn.Open();



      Show code

      // OleDb -- via IP Address

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=SQLOLEDB;" +
                    "Network Library=DBMSSOCN;" +
                    "Data Source=xxx.xxx.xxx.xxx,1433;" +
                    "Initial Catalog=DataBaseName;" +
                    "User id=UserName;" +
                    "Password=Secret;";
      conn.Open();



      Show code

      // .NET DataProvider -- Standard Connection

      using System.Data.SqlClient;

      SqlConnection conn = new SqlDbConnection();
      conn.ConnectionString =
                    "Data Source=ServerName;" +
                    "Initial Catalog=DataBaseName;" +
                    "User id=UserName;" +
                    "Password=Secret;";
      conn.Open();



      Show code

      // .NET DataProvider -- Trusted Connection

      using System.Data.SqlClient;

      SqlConnection conn = new SqlConnection();
      conn.ConnectionString =
                    "Data Source=ServerName;" +
                    "Initial Catalog=DataBaseName;" +
                    "Integrated Security=SSPI;";
      conn.Open();



      Show code

      // .NET DataProvider -- via IP Address

      using System.Data.SqlClient;

      SqlConnection conn = new SqlConnection();
      conn.ConnectionString =
                    "Network Library=DBMSSOCN;" +
                    "Data Source=xxx.xxx.xxx.xxx,1433;" +
                    "Initial Catalog=DataBaseName;" +
                    "User Id=UserName;" +
                    "Password=Secret;";
      conn.Open();



      return to top

      Microsoft Sql Express

      Show code

      // .NET Data Provider -- Default Relative Path
      // Standard Connection

      using System.Data.SqlClient;

      SqlConnection conn = new SqlConnection();
      conn.ConnectionString =
           "Data Source=.\SQLExpress;" +
           "User Instance=true;" +
           "User Id=UserName;" +
           "Password=Secret;" +
           "AttachDbFilename=|DataDirectory|DataBaseName.mdf;"
      conn.Open();



      Show code

      // .NET Data Provider -- Default Relative Path
      // Trusted Connection

      using System.Data.SqlClient;

      SqlConnection conn = new SqlConnection();
      conn.ConnectionString =
           "Data Source=.\SQLExpress;" +
           "User Instance=true;" +
           "Integrated Security=true;" +
           "AttachDbFilename=|DataDirectory|DataBaseName.mdf;"
      conn.Open();



      Show code

      // .NET Data Provider -- Custom Relative Path
      // Standard Connection

      using System.Data.SqlClient;

      AppDomain.CurrentDomain.SetData(
           "DataDirectory", "C:\MyPath\");

      SqlConnection conn = new SqlConnection();
      conn.ConnectionString =
           "Data Source=.\SQLExpress;" +
           "User Instance=true;" +
           "User Id=UserName;" +
           "Password=Secret;" +
           "AttachDbFilename=|DataDirectory|DataBaseName.mdf;"
      conn.Open();



      Show code

      // .NET Data Provider -- Custom Relative Path
      // Trusted Connection

      using System.Data.SqlClient;

      AppDomain.CurrentDomain.SetData(
           "DataDirectory", "C:\MyPath\");

      SqlConnection conn = new SqlConnection();
      conn.ConnectionString =
           "Data Source=.\SQLExpress;" +
           "User Instance=true;" +
           "Integrated Security=true;" +
           "AttachDbFilename=|DataDirectory|DataBaseName.mdf;"
      conn.Open();



      Show code

      // .NET Data Provider -- Absolute Path
      // Standard Connection

      using System.Data.SqlClient;

      SqlConnection conn = new SqlConnection();
      conn.ConnectionString =
           "Data Source=.\SQLExpress;" +
           "User Instance=true;" +
           "User Id=UserName;" +
           "Password=Secret;" +
           "AttachDbFilename=C:\MyPath\DataBaseName.mdf;"
      conn.Open();



      Show code

      // .NET Data Provider -- Absolute Path
      // Trusted Connection

      using System.Data.SqlClient;

      SqlConnection conn = new SqlConnection();
      conn.ConnectionString =
           "Data Source=.\SQLExpress;" +
           "User Instance=true;" +
           "Integrated Security=true;" +
           "AttachDbFilename=C:\MyPath\DataBaseName.mdf;"
      conn.Open();



      return to top

      Microsoft Access

      Show code

      // ODBC DSN

      using System.Data.Odbc;

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



      Show code

      // ODBC -- Standard Security

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
          "Driver={Microsoft Access Driver (*.mdb)};" +
          "Dbq=c:\myPath\myDb.mdb;" +
          "Uid=Admin;Pwd=;";
      conn.Open();



      Show code

      // ODBC -- Workgroup (System Database)

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
          "Driver={Microsoft Access Driver (*.mdb)};" +
          "Dbq=c:\myPath\myDb.mdb;" +
          "SystemDb=c:\myPath\myDb.mdw;";
      conn.Open();



      Show code

      // ODBC -- Exclusive Use

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
           "Driver={Microsoft Access Driver (*.mdb)};" +
           "Dbq=c:\myPath\myDb.mdb;" +
           "Exclusive=1;";
           "Uid=Admin;Pwd=;";
      conn.Open();



      Show code

      // OleDb with MS Jet -- Standard Security

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                 "Provider=Microsoft.Jet.OLEDB.4.0;" +
                 "Data Source=c:\mypath\myDb.mdb;" +
                 "User id=admin;" +
                 "Password=";
      conn.Open();



      Show code

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

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                 "Provider=Microsoft.Jet.OLEDB.4.0;" +
                 "Data Source=c:\mypath\myDb.mdb;" +
                 "System Database=c:\mypath\myDb.mdw;";
      conn.Open();



      Show code

      // OleDb with MS Jet -- With Password

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                 "Provider=Microsoft.Jet.OLEDB.4.0;" +
                 "Data Source=c:\mypath\myDb.mdb;" +
                 "Database Password=Secret;"
      conn.Open();



      return to top

      Oracle

      Show code

      // ODBC DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- New Microsoft Driver

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                 "Driver={Microsoft ODBC for Oracle};" +
                 "Server=OracleServer.world;" +
                 "Uid=UserName;" +
                 "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- Old Microsoft Driver

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
          "Driver={Microsoft ODBC Driver for Oracle};" +
          "ConnectString=OracleServer.world;" +
          "Uid=UserName;" +
          "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- Oracle Driver

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
          "Driver={Oracle ODBC Driver};" +
          "Dbq=myDataBase;" + // define in tsnames.ora
          "Uid=UserName;" +
          "Pwd=Secret;";
      conn.Open();



      Show code

      // OleDb -- Microsoft Driver

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=MSDAORA;" +
                    "Data Source=ServerName;" +
                    "User id=UserName;" +
                    "Password=Secret;";
      conn.Open();



      Show code

      // OleDb -- Oracle Driver -- Standard Connection

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=OraOLEDB.Oracle;" +
                    "Data Source=ServerName;" +
                    "User id=UserName;" +
                    "Password=Secret;";
      conn.Open();



      Show code

      // OleDb -- Oracle Driver -- Trusted Connection

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=OraOLEDB.Oracle;" +
                    "Data Source=ServerName;" +
                    "OSAuthent=1;";
      conn.Open();

      // or

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=OraOLEDB.Oracle;" +
                    "Data Source=ServerName;" +
                    "User id=/" +
                    "Password=;";
      conn.Open();



      Show code

      // .NET DataProvider from Microsoft
      // -- Standard Connection

      using System.Data.OracleClient;

      OracleConnection conn = new OracleConnection();
      conn.ConnectionString =
                    "Data Source=ServerName;" +
                    "User id=UserName;";
                    "Password=Secret;";
      conn.Open();



      Show code

      // .NET DataProvider from Microsoft
      // -- Trusted Connection

      using System.Data.OracleClient;

      OracleConnection conn = new OracleConnection();
      conn.ConnectionString =
                    "Data Source=Servername;" +
                    "Integrated Security=Yes;";
      conn.Open();



      Show code

      // .NET DataProvider from Oracle
      // -- Standard Connection

      using Oracle.DataAccess.Client;

      OracleConnection conn = new OracleConnection();
      conn.ConnectionString =
                    "Data Source=ServerName;" +
                    "User id=UserName;";
                    "Password=Secret;";
      conn.Open();



      Show code

      // .NET DataProvider from Oracle
      // -- Trusted Connection

      using Oracle.DataAccess.Client;

      OracleConnection conn = new OracleConnection();
      conn.ConnectionString =
                    "Data Source=Servername;" +
                    "Integrated Security=Yes;";
      conn.Open();



      return to top

      IBM DB2

      Show code

      // ODBC DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC without DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Driver={IBM DB2 ODBC DRIVER};" +
                    "DataBase=DataBaseName;" +
                    "HostName=ServerName;" +
                    "Protocol=TCPIP;" +
                    "Port=PortNumber;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // OleDb -- Microsoft Driver

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                 "Driver=DB2OLEDB;" +
                 "Network Transport Library=TCPIP;" +
                 "Network Address=xxx.xxx.xxx.xxx;" +
                 "Package Collection=CollectionName;" +
                 "Initial Catalog=DataBaseName;" +
                 "User id=UserName;" +
                 "Password=Secret;";
      conn.Open();



      Show code

      // OleDb -- IBM Driver

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                  "Driver=IBMDADB2;" +
                  "DataBase=DataBaseName;" +
                  "HostName=ServerName;" +
                  "Protocol=TCPIP;" +
                  "Port=PortNumber;" +
                  "Uid=UserName;" +
                  "Pwd=Secret;";
      conn.Open();



      Show code

      // .NET DataProvider from IBM

      using IBM.Data.DB2;

      Db2Connection conn = new Db2Connection();
      conn.ConnectionString =
                    "DataBase=DataBaseName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;" +
      conn.Open();



      return to top

      MySql

      Show code

      // ODBC DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- MyODBC Driver -- local database

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                  "Driver={MySql};" +
                  "Server=localhost;" +
                  "Option=16834;" +
                  "DataBase=DataBaseName;"
      conn.Open();



      Show code

      // ODBC -- MyODBC Driver -- remote database

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                  "Driver={MySql};" +
                  "Server=db.domain.com;" +
                  "Option=131072;" +
                  "Port=3306;" +
                  "Stmt=;" +
                  "DataBase=DataBaseName;" +
                  "Uid=UserName;" +
                  "Pwd=Secret;"
      conn.Open();



      Show code

      // ODBC -- MySQL ODBC 3.51 Driver

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
           "Driver={MySql ODBC 3.51 Driver};" +
           "Server=ServerName;" +
           "Option=16834;" +
           "Port=3306;" +
           "Stmt=;" +
           "DataBase=DataBaseName;" +
           "Uid=UserName;" +
           "Pwd=Secret;"
      conn.Open();

      // or

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
           "DRIVER={MySql ODBC 3.51 Driver};" +
           "SERVER=ServerName;" +
           "DATABASE=DataBaseName;" +
           "USER=UrerName;" +
           "PASSWORD=Secret;"
      conn.Open();



      Show code

      // OleDb

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                  "Provider=MySqlProv;" +
                  "Data Source=ServerName;" +
                  "User id=UserName;" +
                  "Password=Secret;"
      conn.Open();



      Show code

      // .NET DataProvider from CoreLab

      using CoreLab.MySql;

      MySqlConnection conn = new MySqlConnection();
      conn.ConnectionString =
                    "Host=ServerName;" +
                    "DataBase=DataBaseName;" +
                    "Protocol=TCP;" +
                    "Port=3306;" +
                    "Direct=true;" +
                    "Compress=false;" +
                    "Pooling=true;" +
                    "Min Pool Size=0;" +
                    "Max Pool Size=100;" +
                    "Connection Lifetime=0;" +
                    "User id=UserName;" +
                    "Password=Secret;" +
      conn.Open();



      return to top

      Sybase

      Show code

      // ODBC DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

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

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Driver={SYBASE ASE ODBC Driver};" +
                    "Srvr=ServerName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- Sybase System 11 ODBC Driver

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                 "Driver={SYBASE SYSTEM 11};" +
                 "Srvr=ServerName;" +
                 "Uid=UserName;" +
                 "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- Intersolv 3.10 ODBC Driver

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
              "Driver={INTERSOLV 3.10 32-BIT Sybase};" +
              "Srvr=ServerName;" +
              "Uid=UserName;" +
              "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC -- SQL Anywhere

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
               "ODBC;" +
               "Driver={Sybase SQL Anywhere 5.0};" +
               "DefaultDir=c:\myfolder\;" +
               "Dbf=c:\mypath\dbname.db;" +
               "Uid=UserName;" +
               "Pwd=Secret;" +
               "Dsn="""";";     // Must be included!
      conn.Open();



      Show code

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

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=Sybase.ASEOLEDBProvider;" +
                    "Server Name=ServerName,5000;" +
                    "Initial Catalog=DataBaseName;" +
                    "User id=UserName;" +
                    "Password=Secret;";
      conn.Open();

      // optionally, replace
      // 'Server Name' with 'Srvr', and
      // 'Initial Catalog' with 'Catalog'



      Show code

      // .NET DataProvider from Sybase

      using Sybase.Data.AseClient;

      AseConnection conn = new AseConnection();
      conn.ConnectionString =
                    "Data Source=ServerName;" +
                    "Initial Catalog=DataBaseName;" +
                    "User id=UserName;" +
                    "Password=Secret;";
      conn.Open();



      return to top

      Interbase

      Show code

      // ODBC DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

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

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
            "Driver={Easysoft IB6 ODBC};" +
            "Server=localhost;" +
            "DataBase=localhost:C:\MyPath\DbName.gdb;" +
            "Uid=UserName;" +
            "Pwd=Secret;";
      conn.Open();



      Show code

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

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
            "Driver={Easysoft IB6 ODBC};" +
            "Server=ServerName;" +
            "DataBase=ServerName:C:\MyPath\DbName.gdb;" +
            "Uid=UserName;" +
            "Pwd=Secret;";
      conn.Open();



      Show code

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

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
            "Driver=" +
         "{INTERSOLV InterBase ODBC Driver (*.gdb)};" +
            "Server=localhost;" +
            "DataBase=localhost:C:\MyPath\DbName.gdb;" +
            "Uid=UserName;" +
            "Pwd=Secret;";
      conn.Open();



      Show code

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

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
            "Driver=" +
         "{INTERSOLV InterBase ODBC Driver (*.gdb)};" +
            "Server=ServerName;" +
            "DataBase=ServerName:C:\MyPath\DbName.gdb;" +
            "Uid=UserName;" +
            "Pwd=Secret;";
      conn.Open();



      return to top

      Informix

      Show code

      // ODBC DSN -- INFORMIX 3.30 ODBC Driver

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Host=HostName;" +
                    "Server=ServerName;" +
                    "Service=ServerName;" +
                    "Protocol=olsoctcp;" +
                    "Database=DataBaseName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // 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=HostName;" +
                    "Server=ServerName;" +
                    "Service=ServerName;" +
                    "Protocol=olsoctcp;" +
                    "Database=DataBaseName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // 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=ServerName;" +
                "DataBase=DataBaseName;" +
                "Uid=UserName;" +
                "Pwd=Secret;";
      conn.Open();



      Show code

      // OleDb -- IBM Informix OleDb Provider

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
              "Driver=IFXOLEDBC;" +
              "Data Source=DataBaseName@ServerName;" +
              "User id=UserName;" +
              "Password=Secret;";
              "Persist Security Info=true;";
      conn.Open();



      return to top

      Excel

      Show code

      // ODBC DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC without DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
             "Driver={Microsoft Excel Driver (*.xls)};" +
             "Driverid=790;" +
             "Dbq=C:\MyPath\SpreadSheet.xls;" +
             "DefaultDir=C:\MyPath;";
      conn.Open();



      Show code

      // OleDb with MS Jet

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
          "Driver=Microsoft.Jet.OLEDB.4.0;" +
          "Data Source=C:\MyPath\SpreadSheet.xls;" +
         @"Extended Properties=""Excel 8.0;HDR=Yes""";
      conn.Open();



      return to top

      Text

      Show code

      // ODBC DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
                    "Dsn=DsnName;" +
                    "Uid=UserName;" +
                    "Pwd=Secret;";
      conn.Open();



      Show code

      // ODBC without DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
       "Driver={Microsoft Text Driver (*.txt; *.csv)};" +
       "Dbq=C:\MyPath\;" +
       "Extensions=asc,csv,tab,txt;";
      conn.Open();

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



      Show code

      // OleDb with MS Jet

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
            "Driver=Microsoft.Jet.OLEDB.4.0;" +
            "Data Source=C:\MyPath\;" +
            "Extended Properties=" +
              @"""text;HDR=Yes;FMT=Delimited""";
      conn.Open();

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



      return to top

      dBase Dbf

      Show code

      // ODBC DSN

      using System.Data.Odbc;

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

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



      Show code

      // ODBC without DSN

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
           "Driver={Microsoft dBASE Driver (*.dbf)};" +
           "Driverid=277;" +
           "Dbq=C:\MyPath\";
      conn.Open();

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



      return to top

      Visual FoxPro

      Show code

      // ODBC DSN

      using System.Data.Odbc;

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



      Show code

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

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
            "Driver={Microsoft Visual FoxPro Driver};" +
            "SourceType=DBC;" +
            "SourceDB=C:\MyPath\MyDb.dbc;" +
            "Exclusive=No";
      conn.Open();



      Show code

      // ODBC without DSN -- Free table directory

      using System.Data.Odbc;

      OdbcConnection conn = new OdbcConnection();
      conn.ConnectionString =
            "Driver={Microsoft Visual FoxPro Driver};" +
            "SourceType=DBF;" +
            "SourceDB=C:\MyPath;" +
            "Exclusive=No";
      conn.Open();



      Show code

      // OleDb -- Database container (dbc)

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=VFPOLEDB;" +
                    "Data Source=C:\MyPath\MyDb.dbc;" +
                    "Collating Sequence=machine;" +
                    "Password=Secret;";
      conn.Open();



      Show code

      // OleDb -- Free table directory

      using System.Data.OleDb;

      OleDbConnection conn = new OleDbConnection();
      conn.ConnectionString =
                    "Driver=VFPOLEDB;" +
                    "Data Source=C:\MyPath\;" +
                    "Collating Sequence=general;" +
                    "Password=Secret;";
      conn.Open();




      반응형
      저작자표시 비영리 변경금지

      '.NET' 카테고리의 다른 글

      DebugView trace 트레이스 tool  (0) 2015.07.23
      MSDN Library Developer Quick Links  (2) 2012.12.06
      모듈에 어셈블리 매니페스트가 있어야 합니다  (1) 2012.08.27
      Get primary key on insert / Insert Primary Key 얻기  (0) 2009.11.04
      그리드뷰 샘플 gridview msdn asp.net 2.0 예제  (0) 2009.07.06
      System.Web.HttpUtility 가 안보여?? 인텔리센스(Intellisense)가 망가졌나?? ㅋㅋ  (0) 2009.07.06
      자바 스크립트 스크립트 메니져  (0) 2009.05.19
      Enumerator 예제  (0) 2009.04.28

      관련글 관련글 더보기

      댓글

    Designed by Tistory.

    티스토리툴바