Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: Web
Expertise: All
Jul 21, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Put Connection String in Application Variable

When you build a database driven Web site, virtually all Web pages need to connect to your database. You can copy and paste the same code that opens an ADO connection on each page, but that becomes a nightmare to maintain when you need to move from a development environment to a production environment. To ease such situations, you can store the connection string in an ASP application variable during the on_start event (inside your global.asa file). This ensures that the connection string will be available to all your Web pages throughout the lifetime of the Web application. To change to your production database, simply change the connection string in one place, and all your Web pages will be updated. For example, you can put this code in your global.asa file:

Sub Application_OnStart
  Application("con") = "Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=pubs;User ID=sa "	
End Sub

To open a database connection from each Web page, use this code:

Dim con
Set con = Server.CreateObject("ADODB.Connection")
con.open Application("con")
William Wen
Comment and Contribute






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



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