Dave,
To test whether you are losing the variable you could try something
like this:
<@IFEMPTY "<@var user$odbc>">
<@LOGMESSAGE MESSAGE="Empty odbc datasource in <@APPFILE>"
TYPE="EVENT">
</@IF>
If you put this test in your header and footer you can see if the
variable is disappearing before or during the execution of the taf.
Witango Support
On 17/01/2006, at 10:00 AM, Dave Machin wrote:
The ODBC data source is user dependent. We have all kinds of
people taking
surveys on the same web server, but we connect each person to the
right
database based on the initial path used to launch our .taf
application. The
paths are virtual folders in IIS, all pointing to the same place.
So, if
you take a survey from xxx.yyy.com/aaa/survey.taf you connect to
the aaa
database and xxx.yyy.com/bbb/survey.taf goes to the bbb database -
but each
actually uses the same .taf file.
All the data source connections use the same user name and password.
----- Original Message -----
From: "Ben Johansen" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, January 16, 2006 2:24 PM
Subject: RE: Witango-Talk: Strange ODBC Problem
Hi Dave
I noticed that you are using the @@ there are times this can be
unreliable,
this might be one of those times
(ODBC, @@user$odbc, name, password)
You might want to try <@var user$odbc encoding="none">
Also, it seems strange that you are using the USER scope for this.
This
means that if the var timeout hit then there is no value there for
odbc so
then it might use the next avail connection. Shouldn't this be a
domain or
application scope?
Another question: are you using different users for the different
databases?
Ben
-----Original Message-----
From: Dave Machin [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 12, 2006 3:35 PM
To: [email protected]
Cc: [EMAIL PROTECTED]
Subject: Witango-Talk: Strange ODBC Problem
We're trying to track down a strange database problem
We're having a few occurrences where a query seems to executing
against
the
wrong ODBC connection. We're using a variable for our ODBC name
in the
DataSource. What seems to happen is that sometimes the query
executes
against the ODBC listed as the development data source instead of the
deployment data source (which uses the variable).
The set deployment data source checkbox is checked. Then
"specify" radio
button is selected. Then "same as development" is unchecked and
the form
filled in (ODBC, @@user$odbc, name, password).
This seems to happen very seldom, maybe one or two transactions
per day
(out
of 400 to 500 thousand page requests, each with several database
queries
in
them).
The .taf file doesn't have any aberrant "!CST" entries in it. The
query
in
question is a drag-and-drop search action.
We're running Witango 5.5.009 on Windows 2000 against MS-SQL
database.
Anyone have a problem like this?
Dave Machin
[EMAIL PROTECTED]
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
