ADO Database- Method Recordset.Recordcount doesn_t work

[Berni]

Hello,
I'll try to work with a Interbase database via ODBC/ADO via Labview. I can open the connection and insert and select database entries.
But some methods do not work with the recordset:
for example "MoveLast". The property "RecordCount" also gives bad results. I have seen in a ASP use group that they change the options for the "Open" method to avoid this problem (there was a code example). Is there any information available about the Open options?
Thank you.

Berni

[Randy_H]

Berni,

National Instruments sells the Database Connectivity Toolset which is implemented with the ADO. Maybe this would speed up your development?

Randy Hoskin
Applications Engineer
National Instruments
http://www.ni.com/ask

[drval]

It's a great toolkit -- I've used it extensively in deployed applications for three years now. I even used it to completely replace VB generated OCX code that had used ADO and DAO. The LV toolkit code is inherently much more stable and I've even seen it execute more quickly than the prior OCXs.

[Berni]

Randy,

I have the database toolset. It's okay, but I have several problems with it. First it was very difficult to find an ODBC for Interbase 6, which supports the different dialects (now I have an "Easysoft"-software running). Then some functions of the database-toolset do not work properly (e.g. "move to record"). I think it has something to do with the above, but it is hard to "enter" the functions and make changes. The Labview help is great, but not so good for the databse toolset.

Bernhard

[drval]

Berni:

This is a driver-related problem, not a problem with the toolkit per se. My suggestion would be to consider porting the database to something like MS-Access, which has complete and transparent drivers available.

There are fairly extensive examples available and, if you know SQL, you can specify virtually any command using that syntax.

val