Doesn't that work great except for the fact that you would
have to have the password to the DB in your code? Bugs like
the .HTA bug have kept me from ever putting a database login
in my code.
John McKown, VP Business Services
Delaware.Net, Inc.
30 Old Rudnick Lane, Suite 200 Dover, DE 19901
email: [EMAIL PROTECTED]
phone: 302-736-5515
fax: 302-736-5945
icq: 1812513
> -----Original Message-----
> From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 9:29 AM
> To: CF-Talk
> Subject: RE: To ASP or not to ASP
>
>
> For SQL just fill in all the available attributes in <cfquery> and use
> SQLOLEDB for the provider. I use OLEDB for data connections all the time
> and have never set one up in cf admin.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> ICQ #: 916324
>
> ----Original Message Follows----
> From: Andy Ewings <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: RE: To ASP or not to ASP
> Date: Thu, 22 Mar 2001 12:01:21 -0000
>
> Appologies for the last mail....fell asleep on my keyboard and accidently
> hit the send key....what I was going to say was......
>
> This works ok for file based db's but wot about SQL?......
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> ------------------------------------------------------------------
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> ------------------------------------------------------------------
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> ------------------------------------------------------------------
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy,
> distribute, or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
> -----Original Message-----
> From: Zachary S. Bedell [mailto:[EMAIL PROTECTED]]
> Sent: 21 March 2001 22:21
> To: CF-Talk
> Subject: RE: To ASP or not to ASP
>
>
>
> -----Original Message-----
> From: Zachary S. Bedell
> Sent: Wednesday, March 21, 2001 12:22 PM
> To: CF-Talk
> Subject: RE: To ASP or not to ASP
>
>
>
> -> Examples?? Very interested in this.....
> ->
> -> "I have used dynamic OLEDB database connections many times
> -> with 4.0 and 4.5.
> -> Don't have to have a connection set up on the server even now.
>
> Take two....
>
> Sorry about spamming list twice... Seems my PGP got hungry & ate my CF
> tags... Still learning V7.0... Anyways, here's the example I was
> trying to send the first time:
>
>
> This works quite nicely on many apps I've written:
>
> <cfset DB = "C:\InetPub\ServerChecklist.mdb">
>
> <cfquery name="CheckLogin" datasource="#DB#" dbtype="OLEDB"
> provider="Microsoft.Jet.OLEDB.4.0" providerdsn="#DB#" username="Admin"
> password="">
> SELECT Blah...
> </cfquery>
>
> Best regards,
> Zac Bedell
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
