본문 바로가기
.NET

.NET connection strings 레퍼런스

AI 정보쟁이 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

'.NET' Related Articles

티스토리툴바