thank's it can be a solution. do i have to just delete/change the aplication.cfm to connect to the database access back ?
i thougth there was another solution as told my host server administrator. (<cf qurey datasource="c:/path/***.mdb>) that could make the administrator not to create a dns (it's a lazzy guy) but it could be a good solution thank's lje ----- Original Message ----- From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 19, 2002 4:26 PM Subject: RE: direct acces to ms access without dns > You could try unlocking the database instead of shutting down the > server. > > Put something like this at the top of your application.cfm > > <!--- > The site is temporarily down for maintenance. > <cfset CFUSION_DBCONNECTIONS_FLUSH()> > <cfabort> > ---> > > Then just uncomment that whenever you want to work on your dbase. > > ______________________ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > > -----Original Message----- > From: loic jegouzo [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 19, 2002 10:15 AM > To: CF-Talk > 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
