How do I use reporting tools with the Datalogging and Supervisory Control Module?

[JG]

Has anyone used Crystal Reports with LVDSC? How about Visual Basic Programs that use RDO or ADO? I have constructed a simple project using RDO and I can't get a query to execute. Does anyone have some simple example code?

[Zork]

Hello,

There are a number of examples for pulling data out of the Citadel DataBase using an ODBC driver. These include Excel, Access, VB and more. These can be located under:
RESOURCE LIBRARY > LOOKOUT > DATA LOGGING

Hope this helps,
Zork

[JG]

Actually, it doesn't help. The VB example uses a data control, not RDO or ADO. As for Crystal Reports, it would operate similarly to the others listed there, but I would be interested to know if anyone is actually using it successfully with a Citadel database.

[Martin_S.]

Just a minute ago I answered similar question. I guees I can just copy and paste it here:
Databases like Oracle, MS Access, SQL Server... are business database and are sold for general purpose, thus has to provide full-ODBC support. Since ADO can call ODBC drivers also ADO is going to work (moreover all major database vendors has converted their driver to plain ADO to bypass ODBC and reduce the overhead).
Citadel is not a relational database, but historical database that serves to a specific purpose. The OBDC driver only supports some specific subset needed to get it to work in the most common environments (like MS Query/Excel, Access etc.). There are parts that are not supported. Browsing table items is one of the supported features (works in MS Query). You use SQLColumns() function to get the list of columns from an ODBC client.
So, where is the problem. When ADO talks to an ODBC driver it works as a wrapper for the ODBC and basically translates all ADO calls to the ODBC calls. Unfortunately the translation often result in ODBC calls that are not supported by Citadel ODBC driver. While this driver was developed to have all neccessary functionality for common ODBC clients it does not have full functionality to support ADO interface (ADO came out later than the driver). It does not mean you cannot use ADO at all. You can, but some calls are going to return an error. I was able to run a different ADO client fine, the only place it failed was getting the list of columns, because the client was trying to execute following statement to get the list: "select * from traces where 0=1" (this is an SQL compliant statement, but is not supported by Citadel. Again the support is limited to statements needed to get data back). For examples of supported statements check the National Resource Library on Developer Zone.
For any troubleshooting I recommned tracing ODBC calls. ODBC Administrator >> Trace. Check which call fails and try to workaroung it with a working one. To get a working sequence trace MS Query calls for example.
I hope this helps.

[MFScotty]

JG, have you had any luck getting ADO and ODBC to citadel to work. I have run into a number of issues with ADO/ODBC/citadel and am looking for someone that may have got this to work.

Best wishes,

Mark Scott