Accessing Citadel With Microsoft Visual C++ .NET

[tritone]

Has anyone been able to do this successfully? I am trying to write a small program that lets the user filter Citadel data and then output that filtered data to a separate spreadsheet.

My problem is this: every piece of documentation I can find says to use the VC++ Class Wizard to create an "ODBC-MFC Consumer" class and then go from there. When I attempt to do this, and tell it where Citadel resides, it comes up with "Could not find any table or procedure information." It works if I tell it to use an existing Excel spreadsheet, but with Citadel the "Wizard" is just confused.

Does anyone have a way around this, or some advice for accessing the Citadel data using MS VC++?

[Cyril]

Tritone,

I am an NI Industrial Automation Applications Engineer but I have no experience at all with Microsoft Visual studio C++.NET. However I do know that you first need to create the data source in order for your application to access the Citadel ODBC driver:
http://zone.ni.com/devzone/taskdoc.nsf/2d17d611efb58b22862567a9006ffe76/ada7d25d95dd50d68625680800729d71?OpenDocument

I found that article on the web about Connecting to Oracle 9 using the Microsoft .NET Framework with source code.
http://www.akadia.com/services/dotnet_odbc.html

The structure would probably be pretty similar to the one provided here to connect to Citadel.


Regards,

Cyril Bouton
Applications Engineer
National Instruments.

[Roli]

Same for me, barely experience in C++, but I was once looking for some examples and found:
Querying Citadel 4 Via OLE DB Provider for ODBC in Microsoft Visual Basic

Querying Citadel 4 Via ODBC in Microsoft Visual Basic

Discussion about the ODBC
driver for Citadel 4

Just curious: Why are you using VC++ and not LabVIEW DSC to retrieve the historical data?

Hope this helps.
Roland