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
>
______________________________________________________________________
Get Your Own 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=coldfusionb
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
