using a 'connector' DSN.
The idea is, the system administrator simply creates a DNS named
'connector' in CFMX, which doesn't point to a database and doesn't
contain a user id or password. Then, users can use this connector to
connect to their databases by supplying that information inside their
query tag. EG:
<CFQUERY
NAME="MyQuery"
DATASOURCE="connector"
USERNAME="YourUserID"
PASSWORD="YourPassword">
SELECT *
FROM YourDatabase.YourTable
</CFQUERY>
This worked wonderfully with MySQL and CFMX.
Just an idea.
--
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
Matt Robertson wrote:
> You realize that support for these were dropped in CFMX, right? they
> are only available in CF 5?
>
> Interestingly, querying Macromedia.com's support area for variations
> on "dsn-less" comes up empty, except for this, a way to dummy-up a
> connection in MX using a different method. Look for the MSDN link
> within the article to see other connection examples to other db's.
>
> http://www.macromedia.com/support/coldfusion/ts/documents/dynamic_dsn_cfmx.htm
>
> Hope this helps a little at least,
>
> --
> --Matt Robertson--
> MSB Designs, Inc.
> mysecretbase.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
