Where are you keeping your application.cfm? What directory?
-----Original Message-----
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 3:34 AM
To: CF-Talk
Subject: Databases
Hi All,
We have two ODBC connctions one is to the Test DB (ocsdb_test) and other is
to the live DB (ocsdb_live).
In my Application.cfm I have a variable set up to look at the relevant
source,
When I'm testing amendments before placing them in the live system,
occaisonally I pick up data from the live system, and clients are
occaisionally updating the test Database.
When I check the Server Logs, I notice the following message in the
Application.log, this is also happening with Sites.
More than one data source used in a CFTRANSACTION
The use of multiple data sources (or multiple username/password attributes
for a single data source) within a CFTRANSACTION is not permitted. You have
attempted to submit an SQL statement to the data source 'OCSDB_LIVE' while
you have a transaction open for the data source 'OCSDB_TEST'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (79:7) to
(79:94).</p><P><P>Date/Time: 02/21/01 11:05:48
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)<BR>Remote
Address: 200.10.5.2
HTTP Referer:
nxhqocs.nationalexpress.co.uk/ocs/main/OCS_Main.cfm?Departed=0"
This is from a live client, The Test system is so theres no chance of it
picking up the Application.cfm from the test directory.
nxhqocs.nationalexpress.co.uk/ocstest/main/OCS_Main.cfm?Departed=0"
All advice and help will be appreciated. As a tempory measure I've removed
the ODBC connector to the TEST Database.
Jason Lees
National Express
Email : [EMAIL PROTECTED]
###################################################
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609
6301
and delete all records of the message from your computer. Any form of
reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [EMAIL PROTECTED]
####################################################
##################################################
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
