Syntax for connecting a database

Syntax for connecting a database in sql server with an asp page?

 

go in web config
<connection string><add name="connectionstringname" connectionstring="server=servername;database=databasename;uid=sa;pwd=password"

 

If you want to customize asp.net with any database you have connection strings here, http://www.connectionstrings.com/

 

Dim strSQL As String = ""
Dim strConn As New SqlConnection(ConfigurationManager.ConnectionStrings("CONNECTIONAME").ConnectionString)
Dim dr As SqlDataReader = Nothing
Dim cm As New SqlCommand
strSQL = "SELECT * FROM USERS"
strConn.Open()
cm.CommandType = CommandType.Text
cm.Connection = strConn
cm.CommandText = strSQL
dr= cm.ExecuteReader()

 

I have used that code for connectivity this is also given error...

 

what error occurs..could you elaborate?

 

Dim database_connection
Dim rsconn
Dim query_string

Set database_connection = Server.CreateObject("ADODB.Connection")
Set rsConn = Server.CreateObject("ADODB.Recordset")

database_connection.Open "Driver={SQL Server};UID=***;password=**;server=*;database=*;"

query_string = "Select * From table"
rsconn.open query_string,database_connection


Been using this connection string for my ASP and VB projects...

 

try to use a separate include for the connection so that you save some time

 

Does it occur for first time when done...