<%

'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>

Was this answer helpful? 26 Users Found This Useful (164 Votes)

Powered by WHMCompleteSolution