RE: Remote DB Alteration
I've been using this linking external databases method with Access (rather than futz with creating a bad query to try and break the lock) and it works great, but there's a caveat. If you're making the mods locally on your development box and then uploading to a remote server, you need to ensure that the physical file path to where the Access .mdb file is stored on the remote server is mirrored on your develpment box. Apparently Access stores the path when a link to an external .mdb is made, so they need to be the same on both sites (remote and development). For example, if your .mdb file is stored on your remote server at e:/web/mydomain/mydata/, then you will need to have your Access databases for your site stored in this same directory on your development machine. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner NetObjects Reseller 210-490-3249/888-745-7603Fax 210-490-4692 -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 08, 2000 12:33 PM To: CF-Talk Subject: RE: Remote DB Alteration Assuming you are using MSAccess: Create an empty DB and create linked tables that point to the tables in your real DB. The ODBC connection can remain open, and you can upload a new DB at any time by overwriting the real DB. This works as long as you don't add any tables - you'll still have to modify the DB with the linked tables. The other route is to talk the host into turning off "Maintain database connections" in the CF Administrator for your ODBC source. That's the dealy that's locking your file. Good luck! Jeff Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Remote DB Alteration
Hello CF'ers Situation: Database and sites hosted externally, site created internally. Currently if any changes to the datasource's structure are made they are made locally and then uploaded to the host, who has to shut off the CFServer and restart it. This requires scheduling a time and is unacceptable. Also, the uploaded datasource may corrupt/overwrite the data as it is not up to date. Employer will not spring for extra datasources to be hosted. ( multiple applications and domains, one datasource, yay! ;) ) Goal: To be able to add tables to the datasource without scheduling a shutdown and uploading entire datasource. Resources: MS Access 97 CF 4.5 CuteFTP Budget =$0 Is this possible? Please direct me to resources that will show me how. Also, anyone know what the 20 or so CFML tags supported by CFExpress are? Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out the fresh new look of www.OFAH.org Launched 1st November 2000. Don't forget our other great sites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Remote DB Alteration
You can use SQL statements to update, create, and modify tables. Also you can open up the Access file and modify it if you open it on the actual server the file sits on. I don't recommend it though. Your chances of getting corruption probably double. Dave Livingston General Bandwidth [EMAIL PROTECTED] -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 08, 2000 10:15 AM To: CF-Talk Subject: Remote DB Alteration Hello CF'ers Situation: Database and sites hosted externally, site created internally. Currently if any changes to the datasource's structure are made they are made locally and then uploaded to the host, who has to shut off the CFServer and restart it. This requires scheduling a time and is unacceptable. Also, the uploaded datasource may corrupt/overwrite the data as it is not up to date. Employer will not spring for extra datasources to be hosted. ( multiple applications and domains, one datasource, yay! ;) ) Goal: To be able to add tables to the datasource without scheduling a shutdown and uploading entire datasource. Resources: MS Access 97 CF 4.5 CuteFTP Budget =$0 Is this possible? Please direct me to resources that will show me how. Also, anyone know what the 20 or so CFML tags supported by CFExpress are? Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out the fresh new look of www.OFAH.org Launched 1st November 2000. Don't forget our other great sites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Remote DB Alteration
Guy, While I am still too much of a newbie to offer any real suggestion to your dilemma, I must praise you on your ability to ask the question effectively, and provide answers to the inevitable questions regarding your resources! Tim Tim Claremont Xerox Corporation -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 08, 2000 11:15 AM To: CF-Talk Subject: Remote DB Alteration Hello CF'ers Situation: Database and sites hosted externally, site created internally. Currently if any changes to the datasource's structure are made they are made locally and then uploaded to the host, who has to shut off the CFServer and restart it. This requires scheduling a time and is unacceptable. Also, the uploaded datasource may corrupt/overwrite the data as it is not up to date. Employer will not spring for extra datasources to be hosted. ( multiple applications and domains, one datasource, yay! ;) ) Goal: To be able to add tables to the datasource without scheduling a shutdown and uploading entire datasource. Resources: MS Access 97 CF 4.5 CuteFTP Budget =$0 Is this possible? Please direct me to resources that will show me how. Also, anyone know what the 20 or so CFML tags supported by CFExpress are? Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out the fresh new look of www.OFAH.org Launched 1st November 2000. Don't forget our other great sites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Remote DB Alteration
On 11/8/00, Guy J. McDowell penned: Situation: Database and sites hosted externally, site created internally. Currently if any changes to the datasource's structure are made they are made locally and then uploaded to the host, who has to shut off the CFServer and restart it. Why? They shouldn't have to restart CF just to overwrite a datasource. If it's because of the database lock placed by Access, you have 2 options. Have the host turn off "Maintain database connections" to the datasource in cf administration. You should do this with Access anyway. Or, you can write a bad query. CFQUERY DATASOURCE="your_datasource" NAME="breakodbclock" SELECT nota FROM nothing /CFQUERY This will return an error and break the lock on the database and you can upload right over it. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Remote DB Alteration
Assuming you are using MSAccess: Create an empty DB and create linked tables that point to the tables in your real DB. The ODBC connection can remain open, and you can upload a new DB at any time by overwriting the real DB. This works as long as you don't add any tables - you'll still have to modify the DB with the linked tables. The other route is to talk the host into turning off "Maintain database connections" in the CF Administrator for your ODBC source. That's the dealy that's locking your file. Good luck! Jeff -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 08, 2000 11:15 AM To: CF-Talk Subject: Remote DB Alteration Hello CF'ers Situation: Database and sites hosted externally, site created internally. Currently if any changes to the datasource's structure are made they are made locally and then uploaded to the host, who has to shut off the CFServer and restart it. This requires scheduling a time and is unacceptable. Also, the uploaded datasource may corrupt/overwrite the data as it is not up to date. Employer will not spring for extra datasources to be hosted. ( multiple applications and domains, one datasource, yay! ;) ) Goal: To be able to add tables to the datasource without scheduling a shutdown and uploading entire datasource. Resources: MS Access 97 CF 4.5 CuteFTP Budget =$0 Is this possible? Please direct me to resources that will show me how. Also, anyone know what the 20 or so CFML tags supported by CFExpress are? Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out the fresh new look of www.OFAH.org Launched 1st November 2000. Don't forget our other great sites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Remote DB Alteration
"Guy J. McDowell" To: CF-Talk [EMAIL PROTECTED] ofah_webmastercc: @ofah.org Subject: Remote DB Alteration 11/08/2000 10:14 AM Please respond to cf-talk Also, anyone know what the 20 or so CFML tags supported by CFExpress are? === CFABORT, CFAPPLICATION, CFBREAK, CFCOOKIE, CFIF/CFELSIF/CFELSE, CFINCLUDE, CFINSERT, CFLOCATION, CFLOOP, CFOUTPUT, CFPARAM, CFQUERY, CFSET, CFSETTING, CFSWITCH/CFCASE/CFDEFAULTCASE, CFUPDATE Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Remote DB Alteration
Why can you not upload your Access file? If it is giving you a "file locked" error, you can kill the lock by throwing a query at it that causes an error, then upload the file. -- Billy Cravens [EMAIL PROTECTED] "Guy J. McDowell" wrote: Hello CF'ers Situation: Database and sites hosted externally, site created internally. Currently if any changes to the datasource's structure are made they are made locally and then uploaded to the host, who has to shut off the CFServer and restart it. This requires scheduling a time and is unacceptable. Also, the uploaded datasource may corrupt/overwrite the data as it is not up to date. Employer will not spring for extra datasources to be hosted. ( multiple applications and domains, one datasource, yay! ;) ) Goal: To be able to add tables to the datasource without scheduling a shutdown and uploading entire datasource. Resources: MS Access 97 CF 4.5 CuteFTP Budget =$0 Is this possible? Please direct me to resources that will show me how. Also, anyone know what the 20 or so CFML tags supported by CFExpress are? Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out the fresh new look of www.OFAH.org Launched 1st November 2000. Don't forget our other great sites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
