You are Here: Home >Asp> Tutorial > Connecting to a database

Connecting to a database

text zoom
Previous: ASP Server Side Includes Returning a recordset from a database :Next

To connect to a database you would use the Connection object. Create an instance of the Connection object,and open it using either a DSN or a connection string.



 



With a DSN named company:



 



 











<html>


<head>


<title>


</title>


</head>


<body>


<%


Set cn = Server.CreateObject("ADODB".Connection")


cn.Open "Company"


cn.Execute "SELECT * FROM Employees WHERE Lastname = 'Smith'"


%>


</body>


</html>





 



 



 



or alternatively a detailed connection string:



 



 



 



 











<html>


<head>


<title>


</title>


</head>


<body>


<%


Set cn = Server.CreateObject("ADODB".Connection")


cn.Open "DATABASE=CompanyData;DSN=Company;UID=sa;Password=;"


cn.Execute "SELECT * FROM Employees WHERE Lastname = 'Smith'"


%>


</body>


</html>





 



 



It is also possible to create the Connection object in the Application and Session onStart events. The example below shows how to create a connection for a user's session:



 



 











<html>


<head>


<title>


</title>


</head>


<body>


<%


Sub Session_onStart()


        Set cn = Server.CreateObject("ADODB".Connection")


        Set Session("cn") = cn


End Sub


%>


</body>


</html>





 



 



or just create the connection string and open and close the connections per page (this can be an efficient technique for sites with a lot of hits.)



 



 



 











<html>


<head>


<title>


</title>


</head>


<body>


<%


Sub Session_onStart()


        Set Session("connection_string")= “DATABASE=CompanyData;DSN=Company;UID=sa;Password=;"


End Sub


%>


</body>


</html>
                    
Previous: ASP Server Side Includes Returning a recordset from a database:Next
Give feedback and win a prize.

Asp Source Code

...more

Asp Related Tutorials

...more

New Asp Resources

...more

Copyright © 2010 VisualBuilder. All rights reserved