CyberArmy University | Open Source Institute | CyberArmy Intelligence & Security | CyberArmy Services & Projects

[Library Index]

[View category: Networking] [Discuss Article]

CAU KB presents: ASP Database Connectivity

Article is yet to be rated
Author:      Rae
Submitted:      01-Jan-1970 01:00:00
Imported From:      zZine (original author: Rae)


CAU KB presents: ASP Database Connectivity
If you want to learn how to connect ASP databases on a Windows machine running IIS and PWS, this article is meant for you. It is meant for the intermediate programmer who already knows how to get the technological environment up and running. But this doesn't mean you have to be an ASP whiz. The article provides a lucid step-by step explanation of how you go about generating dynamic web pages, detailed to the last click. Here's an excerpt from the article to let you have a sneak peak and to prove that I'm telling the truth!

"The next step involves making an ODBC connection. ODBC stands for Open DataBase Connectivity, and is a set of vendor independent drivers to connect databases to application programming languages. To make the connection, go to the control panel and click on the icon called '32 Bit ODBC' if you are using Microsoft Windows Me/9x. If you are using Windows XP, go to 'Administrative Tools' and then 'Data Sources (ODBC)'. In the window that opens up, click on the 'File DSN' tab on the top. In case you are wondering what DNS stands for, it?s 'Data Source Name'. Now click 'Add' and then select "Microsoft Access Driver (*.mdb)". Save this DSN somewhere on your hard disk, give it a descriptive name like 'trialdsn.dsn'. Then all that is left in this step is to select the database to which you'd like to connect using this DSN. Select the Access database that you created earlier in this article."

The article teaches you how to design your database (in Microsoft Access) for using in your ASP code. This is followed by how to set up an ODBC connection and finally the time saving ASP code. You'll also find a useful list of references at the end of the article if you want to search for more information. So, what are you waiting for? Go on and read it directly on CAUniversity Knowledge Bank!

This article was originally published by CyberArmy.net in the CyberArmy Library.

You must be logged in to vote on an article

About Us | Privacy Policy | Mission Statement | Help