Also, the problem also occurs between physical servers besides virtual servers.
Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com <mailto:t...@ogdengroup.com> www.ogdengroup.com <http://www.ogdengroup.com> From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:38 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database So upgrading to Oterro 9 and splitting between two server seems to have introduced the problem? From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 3:49 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database The Witango server is also using sql server odbc datasources with pooling on. The ajax queries work with rbase 7.6, oterro 2.6 and RTango all on the same machine. I also posted to the RBase list but still no response. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com <mailto:t...@ogdengroup.com> www.ogdengroup.com <http://www.ogdengroup.com> From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:28 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database According to the small bit of log below, the failure to connect occurred on the 4th concurrent request. It seems that Oterro is either not allowing multiple requests or there is a limit to the number of requests/connections that can be active/opened at once. Have you found that setting datasourcelife=0 is necessary with Oterro? It is not a recommended configuration. Robert From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 2:50 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Hi, The setup: 2 window 2003 virtual servers, one has the rbase 7.6 database, the other server has Witango 5.5 and Oterro 9 unlimited. The only change to the Witango.ini file is datasoucelife=0 The Oterro odbc has pooling enabled. A simple taf with multiple database queries in a top-down structure works fine. The problem: Trying to render a taf with ajax database queries, the pages hang with none of the ajax queries connecting to the database. If I run the ajax queries separately, the page renders. Sometimes the first ajax query will connect but the others fail. Following error in Witango log: [Error] -4 Unable to connect to the specified data source. 17/11/2010 14:02:46 209.251.52.196 u...@3cfcd3bf795fd7ab4ce42246 2484 4 189 [Datasource] Unable to open a connection to odbc.demo due to an unknown error during connection Any suggestions? I have no problems using ajax queries when the odbc datasource is sql server. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com <mailto:t...@ogdengroup.com> www.ogdengroup.com <http://www.ogdengroup.com> From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, September 29, 2010 5:10 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database A component of Oterro is the ODBC driver, which needs to be installed on the same machines that Witango is. You’ll need to use the ODBC control panel to setup data sources before Witango can access them. I suspect that the ODBC driver can access the Oterro engine across the network, this is how it normally works, but I don’t have it setup here to test. One note, you need to use the 32-bit version. Since Witango 5.5 (and 6.0) are 32-bit applications, they cannot access ODBC connections setup under a 64-bit driver. Going forward, Witango is going to support database connectivity through ODBC and JDBC only. Native drivers are messy to support and will only return to the product if there is enough demand. Robert From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:47 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database You should upgrade to Oterro 9.0 – it’s the latest version. I believe (not completely sure) that the database can be on a different machine, but the Oterro driver needs to be on the same machine as the Witango engine. Steve Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax) 925-876-3100 (Cell) Steve Sweeney Co-Founder (925) 876-3100 - Tel www.webkpi.com <http://www.webkpi.com/> From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, September 29, 2010 11:53 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Which version? We have oterro 2.6 that we use with RTango but would like to upgrade to Witango. Also, does the Rbase database need to be on the same machine as Witango? Thanks Ted From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:15 PM To: Witango-Talk@witango.com Subject: Witango-Talk: RE: odbc connection to rbase database All you need is the Oterro driver, available from R:BASE Technologies, Inc – 724-733-0053. It works great! Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax) 925-876-3100 (Cell) From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, September 29, 2010 11:19 AM To: Witango-Talk@witango.com Subject: Witango-Talk: odbc connection to rbase database Hi, Does anyone know if it is possible to connect to a RBase 7.6 database with Witango? If so, how did you do it. Thanks Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com <mailto:t...@ogdengroup.com> www.ogdengroup.com <http://www.ogdengroup.com> ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.
<<image001.gif>>