RE: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread Robert Shubert
The MDAC services does contain libraries which I believe are 'leaned' on by the Witango ODBC system. I believe it could be beneficial to any system using MS's ODBC system, regardless of driver. However, the most benefit is going to be seen with MS SQL. Also, a note of warning to everyone reading t

RE: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread Fogelson, Steve
Gotta ask a dumb question. Would installing MDAC 2.8 help other db's like R:Base or does this just affect MS SQL? Thanks Steve Fogelson Internet Commerce Solutions -Original Message- From: Jason Pamental [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 7:51 PM To: [EMAIL PROTECTE

RE: Witango-Talk: problem with quote value and 5.5 server

2004-10-15 Thread Ben Johansen
Title: problem with quote value and 5.5 server Can you explain why you need the quotes when it is a char field? Have you tried the noSQLEncoding switch Around the update action   Ben From: Trevor Green [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 6:20 PM To: [EMAIL

Witango-Talk: problem with quote value and 5.5 server

2004-10-15 Thread Trevor Green
Title: problem with quote value and 5.5 server I have a problem with 5.5 on Mac OSX server and MySql. I have an update action with a field which is has the Quote value attribute set to false. I am trying to update the field with the following _expression_ <@ifempty <@arg ownership>>null<@else>'

Re: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread Jason Pamental
Well, it's not scientific by any means, but (knocking on wood) since I installed the MDAC 2.8 updater I haven't had the service hang (8 hours so far). I'll keep you all posted on how it does over the next few days. Thanks for the tip Bob! Jason On Oct 15, 2004, at 6:50 PM, MC Tay wrote: We a

Re: Witango-Talk: Argument precedence

2004-10-15 Thread Scott Cadillac
Hi Bill, Actually, precendence isn't the issue in this case. What your code sample does, is it creates an "array" of argument values, so when you do <@ARG _arg> by itself, you're just seeing the first value in the array. Try: <@ASSIGN request$arg_array VALUE="<@ARG _arg TYPE=ARRAY>"> And you

Witango-Talk: Argument precedence

2004-10-15 Thread Bill Conlon
Consider a an appfile with the following resultshtml. Search Argument is <@searcharg _arg> POST Argument is <@postarg _arg> Any Argument is <@ARG _arg> Results: Search Argument is argument POST Argument is fooled you Any Argument is argument I don't recall a discussion of argument precedence,

Re: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread MC Tay
We are also experiencing similar behavior with WiTango 5.5 and Oracle 9i on Window 2003. The WiTango support does not have any answer to this at all and we are still trying to figure it out on our own. WiTango thread remains at 19 constantly. Our Oracle thread continues to grow slowly over time

Witango-Talk: SourceForge.net equivalent for Witango projects?

2004-10-15 Thread Anthony M. Humphreys
Is there a SourceForge.net type of repository for people who want to share and develop their Witango projects?   If so, where?   Anthony -     TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread Robert Shubert
The quick answer is yes, this can/does happen. Likely an issue in the ODBC connection routine, but I'm not positive. If you are not running 065 yet, get that, it's much better. I am hopeful that 5.5 will be better or at least handle the problem better. I'm not positive that Witango is 100% to blam

Re: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread John McGowan
My applications use @include in every hit to the server and I've never had a problem like the one you describe. /John Roland Dumas wrote: On 10/15/04 8:54 AM, "John McGowan" <[EMAIL PROTECTED]> wrote: Hold on... Why wouldn't you be caching application files or include files? I've never h

Re: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread Roland Dumas
On 10/15/04 8:54 AM, "John McGowan" <[EMAIL PROTECTED]> wrote: > Hold on... Why wouldn't you be caching application files or include > files? I've never heard of anybody not doing that in a production > environment. I'm on 5.0, but I ran into a strange behavior when caching tafs: IF one use

Re: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread John McGowan
Hold on... Why wouldn't you be caching application files or include files? I've never heard of anybody not doing that in a production environment. Does this server get a decent amount of traffic. If so, the problems could be that you *aren't* caching. Race conditions caused by different Wi

RE: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread David Shelley
You might try reducing the THREADPOOLSIZE. The optimal value is dependant on your hardware configuration and other what other processes are running on your server. A value as low as 5 to 10 may help. Dave Shelley -Original Message- From: Jason Pamental [mailto:[EMAIL PROTECTED] Sent: Fri

Re: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread Jason Pamental
No - it's not. Did you see the problem get better by clearing the cache more frequently? (I'm not caching files or included files, so I'm mainly thinking of the variable caches) On Oct 15, 2004, at 10:49 AM, John McGowan wrote: We are running this exact same environment in a few locations and

Re: Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread John McGowan
We are running this exact same environment in a few locations and the only problem we have with the Witango service hanging seem to be directly related to clearing the cache. However it does occasionally hang when a @purgecache was not done and right now i'm chalking that up another problem wi

Witango-Talk: Witango 5 / SQL Server 7

2004-10-15 Thread Jason Pamental
Hey everyone- Anyone out there using Witango 5 connecting to SQL Server 7? One of our clients' environment is Windows 2000/SQL Server 7/IIS/Witango 5, and we're still having odd issues with threads getting stuck seemingly on queries (different ones, not always the same) and then hanging the Wit