Knowledgebase
MSSQL Database Connection String
Posted by PremiumReseller.com on 05 September 2008 07:55 AM

Using DSN

<%

'Your connection here
set conn = server.createobject("ADODB.Connection")
conn.open "DSN=your-dsn; UID=sqldbuser; PWD=sqldbpass"
set rs = server.createobject("ADODB.recordset")

%>

Standard Security

Driver={SQL Native Client};Server=SQL-Server-Address;Database=your-sql-db;Uid=sqldbuser;Pwd=sqldbpass;

 

Visual Studio ASP.Net Connection String

<connectionStrings>
<add name="SampleConnectionString" connectionString="Data Source=sql-server;Initial Catalog=sql-database;User ID=dbuser;Password=dbpassword" providerName="System.Data.SqlClient" />
 </connectionStrings>

To check SQL Server details, please login WebsitePanel, go to Hosting Space, select View Space Summary in right menu.

(371 vote(s))
This article was helpful
This article was not helpful