MS SQL Server 2005 connection String



MS SQL server 2005 & 2008 connection string :


------------------------------------------
con.ConnectionString = "Data Source=Domain.com;Initial Catalog=hostingUser_DBname;user id=user;password=pass";

-------------------------------------------
connectionString="Data Source=(local);Initial Catalog=hostingUser_DBname;User ID=USER;Password=PASS; Integrated Security=True;Trusted_Connection=False;" providerName="System.Data.SqlClient"
--------------------------------------------

providerName="System.Data.SqlClient" />

  • 17 Users Found This Useful
Was this answer helpful?

Related Articles

Sending email using CDOSYS

If you are using a Windows 2000 / 2003 Server, or even XP Pro chances are that CDOSYS is your...

Upload file through ASP.net

<% @Page Language="C#" %><html><head>  <title>File upload...

Mailenable Component - Mail Code

Mailenable Component - Mail Code <%@ Language=VBScript %> <% Dim oMail Set oMail =...

How to create MSAccess Database DSN in Plesk Control Panel?

To Create DSN for MSAccess Database do following steps. 1. Access your control panel 2. Click on...

Create MS Access DSNLess connection string

Many people have requested this so here it is: "DRIVER={Microsoft Access Driver (*.mdb)};...