MSSQL Database Connection String
Posted by on 05 September 2008 07:55 AM

Using DSN


'Your connection here
set conn = server.createobject("ADODB.Connection") "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

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

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

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