Todd,
Are these Access databases? I've seen this in Access before.
If it is a real RDMS, I would give each client their own table, or common
tables with queries that are keyed off their ID, or individual views.
Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com
-----Original Message-----
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 9:56 AM
To: [EMAIL PROTECTED]
Subject: Re: DSNless connections
First off, I was just curious, since I know it can be done in ASP quite
easily.
Secondly, it's hard to explain, but we are going to be having many, many
people logging into a single web application. Each company/individual
account will have their own individualized database that will be accessed
based on their login info. i.e.: the system will know what database to give
them access to based on who they are.
Since we could very easily have several hundred databases on one machine, I
was under the impression that it would be faster and easier on the server to
connect to the DBs directly rather than having to deal with DSNs. It would
also be easier on the maintenance side. To create new databases, all we
would have to do is manipulate file names rather than registry entries.
... or is my thinking way off here?
Also, do you know a good source of information for creating the wrappers
like you mentioned? This is more of a proof of concept, than anything.
Thanks,
Todd Ashworth
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 28, 2000 9:23 AM
Subject: RE: DSNless connections
> You could create a "wrapper" in Java or C++ (or even VB for that matter)
and
> use it to pass your SQL to the db. I'm curious- what's the need for a
> dsnless connection?
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
