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
