FW: Witango-Talk: Witango 5 / SQL Server 7
Gotta ask a dumb question. Would installing MDAC 2.8 help other db's like R:Base or does this just affect MS SQL? Definitely make sure you have MDAC 2.8. You should always keep the ODBC Driver Manager and odbc database driver up to date. (Anyone using OS X send an email to Apple to let them know that you are using ODBC and would appreciate them updating the iodbc driver manager in Tiger and that it should also provide updates on a regular basis to it. http://www.apple.com/feedback/server.html) Keeping it simple and short - ODBC has several layers and the way a request makes it from the Witango Server to a database and back again is like this. -- | Witango Server| | Connects to ODBC | | Driver Manager| -- /\ || \/ -- | ODBC Driver Mgr| -- /\ || \/ -- | ODBC DB Driver = | | Native DB Protocol | -- /\ || \/ -- | Database Management| | System | -- /\ || \/ -- | Database | -- The Witango server sends its requests to the odbc driver manager that in turn makes calls to the odbc database driver. MDAC/iodbc/unixodbc provides the odbc driver manager layer that the odbc database driver sits on. The Witango server does not access the odbc database driver directly, it is always accessed indirectly via the odbc driver manager whose environment it is loaded into. The odbc database driver has an ODBC interface that the driver manager communicates with and implements the native database protocol to communicate with the database. The other thing to know is that the odbc database driver is usually written by the database vendor and not the by the driver manager vendor so you may need to visit both vendors to get the latest driver manager and odbc database driver. Phil TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: problem with quote value and 5.5 server
noSQLEncoding should only affect the behavour of a directDBMS action. An update action should not be affected. I've had to use the same method that Trevor mentions below and it has always worked on 5.0. I've yet to upgrade to 5.5 so I can't comment on whether or not it works for me, but now I'm worried about it. Trevor, please raise this as a bug with Witango if you can easily reproduce it. /John Ben Johansen wrote: 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 PROTECTED] *Subject:* Witango-Talk: 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 ownershipnull@else'1'/@if i.e. sql should read /field=null/ or /field=1/ depending on the value of ownership. This worked fine on 5.0 but since upgrading to 5.5 the server insists on quoting even when quote value is set to false. So, I either get a value of null (i.e. the word null being stored in the field which is a char field) or the value 1 (i.e. quote 1 quote) instead of having an empty field or a field with the value of 1. Has anyone else experienced this? Trevor Green 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
Re: Witango-Talk: Witango 5 / SQL Server 7
Is there a way to check your MDAC version? - Original Message - From: Robert Shubert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 9:20 PM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 this. Updating your ODBC drivers in weird ways, getting too far out of sync with other resources of the OS, could cause instability and other problems. The MDAC 2.8 and 2.7 literature talks about OS versions, etc. Be aware of the ramifications, and be ready to rollback. Robert -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 10:01 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 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 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 from 13 to 29 and above and that's when WiTango service died. We have to Stop and Restart the service almost everyday...pain in the butt. It also took a long time for it to stop when this happened. We think WiTango is not releasing something at the end of datasource connection or even when it expires. We need help too on this. MC At 10:15 AM 10/15/04 -0400, you wrote: 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 Witango service. Since it's lots of different files, even ones that I've rebuilt in Witango 5, I'm wondering if it's an ODBC issue. Anyone out there using this combination (ODBC Driver verison 3.70.x)? Windows and SQL Server both have the latest service packs (issue was there before and after those updates to SP4 on both). Thanks, Jason __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- Jason Pamental, President [EMAIL PROTECTED] Bathysphere Digital Media Services, Inc. http://bathyspheredms.com Tel: 401.490.6830 Fax: 401.490.6831 A North American Distributor for Witango (http://www.witango.us) Rapid Web Application Development - XML Execution Engine 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
RE: Witango-Talk: Witango 5 / SQL Server 7
I did a search for files named mdac and then did a right-click and selected properties and then version Ben -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 Is there a way to check your MDAC version? - Original Message - From: Robert Shubert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 9:20 PM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 this. Updating your ODBC drivers in weird ways, getting too far out of sync with other resources of the OS, could cause instability and other problems. The MDAC 2.8 and 2.7 literature talks about OS versions, etc. Be aware of the ramifications, and be ready to rollback. Robert -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 10:01 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 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 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 from 13 to 29 and above and that's when WiTango service died. We have to Stop and Restart the service almost everyday...pain in the butt. It also took a long time for it to stop when this happened. We think WiTango is not releasing something at the end of datasource connection or even when it expires. We need help too on this. MC At 10:15 AM 10/15/04 -0400, you wrote: 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 Witango service. Since it's lots of different files, even ones that I've rebuilt in Witango 5, I'm wondering if it's an ODBC issue. Anyone out there using this combination (ODBC Driver verison 3.70.x)? Windows and SQL Server both have the latest service packs (issue was there before and after those updates to SP4 on both). Thanks, Jason __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- Jason Pamental, President [EMAIL PROTECTED] Bathysphere Digital Media Services, Inc. http://bathyspheredms.com Tel: 401.490.6830 Fax: 401.490.6831 A North American Distributor for Witango (http://www.witango.us) Rapid Web Application Development - XML Execution Engine 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
Re: Witango-Talk: Witango 5 / SQL Server 7
which file did you do it on? I just did a search and found a bunch of diff files containing mdac with various extensions like inf, cat, ini, dat, pnf and some others - Original Message - From: Ben Johansen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 18, 2004 11:27 AM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 I did a search for files named mdac and then did a right-click and selected properties and then version Ben -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 Is there a way to check your MDAC version? - Original Message - From: Robert Shubert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 9:20 PM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 this. Updating your ODBC drivers in weird ways, getting too far out of sync with other resources of the OS, could cause instability and other problems. The MDAC 2.8 and 2.7 literature talks about OS versions, etc. Be aware of the ramifications, and be ready to rollback. Robert -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 10:01 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 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 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 from 13 to 29 and above and that's when WiTango service died. We have to Stop and Restart the service almost everyday...pain in the butt. It also took a long time for it to stop when this happened. We think WiTango is not releasing something at the end of datasource connection or even when it expires. We need help too on this. MC At 10:15 AM 10/15/04 -0400, you wrote: 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 Witango service. Since it's lots of different files, even ones that I've rebuilt in Witango 5, I'm wondering if it's an ODBC issue. Anyone out there using this combination (ODBC Driver verison 3.70.x)? Windows and SQL Server both have the latest service packs (issue was there before and after those updates to SP4 on both). Thanks, Jason __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- Jason Pamental, President [EMAIL PROTECTED] Bathysphere Digital Media Services, Inc. http://bathyspheredms.com Tel: 401.490.6830 Fax: 401.490.6831 A North American Distributor for Witango (http://www.witango.us) Rapid Web Application Development - XML Execution Engine 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
Re: Witango-Talk: problem with quote value and 5.5 server
Hi I'm having the quoting problem right now on 5.5. I've moved some of my programs that I was running on 5.0 to 5.5. Now all of the updates, that use text fields in my db, have to be quoted, in criteria box, before the update will work. I've made a small test .taf to test this and you can't use a @var in criteria box because if you quote it @var shows up not it's value. Tom John McGowan wrote: noSQLEncoding should only affect the behavour of a directDBMS action. An update action should not be affected. I've had to use the same method that Trevor mentions below and it has always worked on 5.0. I've yet to upgrade to 5.5 so I can't comment on whether or not it works for me, but now I'm worried about it. Trevor, please raise this as a bug with Witango if you can easily reproduce it. /John Ben Johansen wrote: 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 PROTECTED] *Subject:* Witango-Talk: 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 ownershipnull@else'1'/@if i.e. sql should read /field=null/ or /field=1/ depending on the value of ownership. This worked fine on 5.0 but since upgrading to 5.5 the server insists on quoting even when quote value is set to false. So, I either get a value of null (i.e. the word null being stored in the field which is a char field) or the value 1 (i.e. quote 1 quote) instead of having an empty field or a field with the value of 1. Has anyone else experienced this? Trevor Green 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.ta f -- Tom Storey Research Accountability Pinellas County Schools Largo, Fl (727) 588-6254 [EMAIL PROTECTED] -- The box said: Requires Windows XP, or better. So I bought a Macintosh with OS X -- TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Witango 5 / SQL Server 7
Alan, I check the version of oledb32.dll for this. I don't know if this is the proper way, but I believe this is one way to do it. Steve Fogelson Internet Commerce Solutions -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 11:26 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 Is there a way to check your MDAC version? - Original Message - From: Robert Shubert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 9:20 PM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 this. Updating your ODBC drivers in weird ways, getting too far out of sync with other resources of the OS, could cause instability and other problems. The MDAC 2.8 and 2.7 literature talks about OS versions, etc. Be aware of the ramifications, and be ready to rollback. Robert -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 10:01 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 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 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 from 13 to 29 and above and that's when WiTango service died. We have to Stop and Restart the service almost everyday...pain in the butt. It also took a long time for it to stop when this happened. We think WiTango is not releasing something at the end of datasource connection or even when it expires. We need help too on this. MC At 10:15 AM 10/15/04 -0400, you wrote: 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 Witango service. Since it's lots of different files, even ones that I've rebuilt in Witango 5, I'm wondering if it's an ODBC issue. Anyone out there using this combination (ODBC Driver verison 3.70.x)? Windows and SQL Server both have the latest service packs (issue was there before and after those updates to SP4 on both). Thanks, Jason __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- Jason Pamental, President [EMAIL PROTECTED] Bathysphere Digital Media Services, Inc. http://bathyspheredms.com Tel: 401.490.6830 Fax: 401.490.6831 A North American Distributor for Witango (http://www.witango.us) Rapid Web Application Development - XML Execution Engine 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
Re: Witango-Talk: Witango 5 / SQL Server 7
I try to keep my mdac up to date. The problem is that it can be wrapped in a lot of other programs. Microsoft is famous for this. If you load excel, access, sql, or a host of other Microsoft products, you can end up with a hodgepodge of mdac files that will have different version numbers. All these programs will try to update your mdac with what happens to be wrapped in the software. In order for you to update, Microsoft has a mdac checker available for download which checks for inconsistincies in the files. It also gives recommended fixes. I always found it daunting to use this tool and have always updated with trepidation as it gives a bunch of warnings, etc. but I have never had any problems updating. I don't remember the exact URL, but if you go to their site and search, I am sure you can find it. Be aware that some versions only work with certain platforms and softwares. If you are using SQL 7, you can only upgrade mdac to a certain level. If you use database clusters, the upgrade level is different. NT -- diifferent -- XP different --etc etc etc etc Make sure you read ALL the documentation, and trust me... Microsoft being what it is, there is a LOT of documentation! p.s., I have never been able to get the tool to give my servers a clean bill of health when it comes to mdac. BUT I have never had any problems either. which file did you do it on? I just did a search and found a bunch of diff files containing mdac with various extensions like inf, cat, ini, dat, pnf and some others - Original Message - From: Ben Johansen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 18, 2004 11:27 AM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 I did a search for files named mdac and then did a right-click and selected properties and then version Ben -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 Is there a way to check your MDAC version? - Original Message - From: Robert Shubert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 9:20 PM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 this. Updating your ODBC drivers in weird ways, getting too far out of sync with other resources of the OS, could cause instability and other problems. The MDAC 2.8 and 2.7 literature talks about OS versions, etc. Be aware of the ramifications, and be ready to rollback. Robert -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 10:01 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 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 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 from 13 to 29 and above and that's when WiTango service died. We have to Stop and Restart the service almost everyday...pain in the butt. It also took a long time for it to stop when this happened. We think WiTango is not releasing something at the end of datasource connection or even when it expires. We need help too on this. MC At 10:15 AM 10/15/04 -0400, you wrote: 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 Witango service. Since it's lots of different files, even ones that I've rebuilt in Witango 5, I'm wondering if it's an ODBC issue. Anyone out there using this combination (ODBC Driver verison 3.70.x)? Windows and SQL
Witango-Talk: Search Args vs Post Args
I just wanted to check a coupe of assumptions 1) To link to another file a BUTTON is better than a plain HREF link, at least the path and values are hidden from the status bar, Any Comments? 2) On one screen - I made a FORM. The user chooses a report to view by choosing a Radio Button then a submit button. Its works well because the radio buttons don't take up much room and there are lot of reports to choose from. Anyways is the form the safest way to send the request? Is it more secure than the button? Thanks from Janet TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Search Args vs Post Args
It all depends. and you don't give any goals. A couple of things to consider. 1. A spider (eg googlebot) will NOT follow your form submittals, so if you want those files spidered, use an href. What do you hope to gain by hiding the path and values? 2. Safety -- Validate the input parameters to make sure they are ok. Security -- maybe you want an encrypted (https) channel. On Monday, October 18, 2004, at 02:51 PM, QSN Janet Case wrote: I just wanted to check a coupe of assumptions 1) To link to another file a BUTTON is better than a plain HREF link, at least the path and values are hidden from the status bar, Any Comments? 2) On one screen - I made a FORM. The user chooses a report to view by choosing a Radio Button then a submit button. Its works well because the radio buttons don't take up much room and there are lot of reports to choose from. Anyways is the form the safest way to send the request? Is it more secure than the button? Thanks from Janet ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Witango 5 / SQL Server 7
You can use the following to give you an estimate on your mdac version. http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43- bf53-14332ef092c9displaylang=en (watch for wrap) N -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 19 October 2004 5:21 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 I try to keep my mdac up to date. The problem is that it can be wrapped in a lot of other programs. Microsoft is famous for this. If you load excel, access, sql, or a host of other Microsoft products, you can end up with a hodgepodge of mdac files that will have different version numbers. All these programs will try to update your mdac with what happens to be wrapped in the software. In order for you to update, Microsoft has a mdac checker available for download which checks for inconsistincies in the files. It also gives recommended fixes. I always found it daunting to use this tool and have always updated with trepidation as it gives a bunch of warnings, etc. but I have never had any problems updating. I don't remember the exact URL, but if you go to their site and search, I am sure you can find it. Be aware that some versions only work with certain platforms and softwares. If you are using SQL 7, you can only upgrade mdac to a certain level. If you use database clusters, the upgrade level is different. NT -- diifferent -- XP different --etc etc etc etc Make sure you read ALL the documentation, and trust me... Microsoft being what it is, there is a LOT of documentation! p.s., I have never been able to get the tool to give my servers a clean bill of health when it comes to mdac. BUT I have never had any problems either. which file did you do it on? I just did a search and found a bunch of diff files containing mdac with various extensions like inf, cat, ini, dat, pnf and some others - Original Message - From: Ben Johansen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 18, 2004 11:27 AM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 I did a search for files named mdac and then did a right-click and selected properties and then version Ben -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 Is there a way to check your MDAC version? - Original Message - From: Robert Shubert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 9:20 PM Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 this. Updating your ODBC drivers in weird ways, getting too far out of sync with other resources of the OS, could cause instability and other problems. The MDAC 2.8 and 2.7 literature talks about OS versions, etc. Be aware of the ramifications, and be ready to rollback. Robert -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 10:01 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 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 PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 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 are also experiencing similar behavior with WiTango 5.5 and Oracle 9i on Window 2003. The WiTango support does not have any answer tothis at all and we are still trying to figure it out on our own. WiTango thread remains at 19 constantly. Our Oracle thread continuesto grow slowly over time from 13 to 29 and above and that's whenWiTango service died. We have to Stop and Restart the service almosteveryday...pain in the butt. It also took a long time for it to stopwhen this happened. We think WiTango is not releasing something at the end of datasource connection or even when it expires. We need help too on this. MC At 10:15 AM 10/15/04 -0400, you wrote: Hey everyone- Anyone out there using
Re: Witango-Talk: Ideas on parsed searches and rankings?
But, we're talking about a search of a database. On 10/18/04 5:59 PM, Bill Conlon [EMAIL PROTECTED] wrote: Roland, You've heard this from me before on this list. Take a look at swish-e. You could use its built-in spider to index your site, and then use the built-in cgi-script to highlight your results. It's really a great piece of software. Now if you take the swish-e approach, here's what I would do to solve this. Dyanmically create metatags for the key parameters you want to search: meta name=vineyard content=Chateau Lafite, Chateau, Lafite meta name=varietal content=Pinot Noir, Pinot, Noir etc. Use witango to tokenize while creating the HTML pages for the various wines. Then use swish-e's meta name search. On Monday, October 18, 2004, at 05:39 PM, Roland Dumas wrote: In search engines, when you submit a search string, the search engine first tokenizes and then searches for each substring string separately and then brings them together as your found set. So if I search for 1961 Chateau Lafite, I'll get items with 1961, others with Chateau or Chateu Lafite, and on top will be the found records with 1961 Chateau Lafite (I know, if you put it in quotes, it forces it to find only the whole string. That part is easy) They will also rank a find of the full set of terms above ones with one or two terms in the documents. Questions: What's the approach with witango that will enable the search of tokenized strings. Any ideas on how to do a crude ranking, such that the full term comes up on top of the found set? ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf - Roland Dumas Roberts Information Services 310 W. Bellevue Avenue San Mateo CA 94402 650-347-1373 415-412-9300 (cell) [EMAIL PROTECTED] SMS: http://new.servqual.com/html/sms.tml TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
