Using differant SQL database for differant users

[Kevin Spencer]

You're talking about a custom ASP web application now. Time to put on your
student hat and study up on ASP.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Expect the unaccepted.

 

[Jonathan Blitz]

I have a site which connects to an SQL Server database.
Is it possible to have the site dynamically change the database so that
differant users will see differant data?

This way I don't have to replicate my site just to serve a differant set of
users.
i cannot save the data in the same database for orginisational reasons.

Jonathan Blitz

 

[Jonathan Blitz]

Absolutely. I am talking about ASP but I have only be using the built in FP
Database funtions rather than writing the whole thing myself.
Since the code is all built I would rather not have to re-write it all.

Is there no way to use the FP built SQL commands and just use ASP to change
the connection?

Jonathan

 

[Kevin Spencer]

Is there no way to use the FP built SQL commands and just use ASP to

change
the connection?

If there was, I would have told you how.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Expect the unaccepted.