Login | Register   
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
Expertise: All
Jul 20, 1999

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.

 

 

Sitemap