Accessing Citadel 5 or Citadel 4 through ODBC in DIAdem

[DIAdem Neo]

Hi,

I am trying to use the Citadel 5 and Citadel 4 Database. I am making use of ODBC. Can anyone tell me how can I connect to this Database in DIAdem and apply query(Insert, select queries) so that I can load the data from Citadel to the Diadem Data Portal.

Hoping for a quick response.
Thanks,
Priya

[Brad_Turpin]

Hi Priya,

Normally you would use the native Logos driver with DIAdem's built-in features to load data from a Citadel data base, rather than Citadel's ODBC interface. But of course, if you really do want to run queries or insert records, then this is not possible with the Logos API, so your only choice is to treat the Citadel data base as a normal SQL data base and use DIAdem's ODBC functions. I haven't personally done this with a Citadel data base, but at the below Discussion Forum you will find a wealth of examples which show how DIAdem interacts with SQL data bases.

http://forums.ni.com/ni/board/message?board.id=60&message.id=2053

Regards,
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[DIAdem Neo]

Thanks Brad,

This is helping me

Priya