Thanks for the advice - we didn't know about the <@logmessage> tag - we'll add that in.
On the other hand, the if data source variable is empty an error is logged anyway, along the lines of "data source name not found" or something - and we're not seeing that. ----- Original Message ----- From: "Customer Support" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, January 16, 2006 4:22 PM Subject: Re: Witango-Talk: Strange ODBC Problem > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
