Basic ADO and SQL Tutorial
page 2 of 5
by Steven Smith
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 53655/ 117

Connection Object

Now that you have a machine on which to practice, the first thing that is required for you to start using a database with your ASP pages is a connection. Using your editor of choice(Visual Interdev 6.0 is very nice because it has Intellisense, which will help you see the methods and properties of the various ADO objects), write the following code:

 Session("DB_ConnectionString") = _
 "DSN=myDSN;UID=myUID;PWD=myPWD;DB=myDB;HOST=myHOST;SERV=MyService;SRVR=MyServer;PRO=MyProtocol;"
 Dim objConnect   'Declare the connection variable
 'Set up Connection Object
 Set objConnect = Server.CreateObject("ADODB.Connection")
 objConnect.Open Session("DB_ConnectionString")

Notice that I'm using a Session variable for the connection string. This is useful if you plan on using the same database for multiple ASP pages, which is often the case. If you are using Visual Interdev, you can use the data connection wizard to create this Session variable for you. In VI 1.0, you do this by clicking on Project - Add to Project - Data Connection. If you do not already have a DSN, this will also let you create one. MAKE SURE YOU USE A SYSTEM DSN! If you use a File DSN, then the default web user account on Windows NT (IUSR_MACHINENAME) will not be able to access the database. Also note that many of the parameters in the connection string above are not necessary if you are using a database on the same machine as your server. In fact, you do not even need to use a DSN. An alternative, if you have the database as a file on your web server, is to do the following:

 Dim objConnect   'Declare the connection variable
 Dim cnpath    'Connection path to database file
 'Set up Connection Object
 Set objConnect = Server.CreateObject("ADODB.Connection")
 cnpath="DBQ=" & server.mappath("/path/database.mdb")
 objConnect.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath

This assumes that the database is located within your web directory, in the subdirectory "path". You can set cnpath to "C:\path\database.mdb" if you want it to use any path on your machine. Once you have established a connection, you are ready to move on to recordset and command objects.

Also note that you could (and should) use an Application variable instead of a Session variable, assuming everybody on your site will be connecting to the same database, which is typically the case.  Finally, it is very important that you only open connections when you need them, and that you keep them open as briefly as possible.  As soon as you're finished with them, call Connection.Close.


View Entire Article

User Comments

Title: 2012 NFL jerseys   
Name: NIKE NFL jerseys
Date: 2012-05-20 11:29:43 PM
Comment:
[/pre]Cheap NFL,NBA,MLB,NHL
[url=http://www.jersey2shop.com/]Jerseys From China[/url]
[url=http://www.jersey2shop.com/]2012 nike nfl Jerseys[/url]
[url=http://www.jersey2shop.com/]cheap China Jerseys[/url]
[url=http://www.jersey2shop.com/]Sports Jerseys China[/url]
[url=http://www.jersey2shop.com/NFL-Jerseys-c68/]NFL Jerseys China[/url]
[url=http://www.jersey2shop.com/NBA-Jerseys-c77/]NBA Jerseys China[/url]
NHL Jerseys China
[url=http://www.jersey2shop.com/MLB-Jerseys-c94/]MLB Jerseys China[/url]NFL jerseys For Sale online.All Our Jerseys Are Sewn On and Directly From Chinese Jerseys Factory
[/pre]
[pre]We Are Professional China jerseys Wholesaler
[url=http://www.cheapjersey2store.com/]Wholesale cheap jerseys[/url]Cheap mlb jerseys
[url= http://www.cheapjersey2store.com/]2012 mlb all atar jerseys[/url]
[url= http://www.cheapjersey2store.com/ [/url]Cheap China Wholesael[/url]
[url= http://www.cheapjersey2store.com/]Wholesale jerseys From China[/url]
[url=http://www.cheapjersey2store.com/]2012 nike nfl Jerseys[/url]Free Shipping,Cheap Price,7 Days Deliver
[/pre]
[/pre]
We are professional jerseys manufacturer from china,wholesal
sports [url= http://www.cheapjersey2store.com/]Jerseys From China[/url]
[url=http://www.cheapjersey2store.com/NFL-Jerseys-c68]NFL jerseys China[/url]
[url=http://www.cheapjersey2store.com/NHL-Jerseys-c96/]NHL Jerseys China[/url]
[url=http://www.cheapjersey2store.com/NBA-Jerseys-c77/]NBA Jerseys China[/url]
[url=http://www.cheapjersey2store.com/MLB-Jerseys-c94/]MLB Jerseys China[/url]
[url= http://www.cheapjersey2store.com/]China Jerseys[/url],Free Shipping
[/pre]
[/pre]
We are professional jerseys manufacturer from china,wholesal
sports [url= http://www.jerseycaptain.com/]cheap jerseys sale online [/url]
[url= http://www.jerseycaptain.com/]2012 nike nfl Jerseys[/url]
[url=http://www.jerseycaptain.com/NFL-Jerseys-c68]cheap NFL jerseys China[/url]
[url=http://www.jerseycaptain.com/NHL-Jerseys-c96/]NHL Jerseys C
Title: Classic asp rocks always   
Name: HariFinhead
Date: 2011-01-10 2:12:29 AM
Comment:
Classic asp always rocks in many manufacturing company still now.. even .net has came..
Title: mike   
Name: getyoid@yahoo.com
Date: 2010-12-22 6:34:55 AM
Comment:
"I strongly recommend you jump to ASP.NET instead."

Honestly, dot net blows. ASP is so much nicer.
Title: Much Easier Thank I Thought   
Name: SQLTutorials
Date: 2010-11-10 11:08:39 AM
Comment:
Much Easier Thank I Thought. Thanks a lot.
Title: Other self hosting solutions   
Name: mer
Date: 2010-05-10 1:35:23 PM
Comment:
There better solutions than Cassini if you need to host your ASP.NET apps without IIS. Cassini has some big drawbacks - doesn't allow connections to WCF except for localhost, security issues surrounding the account that the process must run under, and most importantly lack of SSL and logging features.

Other solutions:

http://www.neokernel.com - a commercial embeddable ASP.NET web server with SSL and logging

http://www.ultidev.com - a commercial version of Cassini with an installer

http://cassinidev.codeplex.com - another fork of the cassini source
Title: Hi   
Name: Prashanth
Date: 2009-04-06 8:16:46 AM
Comment:
It was very useful for giving some good information on ADO for the beginners
Title: nbp   
Name: www
Date: 2008-05-17 3:32:07 PM
Comment:
query of searching data in sqlserver with use of asp.net
Title: swd   
Name: www
Date: 2008-04-29 6:06:09 AM
Comment:
sweet.............
Title: Hi...   
Name: Hann
Date: 2007-03-20 9:49:00 AM
Comment:
Can U tell me how to connect MDB file in other host..?

Plizz, Send your reply to
hann21@linuxmail.org


Thanx
Title: hi   
Name: Paapu
Date: 2007-01-23 1:51:19 AM
Comment:
Its very useful, but still u can add some details also..
Title: hll   
Name: pat
Date: 2006-11-17 5:45:08 AM
Comment:
hello thanks a bunch but i guess i need more help
Title: DotNetSpace   
Name: Simple way to handle exception in database connections
Date: 2006-10-26 1:59:35 PM
Comment:
This is a simple way to handle exceptions when using database queries. This link includes an example:

http://www.dotnetspace.com/index.php?option=com_content&task=view&id=19&Itemid=26
Title: DotNetSpace   
Name: DotNetSpace query database connection example
Date: 2006-10-26 1:58:44 PM
Comment:
Shows a simple way to handle exceptions when using database queries. This link includes the example.
Title: use of loks in asp   
Name: praveen
Date: 2006-07-11 9:56:53 AM
Comment:
Hi

Please provide me the information about locks.
Title: asp stuff   
Name: dhvanil
Date: 2006-04-06 10:12:35 AM
Comment:
hi
your site is good
put some examples of every methods
Title: webmaster   
Name: Yusef Jeffries-El
Date: 2006-01-15 1:10:43 AM
Comment:
I just needed a quick reference to the syntax of the INSERT INTO statement using Visual Basic
Title: hi   
Name: vishal
Date: 2005-06-03 10:17:27 AM
Comment:
vishal patel your site is so genious but add the download button on every page






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-12-05 6:06:04 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search