Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Web Development
Expertise: Beginner
Jan 20, 1999

Designing a Web Page That Accesses a Database

Question:
I am trying to create a site that will take user input via forms, query a database, and return results to the user. I've been reading a ton of HTML books and have learned how to create forms, but I want to know how to get them to interact with my Microsoft Access database. Is there an easy way to connect my Web site with Microsoft Access?

Answer:
The ability to access a database via the Web must be supported by the Web server software that you are using. If your Web server software is Internet Information Server (IIS) 3.0 (with Active Server Pages and ActiveX Data Objects installed) or IIS 4.0, you can use Active Server Pages to connect to your database easily.

The following code assumes that you have set up an ODBC data source name (DSN) called MyAccessDatbase in the Windows Control Panel applet. Keep in mind that this is not the only way to get to the data—each method has its pros and cons. This particular code is very short and easy to read and understand, but becomes less efficient the more times it is called in a single instance of an application.

Const adOpenKeyset = 1
Const adLockOptimistic = 3
  
Set rs = Server.CreateObject ("ADODB.Recordset")
rs.Open "Select * from students", "DSN=MyAccessDatbase;UID=Admin;PWD", _
	adOpenKeyset, adLockOptimistic
 
After this code executes, you will have a recordset that you can use to put data on your Web page. You can access the individual fields in a recordset using the following syntax.
rs("MyField1")
rs("MyField2")
This code should enable you to retrieve data from a database into your Web page. Happy coding!
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date