Yep Jason
-----Original Message----- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 6:55 PM To: CF-Talk Subject: Re: DNS-Less Access (Whoops! DSN-Less) 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
