One ASP Site...Multiple Databases

[Mike Hill]

I am developing an ASP Program that will be used by many people. I only want
to have one site but have each person have their own database that the site
runs from.

For example:
Person 1 Database = dbp1
Person 2 Database = dbp2
Person 3 Database = dbp3

I have a 'common' dbase that contains the user and the dbase they are to
use. When they log in I need to associate their dbase with them, in a
session variable perhaps?

What would be the best way to do this?

Thanks,

Mike

[Jeff Cochran]

On Thu, 15 Apr 2004 11:17:25 -0600, "Mike Hill"
<mhill7272(at)hotmail.com> wrote:

>I am developing an ASP Program that will be used by many people. I only want
>to have one site but have each person have their own database that the site
>runs from.
>
>For example:
> Person 1 Database = dbp1
> Person 2 Database = dbp2
> Person 3 Database = dbp3
>
>I have a 'common' dbase that contains the user and the dbase they are to
>use. When they log in I need to associate their dbase with them, in a
>session variable perhaps?
>
>What would be the best way to do this?

One database with information for multiple users, but you don't give
any information on what the database contains or why you think you
need sepaarte ones.

If you definitely need them as separate, you need to authenticate the
user and assign a connection based on the user.

Jeff

[Aaron Bertrand [MVP]]

>I am developing an ASP Program that will be used by many people. I only

>want
> to have one site but have each person have their own database that the
> site
> runs from.

Why? Could you explain further please?

From what you've described so far, I don't see the need for more than one
table, never mind more than one database.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[J. Baute]

"Mike Hill" <mhill7272(at)hotmail.com> wrote in message
news:uwa6F2wIEHA.3432@tk2msftngp13.phx.gbl...

> I am developing an ASP Program that will be used by many people. I only

want

> to have one site but have each person have their own database that the

site

> runs from.
>
> For example:
> Person 1 Database = dbp1
> Person 2 Database = dbp2
> Person 3 Database = dbp3
>
> I have a 'common' dbase that contains the user and the dbase they are to
> use. When they log in I need to associate their dbase with them, in a
> session variable perhaps?
>
> What would be the best way to do this?

In ASP it's always a good idea to create your database connection when you
need it, and close it asap afterwards, leaving it open as short as possible.
Storing ADO connection objects in the ASP session object is a no-no.

So what I would do is determine the database per user when the users session
is created (Session_onStart event in global.asa), and store the connection
string in the session. Whenever you need to connect to the user-specific
database in your pages, use this connection string.