Excel Sheet Database Connectionstrings | Text File Database Connectionstrings | Microsoft Access Database

Excel Sheet Database

// ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Dsn=DsnName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open(); // 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(); // 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();

Text File Database

// ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Dsn=DsnName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open(); // 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" // 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"

Microsoft Access Database

// ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = "Dsn=DsnName"; conn.Open(); // 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(); // 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(); Hide 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(); Hide 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(); // 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(); // 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();

Sql Server Connectionstrings

Microsoft SQL Server

// ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Dsn=DsnName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open(); // 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(); // 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(); // 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(); // 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(); // 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(); // .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(); // .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(); // .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();

Microsoft Sql Express

// .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(); // .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(); // .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(); // .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(); // .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(); // .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();