The PHP-based XML data provider (ricoXMLquery.php, dbClass2.php, ricoXmlResponse.php) has been tested with the following databases:
MySQL 4 & 5, Oracle XE, SQL Server 2005, MS Access.
LiveGrid-Static Buffer
Uses Rico.Buffer.Base - takes advantage of LiveGrid scrolling, but no AJAX
LiveGrid-Database Connection
Uses Rico.Buffer.AjaxSQL on the client and Rico's PHP plug-in on the server to pass query results
from the database to the client via AJAX
LiveGrid Forms-Database Connection
Popup forms allow data to be edited and posted back to the original script.
Populated using Rico.Buffer.AjaxSQL
LiveGrid-XML Data Source
Uses Rico.Buffer.AjaxXML to load data via AJAX at grid startup
SimpleGrid
No buffer - all data is in the DOM
Popup Controls
The ASP-based XML data provider (ricoXMLquery.asp, dbClass2.vbs, ricoXmlResponse.vbs) has been tested with the following databases:
SQL Server 2000/2005, Oracle XE, DB2 Express-C, MySQL 4 & 5, MS Access.
The code is based on the ADO library, so it should work with most ADO compatible databases.
LiveGrid-Static Buffer
Uses Rico.Buffer.Base - takes advantage of LiveGrid scrolling, but no AJAX
LiveGrid-Database Connection
Uses Rico.Buffer.AjaxSQL on the client and Rico's ASP plug-in on the server to pass query results
from the database to the client via AJAX
LiveGrid Forms-Database Connection
Popup forms allow data to be edited and posted back to the original script.
Populated using Rico.Buffer.AjaxSQL
LiveGrid-XML Data Source
Uses Rico.Buffer.AjaxXML to load data via AJAX at grid startup
SimpleGrid
No buffer - all data is in the DOM
Popup Controls
The .net-based XML data provider (ricoXMLquery.aspx, ricoXmlResponse.ascx) has been tested with the following databases:
SQL Server 2005, Oracle XE, DB2 Express-C, MySQL 4 & 5, MS Access.
The code is based on the ADO.net library, so it should work with any database that has an ADO.net data provider.
An alternate plug-in is available at: SharpPieces.
LiveGrid-Static Buffer
Uses Rico.Buffer.Base - takes advantage of LiveGrid scrolling, but no AJAX
LiveGrid-Database Connection
Uses Rico.Buffer.AjaxSQL on the client and Rico's .net plug-in on the server to pass query results
from the database to the client via AJAX
LiveGrid Forms-Database Connection
Popup forms allow data to be edited and posted back to the original script.
Populated using Rico.Buffer.AjaxSQL
LiveGrid-XML Data Source
Uses Rico.Buffer.AjaxXML to load data via AJAX at grid startup
SimpleGrid
No buffer - all data is in the DOM
Popup Controls
The Perl-based XML data provider (ricoXMLquery.pl) is based on the dbi library
and has been tested with the following databases:
SQL Server 2000/2005, Oracle XE, MySQL 4 & 5, MS Access.
Perl's lack of direct support for session variables has made it difficult to port
code from the other Rico plug-ins.
We are looking for contributors who would like to take up this challenge
and more fully integrate this plug-in with Rico.
LiveGrid-Static Buffer
Uses Rico.Buffer.Base
LiveGrid-Database Connection
Uses Rico.Buffer.AjaxSQL