Connectionstrings

Mariusz Jurczenko Mariusz Jurczenko

Connectionstrings

Oto przykładowe Connectionstrings do najpopularniejszych baz danych.

Microsoft SQL Server

ODBC — Standard Connection

using System.Data.Odbc;
var conn = new OdbcConnection();conn.ConnectionString = 
 	"Driver={SQL Server};" + 
 	"Server=DataBaseNamex;" + 
 	"DataBase=DataBaseName;" + 
 	"Uid=UserName;" + 
 	"Pwd=Secret;"; 
conn.Open();

ODBC — Trusted Connection

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

// lub

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

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();conn.ConnectionString = 
	"Dsn=DsnName;" +               				
	"Uid=UserName;" +               
	"Pwd=Secret;"; 
conn.Open();

OleDb — Standard Connection

using System.Data.OleDb;
var 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;
var 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;
var 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;
var 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;
var 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;
var 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;
var 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;
var 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\");
var 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\");
var 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;
var 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;
var conn = new SqlConnection();
conn.ConnectionString = 
       "Data Source=.\SQLExpress;" + 
       "User Instance=true;" + 
       "Integrated Security=true;" + 
       "AttachDbFilename=C:\MyPath\DataBaseName.mdf;"
conn.Open();

ORACLE

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =               
	"Dsn=DsnName;" +               
	"Uid=UserName;" +               
	"Pwd=Secret;"; 
conn.Open();

ODBC — New Microsoft Driver

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

ODBC — Old Microsoft Driver

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

ODBC — Oracle Driver

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =     
	"Driver={Oracle ODBC Driver};" +     
	"Dbq=myDataBase;" + // zdefiniowane w tsnames.ora    
	"Uid=UserName;" +     
	"Pwd=Secret;"; 
conn.Open();

OleDb — Microsoft Driver

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

OleDb — Oracle Driver — Standard Connection

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

OleDb — Oracle Driver — Trusted Connection

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

// lub 

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

.NET DataProvider from Microsoft — Standard Connection

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

.NET DataProvider from Microsoft — Trusted Connection

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

.NET DataProvider from Oracle — Standard Connection

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

.NET DataProvider from Oracle — Trusted Connection

using Oracle.DataAccess.Client;
var conn = new OracleConnection();
conn.ConnectionString =               
	"Data Source=Servername;" +               
	"Integrated Security=Yes;"; 
conn.Open();

IBM DB2

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =               
	"Dsn=DsnName;" +               
	"Uid=UserName;" +               
	"Pwd=Secret;"; 
conn.Open();

ODBC without DSN

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

OleDb — Microsoft Driver

using System.Data.OleDb;
var 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();

OleDb — IBM Driver

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

.NET DataProvider from IBM

using IBM.Data.DB2;
var conn = new Db2Connection();
conn.ConnectionString =               
	"DataBase=DataBaseName;" +               
	"Uid=UserName;" +               
	"Pwd=Secret;";
conn.Open();

MySql

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =               
	"Dsn=DsnName;" +               
	"Uid=UserName;" +               
	"Pwd=Secret;";
conn.Open();

ODBC — MyODBC Driver — local database

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

ODBC — MyODBC Driver — remote database

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

ODBC — MySQL ODBC 3.51 Driver

using System.Data.Odbc;
var 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();

// lub 

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

OleDb

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

.NET DataProvider from CoreLab

using CoreLab.MySql;
var 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();

Sybase

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =               
	"Dsn=DsnName;" +               
	"Uid=UserName;" +               
	"Pwd=Secret;"; 
conn.Open();

ODBC — Sybase System 12 (12.5) ODBC Driver

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

ODBC — Sybase System 11 ODBC Driver

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

ODBC — Intersolv 3.10 ODBC Driver

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

ODBC — SQL Anywhere

using System.Data.Odbc;
var 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="""";";     
conn.Open();

OleDb — Sybase Adaptive Server Enterprise (ASE)

using System.Data.OleDb;
var conn = new OleDbConnection();
conn.ConnectionString =               
	"Driver=Sybase.ASEOLEDBProvider;" +               
	"Server Name=ServerName,5000;" +               
	"Initial Catalog=DataBaseName;" +               
	"User id=UserName;" +               
	"Password=Secret;"; 
conn.Open();
// opcjonalnie zamień „Server Name” na „Srvr”
// i „Initial Catalog” na „Catalog”

.NET DataProvider from Sybase

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

Interbase

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =               
	"Dsn=DsnName;" +               
	"Uid=UserName;" +               
	"Pwd=Secret;"; 
conn.Open();

ODBC — EasySoft ODBC Driver — local machine

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

ODBC — EasySoft ODBC Driver — remote machine

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

ODBC — Intersolv ODBC Driver — local machine

using System.Data.Odbc;
var 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();

ODBC — Intersolv ODBC Driver — remote machine

using System.Data.Odbc;
var 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();

Informix

ODBC DSN — INFORMIX 3.30 ODBC Driver

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

ODBC without DSN — INFORMIX 3.30 ODBC Driver

using System.Data.Odbc;
var 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();

ODBC Informix-CLI 2.5 ODBC Driver

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =           
	"Driver={Informix-CLI 2.5 (32 Bit)};" +           
	"Server=ServerName;" +           
	"DataBase=DataBaseName;" +           
	"Uid=UserName;" +           
	"Pwd=Secret;"; 
conn.Open();

OleDb — IBM Informix OleDb Provider

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

dBase Dbf

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString = "Dsn=DsnName";
conn.Open();

ODBC without DSN

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

Microsoft Access

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString = "Dsn=DsnName";
conn.Open();

ODBC — Standard Security

using System.Data.Odbc;
var 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;
var conn = new OdbcConnection();
conn.ConnectionString =     
	"Driver={Microsoft Access Driver (*.mdb)};" +     
	"Dbq=c:\myPath\myDb.mdb;" +     
	"SystemDb=c:\myPath\myDb.mdw;"; 
conn.Open();

ODBC — Exclusive Use

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

OleDb with MS Jet — Standard Security

using System.Data.OleDb;var 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;
var 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;
var conn = new OleDbConnection();
conn.ConnectionString = 
 	"Provider=Microsoft.Jet.OLEDB.4.0;" + 
 	"Data Source=c:\mypath\myDb.mdb;" + 
 	"Database Password=Secret;"
conn.Open();

Excel

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =               
	"Dsn=DsnName;" +               
	"Uid=UserName;" +               
	"Pwd=Secret;"; 
conn.Open();

ODBC without DSN

using System.Data.Odbc;
var 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;
var 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

ODBC DSN

using System.Data.Odbc;
var conn = new OdbcConnection();
conn.ConnectionString =               
	"Dsn=DsnName;" +               
	"Uid=UserName;" +               
	"Pwd=Secret;"; 
conn.Open();

ODBC without DSN

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

OleDb with MS Jet

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

8 comments

  1. Ten wpis to prawdziwa kopalnia wiedzy dla każdego, kto pracuje z bazami danych. Zdecydowanie zapisuję go do zakładek, żeby mieć pod ręką w razie potrzeby.

    Bardzo dziękuję za podzielenie się tą wiedzą!

    Odpowiedz

  2. Czy możesz polecić jakieś narzędzia do generowania connection stringów? Korzystanie z gotowych szablonów mogłoby zaoszczędzić sporo czasu i uniknąć błędów.

    Odpowiedz

    1. Istnieje wiele narzędzi, które mogą pomóc w generowaniu connection stringów dla różnych baz danych. Oto kilka z nich:

      1. Connection String Builder:

      Jest to darmowe narzędzie online, które umożliwia generowanie connection stringów dla wielu popularnych baz danych, w tym MySQL, PostgreSQL, SQL Server i Oracle.
      Interfejs jest prosty i łatwy w użyciu, a narzędzie pozwala zapisać wygenerowane connection stringi do pliku lub skopiować je do schowka.https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-builders

      2. DBeaver:
      Jest to darmowe narzędzie graficzne do zarządzania bazami danych, które posiada funkcję generowania connection stringów.
      DBeaver obsługuje szeroką gamę baz danych i oferuje wiele dodatkowych funkcji, takich jak modelowanie danych, wizualizacja zapytań i porównywanie schematów.https://dbeaver.io/download/

      3. SQL Server Management Studio (SSMS):
      Jest to darmowe narzędzie graficzne firmy Microsoft do zarządzania bazami danych SQL Server.
      SSMS posiada wbudowaną funkcję generowania connection stringów, która umożliwia zapisywanie ich do pliku lub kopiowanie do schowka.https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

      Odpowiedz

  3. Bardzo fajny wpis! Zauważyłem jednak, że w przypadku connection stringu do bazy danych MySQL brakuje informacji o porcie. Domyślny port to 3306, ale warto o tym wspomnieć dla początkujących użytkowników.

    Odpowiedz

    1. Rzeczywiście, w przykładzie connection stringu do bazy danych MySQL brakuje informacji o porcie. Domyślnym portem dla MySQL jest 3306, ale warto o tym wspomnieć, aby uniknąć nieporozumień, zwłaszcza dla początkujących użytkowników.
      Aby poprawić wpis, dodam informację o porcie do connection stringu MySQL. Będzie to wyglądać następująco:

      Server=localhost;Port=3306;Database=mojaBazaDanych;Uid=mojUzytkownik;Pwd=mojeHaslo;

      Odpowiedz

  4. Czy mógłbyś dodać jeszcze kilka przykładów connection stringów dla mniej popularnych baz danych? Byłoby to bardzo pomocne dla osób, które pracują z różnymi technologiami.

    Odpowiedz

  5. Będę musiał zapisać ten wpis do zakładek. Na pewno przyda mi się w przyszłości, kiedy będę konfigurować połączenie z bazą danych. Dzięki za podzielenie się tą wiedzą!

    Odpowiedz

  6. Super wpis! Szczególnie przydatne jest podsumowanie connection stringów dla różnych baz danych. Do tej pory zawsze miałem problem ze znalezieniem odpowiednich informacji w różnych źródłach. Dzięki temu wpisowi mam wszystko w jednym miejscu.

    Odpowiedz

Dodaj komentarz

Twój adres e-mail nie zostanie opublikowany. Wymagane pola są oznaczone *