Connectionstring

Jun 11, 2013 at 5:04 AM
This format should be correct?
Server=myServer\myInstance;Database=MyDB;Trusted_Connection=True;
Thanks
Coordinator
Jun 11, 2013 at 1:31 PM
Hi bittela,

I think format you provided is .NET format, not OLE DB. OLE DB format should look like this: "Data Source=(local);Initial Catalog=test;Provider=SQLNCLI11.1;Integrated Security=SSPI;"

Check this site for more details regarding connection strings: http://www.connectionstrings.com/sql-server-2012#net-framework-data-provider-for-ole-db.

Cheers,
Miljan