Not sure if this will work in Sybase but...
You could create one datasource to a master DB and then you could do
something like this:
<cfquery name="GetUserInfo" datasource="MyBigDSource">
SELECT *
FROM #username#.dbo.Table
</cfquery>
When you query the master DB just omit the #username#.dbo.
does this make sense?
At 09:56 AM 3/29/2000 -0500, you wrote:
>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.
--
Nick McClure [EMAIL PROTECTED]
Technical Director 606.245.9656
squareFish Media www.squareFish.com
------------------------------------------------------------------------------
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.
