read access mdb file in labview via ADO/DAO problem

[RAVDM]

Hi guys,

I am now facing one problem that I want to import ACCESS database (ver2000) files into labview and turn it into tables.

but if I use ADO(actually using LABSQL) I have to create the ODBC in control panel, if I use DAO, I don't know how to call the activeX method.

I would like to realize like this:

choose in a directory which mdb file I would like to open, and then open it and show it in a labview table, but using AD0 I have to create connection for each file, does it stand a chance to open it without specify the connection in control panel?

He Liang

[DavidJCrawford]

You can use a Connection String defined by you like this

You can get the basic connection string by creating a UDL file and editing that file in Wordpad.

Hope this helps

David

Message Edited by David Crawford on 11-27-2006 01:04 PM

[RAVDM]

hi, thanks for your reply,

I use the microsfot activeX data object 2.8 to create a connection object and make the diagram as the annex( I can't insert it directly)

but got a failure code of 97, "Unknown System Error in TestDBViewer.vi"

why does it happen?

[RAVDM]

thank you, it's ok now,

I made two mistake, one is ignore the automation open for the object, and another is the wrong login name

thank you for your support