How can you make a connection string for an OleDbConnection
? I have tried a lot of combinations and variants, but nothing works. I use a MS-SQL platform with C# to make the connection for SQL EXPRESS.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Data\Northwind.mdb;User Id=admin;Password=;
Data Source=(local);Provider=SQLOLEDB;Initial Catalog=FastCycle;Integrated Security=true
Persist Security Info=False;Data Source=Northwind;Integrated Security=SSPI;Trusted_Connection=TRUE;providerName=System.Data.OleDb
Provider=SQLOLEDB;Data Source=Northwind.mdb
Provider=SQLEXPRESS;Data Source=Northwind.MDB
@paddy suggested me this site connectionstrings.com. It help me to find the correct string. It was: