Technical Interview Questions
Visual Basic Interview Question
.NET Web Interview Questions
.NET Interview Questions
C# Interview Questions
                              .........More

Source Codes
Asp .NET Source Codes
Asp VB Script Source Codes
                              .........More

Soft Skills
Communication Skills
Leadership Skills
                              .........More

Asp/VB Script Source Codes

DB Common

<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=myDSN"
objConn.Open
%>

Hey, But don't you think that writing this script on each page would not be a good idea in terms of scalability !
A better approach would be to have this code in an include file centrally.
Create a file called say 'dbObject.asp' and perhaps place it in the
/scripts directory.

dbObject.asp might look something like this
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=myDSN"
objConn.Open
%>

Add the following in every page page that you need to use database connectivity.

<!--#include virtual="/scripts/dbObject.asp"-->

Have a Question ? post your questions here. It will be answered as soon as possible.