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.
<<image001.gif>>
