How to open AQD format database file from Labview?

[Hong.Zhang@agresearch.co.]

Hi Dennis

This is my vi and error message.

Thanks

[Dennis_Knutson]

What exactly do you have for the connection? I prefer a UDL file. You can usually create one in a folder of your choice by right clicking and selecting New>Microsoft Data File. If you don't see that option, create a text file and give it a .udl extension. When you double click a udl file, you get a configuration setup. This is the missing file in the error message.

[Hong.Zhang@agresearch.co.]

Hi Dennis

The database file created by third part program. I need open and read data from this file and integrate into my program.

Thanks

Hong

[Hong.Zhang@agresearch.co.]

Hi Dennis

The database file created by third part program. I need open and read data from this file and integrate into my program.

Thanks

Hong

[mikeporter]

Hong,

If this file is the Teledyne AQD file, you have a bigger problem. According to Dennis the underlying database is either SQL Server or Oracle. The problem is that unlike Jet or SQLite, with these two database managers a file is not the same thing as a database. Instead, SQL Server and Oracle both uses their files to simply define blocks of disk space they can use. Hence, one file can - and typiclly does - contain multiple databases. In addition, one database can be spread across multiple files.

Assuming for a moment that the original program was using a SQL Server backend, in order to use this file you need to be on a computer that has SQL Server running on it and then mount this file to make it part of the SQL Server memory space -- a process that presupposes you have a lot of information about the file's internal structure. The same is true with Oracle. Once you mounted the file you could then access the data in it -- again assuming you have extensive knowledge about what data is there and how its stored.

Do you know for a fact that this is a database file? What third-party program created the file originally?

Mike...

[Hong.Zhang@agresearch.co.]

Hi Mike

I have sent ae email to you attache dsome files.

Please have a look.

Thanks

[mikeporter]

First, I do not open files from people that I don't know. Moreover sending files without being asked is, at best, bad manners. Come to think of it, your employer might not be real thrilled with you sending password protected files (with the password!) To random people on the internet that YOU don't know.

Second, the message attached to the file has some important information in it for anyone else following this thread: the file is from MS Access - not SQL Server or Oracle. To open this sort of file from LV is very easy. All you need are the drivers you can find on the last page of this thread. Oh, and read the thread too. There's a lot of good information there.

Once you have these ADO drivers you will use SQL queries to read the data.

Mike...

[Hong.Zhang@agresearch.co.]

Hi Mike

Thank you very much fro sending the driver to me.

I have got some progresses. The file can be opened by using your Open Connection+.vi. Next function is Create and read Recordeset.vi that has error. The error message attached.

Please have a look my vi and advise how to fix it. 

Thanks

[mikeporter]

What is the structure of the tables in the file?

What is the query you are using?

Mike...