LabVIEW
Simple database question
I have an .mdb file that I would like to "open" using LV. I've installed Database Connectivity Toolkit. But I still can't seem to open the file.
Does Access have to be installed to view the data in this file?
Thanks
Does Access have to be installed to view the data in this file?
Thanks
I was pretty sure MDAC installed with the toolkit. But just to be sure I went and downloaded the newest version from MS.
I'm still unable to open the .mbd file though. So I must be doing something wrong.
I've been looking at the examples, trying to use the Read All Data.vi. But so far no luck, and I cannot seem to find the info I need included with the toolkit.
I'm still unable to open the .mbd file though. So I must be doing something wrong.
I've been looking at the examples, trying to use the Read All Data.vi. But so far no luck, and I cannot seem to find the info I need included with the toolkit.
When I run that VI is asks to setup the data link properties.
Select ODBC in the Provider tab as shown. Then goto the Connection tab and select Labview then test your connection. Click on OK when happy. The vi should work.
Are you doing that?
David
Message Edited by David Crawford on 04-20-2006 04:32 PM
This does appear to work. But only when connecting with the sample database included with the toolkit. When I try to point my .mdb file, it fails with this error:
Error -2147467259 occurred at DB Tools Open Connec (String).vi->DB Tools Open Connec (Path).vi->Read All Data.vi
Possible reason(s):
Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver] Not a valid password.. in DB Tools Open Connec (String).vi->DB Tools Open Connec (Path).vi->Read All Data.vi
I am using the correct admin password for the database. So I'm not really sure where I'm going wrong.
Do I have to somehow "register" my .mbd file with another application?
Error -2147467259 occurred at DB Tools Open Connec (String).vi->DB Tools Open Connec (Path).vi->Read All Data.vi
Possible reason(s):
Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver] Not a valid password.. in DB Tools Open Connec (String).vi->DB Tools Open Connec (Path).vi->Read All Data.vi
I am using the correct admin password for the database. So I'm not really sure where I'm going wrong.
Do I have to somehow "register" my .mbd file with another application?
Thanks for all the information.
Unfortunately all I keep getting are what appears to be password errors. As far as I know, I do have the correct admin password. But perhaps the person that developed the application did not give us the "real" admin password.
Looks like this is going to be a lot more difficult than I expected.
Unfortunately all I keep getting are what appears to be password errors. As far as I know, I do have the correct admin password. But perhaps the person that developed the application did not give us the "real" admin password.
Looks like this is going to be a lot more difficult than I expected.
It turns out we were given the wrong password. I was able to recover the correct password using a utility I found online.
I'm still having problems though. The only way I was able to get connected was to build a connection string. Unfortunately this only worked one time. Now the same method will no longer work.
I'm still having problems though. The only way I was able to get connected was to build a connection string. Unfortunately this only worked one time. Now the same method will no longer work.
Ok. It only took most of the afternoon. But it looks like I've been able to take my first step.
Not having the correct password gave me problems right from the start. I was able to retrieve the correct password using a utility I downloaded from this page:
http://www.everythingaccess.com/
I still wasn't correctly creating my OBDC source. But I wanted to be sure that the .mdb file I was using wasn't somehow corrupted or broken. Without Access, I found I was able to open the database with a tool I found here:
http://www.alexnolan.net/software/mdb_viewer_plus.htm
This confirmed for me that I did have the correct password and that the file was ok. I then went to Windows Control Panel and found the OBDC Data Source Administrator and created a new Data Source. I was able to point to my .mdb file as the Database and enter the password. The next time I ran the Read All Data.vi I was able to select my new Data Source and the connection worked this time.
This is my first experience with manipulating .mdb files using LabView, and it was a little more difficult than I expected. For awhile I was unsure if the DTK was actually able to open .mdb files, or if I had made an incorrect assumption of it's abilities.
Thanks to those who responded to my queries and pointed me in the right direction.
Not having the correct password gave me problems right from the start. I was able to retrieve the correct password using a utility I downloaded from this page:
http://www.everythingaccess.com/
I still wasn't correctly creating my OBDC source. But I wanted to be sure that the .mdb file I was using wasn't somehow corrupted or broken. Without Access, I found I was able to open the database with a tool I found here:
http://www.alexnolan.net/software/mdb_viewer_plus.htm
This confirmed for me that I did have the correct password and that the file was ok. I then went to Windows Control Panel and found the OBDC Data Source Administrator and created a new Data Source. I was able to point to my .mdb file as the Database and enter the password. The next time I ran the Read All Data.vi I was able to select my new Data Source and the connection worked this time.
This is my first experience with manipulating .mdb files using LabView, and it was a little more difficult than I expected. For awhile I was unsure if the DTK was actually able to open .mdb files, or if I had made an incorrect assumption of it's abilities.
Thanks to those who responded to my queries and pointed me in the right direction.
