By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,671 Members | 1,567 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,671 IT Pros & Developers. It's quick & easy.

Redirecting to another db.

P: n/a
MA
Hi all!

Im building an asp.net application and want to use a login for this.

I was thinking about using a separate database for user identification and
then redirect to a different database, depending on the user information.

Lets say that user1 shoul be redirected to company1 database and user2 to
company2 database, still using the same application.

How to do this in an easy way?
Any ideas and comments are welcome.

/Marre
Nov 16 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If the database connection strings are fairly static, maybe you could store
them (encrypted) in the user identification database and when the user logs
on, you extract their specific connection string and use that throughout
their session.
You don't really need to 'redirect' databases, just change the connection
string to access them.

"MA" <news@.removethis.supremelink.se> wrote in message
news:38*************@individual.net...
Hi all!

Im building an asp.net application and want to use a login for this.

I was thinking about using a separate database for user identification and
then redirect to a different database, depending on the user information.

Lets say that user1 shoul be redirected to company1 database and user2 to
company2 database, still using the same application.

How to do this in an easy way?
Any ideas and comments are welcome.

/Marre

Nov 16 '05 #2

P: n/a
MA
Ok!

How do I do this without a security issue?

Can I use session to do this?

/Marre

"Cole Trickle" <co************@hotmail.com> wrote in message
news:d0******************@news.demon.co.uk...
If the database connection strings are fairly static, maybe you could
store them (encrypted) in the user identification database and when the
user logs on, you extract their specific connection string and use that
throughout their session.
You don't really need to 'redirect' databases, just change the connection
string to access them.

"MA" <news@.removethis.supremelink.se> wrote in message
news:38*************@individual.net...
Hi all!

Im building an asp.net application and want to use a login for this.

I was thinking about using a separate database for user identification
and then redirect to a different database, depending on the user
information.

Lets say that user1 shoul be redirected to company1 database and user2 to
company2 database, still using the same application.

How to do this in an easy way?
Any ideas and comments are welcome.

/Marre


Nov 16 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.