Advertise with us

Control Panel Forum Hosting Help ASP.NET 4.5 & SQL 2012 Hosting Resources Notice

Home » Resources » Connection strings from .NET foR SQL Server 2005

ASP.NET	ADO.NET	Web Services	Remoting	Visual Studio 2005
Error Bank	Interview Questions	Tips & Tricks	XML	HTML
Jscript/Javascript	IIS	Windows		General

Submit Resource or code snippet ... and get surprise gifts ASP.NET web hosting

Win Digital camera, ASP.NET Books, Free softwares!!

Connection strings from .NET foR SQL Server 2005

26 Feb, 2008

Author: yo ao

Summary
Connection strings

.NET Classes used :

Some summaries Connection strings from to SQL Server 2005, from. NET:
1. Security Standard
"Data Source=Aron1; Initial Catalog=pubs; User Id=myUsername; Password=myPassword;"

2.Secure Connection
"Data Source=Aron1; Initial Catalog=pubs; Integrated Security=SSPI;"

3.Connecting Via IP
"Data Source=190.190.200.100,1433; Network Library=DBMSSOCN; Initial Catalog=pubs; User ID=myUsername; Password=myPassword;"

4.Attaching a database to connect to SQL Express
"Server=.\SQLExpress; AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname; Trusted_Connection=Yes;"

Feedbacks about this page from members:

- No Feedbacks yet !! -

Submit Feedback View All Feedbacks

Total members: 250665
Average new registrations per day (in last 7 days): 7

New Registration: Open

Register Now

Talk to Webmaster
Tony John

Facebook
Google+
Twitter