LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

want to prompt user to open an access database from a server location

Does anyone have a simple example of a user prompt database access VI.
I want to have the user prompted to designate the database file from a server location. The server location will change for each user pc configuration.
0 Kudos
Message 1 of 8
(3,409 Views)

Try the file dialog function.

 

0 Kudos
Message 2 of 8
(3,402 Views)

Not exactly what I was looking for.

I know how to use the file open dialog function, I just don't have any experience with the database access tools and was hoping for an example of opening a database using these tools. My ultimate goal is to open the database extract the message table and utilize this data in another vi to decode and save the table in text format. Do you have any examples that perform these functions? I'll eventually figure it out, but wanted to avoid the trial and error method if something is readily available.

 

Thanks for the reply

0 Kudos
Message 3 of 8
(3,383 Views)
Are you using the Database connectivity toolkit?
0 Kudos
Message 4 of 8
(3,380 Views)

Yes, I have the toolkit.

I need to dynamically create the datalink to a MSAccess (.mdb) database on a server.

Thanks for the reply

 

0 Kudos
Message 5 of 8
(3,377 Views)
That I'm not so sure about.  Is there a finite and definitive list of all the databases that need to be accounted for?  Is it possible that you could create an array containing the paths to all the necessary udl files, and when the user selects a database, you pull the appropriate link from your array?

There may be a better way to do this (with .net I'm sure it could work), but this is the most readily apparent to me...
0 Kudos
Message 6 of 8
(3,372 Views)
Hi Jdam

This is possible, I had to do exactly the same some time ago. I attached a VI which basically dynamically creates UDL data connection string and inputs it to a subVI of DB Tools Open Connection.
You can provide a local path or a network path to the attached VI.

Message 7 of 8
(3,369 Views)

Thank you.

I modified my open dialog path to string and was able to make the connection.

Now I can work on pulling the message table data out and saving as a spreadsheet.

0 Kudos
Message 8 of 8
(3,352 Views)