Don't set a password in CF ADMIN, but rather put it in your CFQUERY tag
itself. I have personally never had any success getting Access to use
passwords, but your mileage may vary. SQL Server, Oracle, etc. have all
worked fine for me.
DC
----- Original Message -----
From: "Jake Hileman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 30, 2000 13:53
Subject: Protecting A DSN/DB
> In a shared hosting environment with critical data, how can you be sure
> that
> your database(s) are not accessible by anyone else via CF, CFQUERY,
> etc?
> How can you password protect a DSN/DB so that data is not allowed to be
> pulled from the DB without supply the password in your code, etc... we
> don't
> want anyone quering our DB and getting our data do we? It seems like
> if
> they knew our DSN name, they could do pretty much whatever they wanted.
> :-)
>
> I've set the PW up in the ODBC setup of CF ADMIN but it still lets me
> query
> etc.. I've tried setting a password everywhere! :-)
>
>
> Thanks and let me know,
>
> By the way, I'm wondering how to do this with ACCESS2k.
>
> Jake
>
>
> ------------------------------------------------------------------------
> ------
> Archives: http://www.mail-archive.com/[email protected]/
> 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.mail-archive.com/[email protected]/
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.
