FrontPage Database Names

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

FrontPage Database Names

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> FrontPage Database Names

Page: [1]


A1234 Posts: 101 Joined: 10/7/2004 Status: offline	FrontPage Database Names - 6/24/2005 13:43:34 I have many databases on my site. While creating a search page, I am asked to choose the database to connect to. However, the database names in the list are Database1, Database2, Database3, etc. How can I apply actual names to the databases, such as "employees database", "employers database", etc., so that it will be easier to select the database to pull from?


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: FrontPage Database Names - 6/24/2005 14:10:37 Are you using the DRW? If so, it will be a little work - not a tremendous amount but a little. You'll have to change the name of the database as well as alter the global.asa file. (Sound's scary doesn't it? It's not) 1. Make a backup first. 2. Rename Database1.mdb to employees.mdb (or whatever is appropriate). 3. Open the global.asa file with a text editor and change "Database1" to "empolyees" where applicable. This: '--Project Data Connection Application("Database1_ConnectionString") = "DRIVER={Microsoft Access Driver (.mdb)};DBQ=URL=fpdb/Database1.mdb" FrontPage_UrlVars(1) = "Database1_ConnectionString" Application("Database1_ConnectionTimeout") = 15 Application("Database1_CommandTimeout") = 30 Application("Database1_CursorLocation") = 3 Application("Database1_RuntimeUserName") = "" Application("Database1_RuntimePassword") = "" becomes this: '--Project Data Connection Application("employees_ConnectionString") = "DRIVER={Microsoft Access Driver (.mdb)};DBQ=URL=fpdb/employees.mdb" FrontPage_UrlVars(1) = "employees_ConnectionString" Application("employees_ConnectionTimeout") = 15 Application("employees_CommandTimeout") = 30 Application("employees_CursorLocation") = 3 Application("employees_RuntimeUserName") = "" Application("employees_RuntimePassword") = "" Save the file and test the connection. NOTE: You WILL have to go back and change any DRW's that use that connection. Rinse and repeat. Just be sure the name of the .mdb file is correct and that all the other changes use the exact same wording. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to A1234)


A1234 Posts: 101 Joined: 10/7/2004 Status: offline	RE: FrontPage Database Names - 6/24/2005 16:59:25 So thats what the global.asa file is for. I've never peeked inside there before, but seems theres quite a bit of info hidin in there. Anyway that did the trick..thanks for your help (again)! (in reply to rdouglass)