This is only for CF 5, right?
Thanks!
----- Original Message -----
From: "Jason Larson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 07, 2002 5:15 PM
Subject: RE: DNS-Less Access
> Try this out:
>
> <cfset MyConnectionString = "Driver={Microsoft Access Driver
> (*.mdb)};Dbq=MyDatabase.mdb;DefaultDir=D:\path2files\;Uid=Admin;
> Pwd=Password;">
>
> Changing the "MyDataBase.mdb" to the name of your database file, then
> "D:\path2files\" text to the path on the server to your file, and
> finally the username and password if your database is password protected
> (this one is optional, if not leave as is!). I suggest that you specify
> this in your application.cfm is you will need this throughout your
> website, otherwise leave it on the same page as the where the <cfquery>
> tag will call for it.
>
> The next change needed is to alter the <cfquery> tag a little different
> than usual. there is a value that you always pass in <cfquery> that is
> titled datasource="".... this will be absent as you are not really
> connecting to a datasource, but instead an actual direct database
> connection. Below you see a working example of the modified, faster
> working <cfquery> tag.
>
> <cfquery name="GetExample" connectstring="#MyConnectionString#"
> dbtype="DYNAMIC"> Select * From tablename Order by fieldname </cfquery>
>
> That's it, this is the best example I could possibly give you on how to
> use a dynamic <cfquery> connection.
>
>
> Jason
>
>
> -----Original Message-----
> From: Scott Van Vliet [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 07, 2002 3:43 PM
> To: CF-Talk
> Subject: DNS-Less Access
>
> Does anyone out there know how to connect to an Access database without
> a
> DSN? (For both CF 4.5 and CF 5)
>
> TIA!
>
>
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
