Is there a performance/reliability difference between the two?
Pete
----- Original Message -----
From: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 19, 2002 11:13 AM
Subject: RE: direct acces to ms access without dns
> Actually, that way uses OLEDB, if you want use the access drivers (with
> CF5), do something like this.
>
> <cfset Request.connectString =
> "Driver={Microsoft Access Driver (*.mdb)};
> Dbq=dbasename.mdb;
> DefaultDir=c:\absolutepath\;
> Uid=;
> Pwd=;">
>
> <cfquery name="foo" dbtype="dynamic"
> connectstring="#Request.connectString#">
>
> ______________________
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -----Original Message-----
> From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 19, 2002 10:48 AM
> To: CF-Talk
> Subject: Re: direct acces to ms access without dns
>
>
> I set a variable called request.dbLoc in application.cfm:
> <cfset request.dbLoc =
> "C:\inetpub\virtual_servers\wherever.com\datasources\wherever.mdb">
>
> The query looks like this:
> <cfquery name="getReviewCount" datasource="#REQUEST.dbLoc#"
> dbtype="OLEDB"
> provider="Microsoft.Jet.OLEDB.4.0" providerdsn="#REQUEST.dbLoc#"
> username="admin" password="">
> SELECT ID FROM tblTransactions
> </cfquery>
>
> Pete
>
> ----- Original Message -----
> From: "loic jegouzo" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 19, 2002 10:14 AM
> Subject: direct acces to ms access without dns
>
>
> > hello,
> >
> >
> > i would like to make a direct link with an access database. this
> because
> > when i have to modify my database i must stop the site with my host to
> > update. i tried <cfquery datasource="c:\mypath\mydbname.mdb"> but i
> have
> an
> > odbc error
> > (the database is defined in cfserver)
> >
> > do you know wich is the good syntax ?
> >
> >
> > lje
> >
>
>
______________________________________________________________________
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
