I agree with Robert. We have quite a few intermittent failures especially with Windows 2003 Server SP1+. It seems that threads get hung in Witango and the only way to clear them is by recycling the Application. We see this with MSSQL. Any long running queries / stored procedures seem to have the ability to hang a Witango thread.
-----Original Message----- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 2:09 AM To: [email protected] Subject: Re: Witango-Talk: Reliability of ODBC connections? ALSO, when witango is is under load with slow connections, it can hang, and crash, it is a witango killer also. I have shown this over much testing with several DB vendors. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Jan 22, 2007, at 6:33 PM, Customer Support wrote: > Kent, > It is actually a killer to the FM driver and FM Server Adv not > witango server. The witango server is only reporting the error the > ODBC driver manager is reporting. The FileMaker 8.x server is not > forgiving to slow connections. You might want to contact FileMaker > and get the latest version of their driver the have or contact Dan > Stein off list as he has been active in getting all the bugs out of > the FM Driver especially on windows. > > Regards > > Witango Support > > On 23/01/2007, at 12:33 PM, Robert Garcia wrote: > >> That kind of latency, and I imagine, slow throughput, is a witango >> killer. Unless this is a VERY lightly used application, you are >> asking for trouble. If it is very light, it will probably be ok. >> >> I have no experience in the quality/reliability of the filemaker >> odbc drivers. >> >> -- >> >> Robert Garcia >> President - BigHead Technology >> VP Application Development - eventpix.com >> 13653 West Park Dr >> Magalia, Ca 95954 >> ph: 530.645.4040 x222 fax: 530.645.4040 >> [EMAIL PROTECTED] - [EMAIL PROTECTED] >> http://bighead.net/ - http://eventpix.com/ >> >> On Jan 22, 2007, at 3:28 PM, Kent Swisher wrote: >> >>> Ok. This is all on Windows 2003 servers. But the Filemaker Pro >>> SA server *is* on the other side of the country so latency >>> averages 128 ms. >>> >>> Still have the development Witango server to set up so will see >>> what happens when I turn that up. If see there too, then can try >>> jdbc and see if it makes any difference. >>> >>> -> Kent >>> >>> On 1/22/2007 2:52 PM, Robert Garcia wrote: >>>> Either way, it depends alot on the driver. If you are using mac, >>>> dump odbc, use jdbc. ODBC on the mac with witango is a horrible >>>> combination. On windows, ODBC works well. >>>> -- >>>> Robert Garcia >>>> President - BigHead Technology >>>> VP Application Development - eventpix.com >>>> 13653 West Park Dr >>>> Magalia, Ca 95954 >>>> ph: 530.645.4040 x222 fax: 530.645.4040 >>>> [EMAIL PROTECTED] - [EMAIL PROTECTED] >>>> http://bighead.net/ - http://eventpix.com/ >>>> On Jan 22, 2007, at 11:28 AM, Kent Swisher wrote: >>>>> Win 2003 server >>>>> IIS 6 >>>>> Witango 5.5.8.0 >>>>> >>>>> I am having occasional (every few days) ODBC -> FMSA disconnects. >>>>> >>>>> Searching the archives indicates many people had problems with >>>>> ODBC in Witango 5.0 and it was improved in 5.5. Has the >>>>> problem pretty much gone away or is switching to jdbc drivers >>>>> still the best way to go? >>>>> >>>>> >>>>> -> Kent Swisher Engineering Services >>>>> -> Alcatel-Lucent Application Support Engineer >>>>> -> Wireline Access Products [EMAIL PROTECTED] >>>>> -> Petaluma, CA 707-792-7116 >>>>> __________________________________________________________________ >>>>> ______ >>>>> 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
