Error -2147217865 in Labview program on Windows XP

[chrisdee]

Hello. Im a newbie in Labview and am having a problem with a error message

I dont understand. Im running Labview on a pc-logger with windows XP.

The program is written by a guy on my university, and logs voltage from

a solar cell panel. He doesnt have the time to check in to it, so Im supposed to

find out what's wrong.

The error message is as follows :

---------------------------------------------------------------------------------

Error -2147217865 occured at Cmd Execute.vi->DB Tools Insert

Data.vi->Solcelle.vi

Possible reasons :

Exception occured in Microsoft OLE DB Provider for ODBC Drivers,

[MySQL][ODBC 3.51 Driver][mysqld-3.23.38-log]Can't open file :

'solcelledata.MYD'. (errno: 145). in Rec Create - Command.vi-

>Cmd Execute.vi->DB Tools Insert Data.vi->Solcelle.vi

-----------------------------------------------------------------------------------

I really hope someone can tell me what's wrong and specifically what to do

with it, or possibly guide me to someone who could suggest a solution to this

problem.

Reguards

chrisdee

[Jeffrey Habets]

The error message is as follows :

---------------------------------------------------------------------------------

Error -2147217865 occured at Cmd Execute.vi->DB Tools Insert

Data.vi->Solcelle.vi

Possible reasons :

Exception occured in Microsoft OLE DB Provider for ODBC Drivers,

[MySQL][ODBC 3.51 Driver][mysqld-3.23.38-log]Can't open file :

'solcelledata.MYD'. (errno: 145). in Rec Create - Command.vi-

>Cmd Execute.vi->DB Tools Insert Data.vi->Solcelle.vi

This is not a LabVIEW problem. The LabVIEW program obviously uses a MySQL database through an ODBC driver. The error you get is from the MySQL database service. It is unable to open the database table file 'solcelledata.MYD'. So maybe this file is corrupt or deleted.

If the database is on a server somewhere, you might need to contact your systems admin.

[chrisdee]

Thanks for the reply. Things are a bit clearer.

The file solcelledata.MYD is located on the pc-logger

Is there a way I can fix or edit this file if it's corrupted ?

[Jeffrey Habets]

Thanks for the reply. Things are a bit clearer.

The file solcelledata.MYD is located on the pc-logger

Is there a way I can fix or edit this file if it's corrupted ?

Try this: http://dev.mysql.com/doc/mysql/en/repair.html as a starting point.

I'm not sure though if this particular page will be helpfull if the file is really totally unreadable by MySQL.

[klessm1]

Thanks for the reply. Things are a bit clearer.

The file solcelledata.MYD is located on the pc-logger

Is there a way I can fix or edit this file if it's corrupted ?

You might want to check if it is actually currupted by trying to edit the table with MyCC (go to mysql site). If it won't load you can always create a new database in MyCC with the parameters you need. I would also suggest to check the permissions of the user being used to login to the database in the LabVIEW application.

I doubt if you are having an ODBC issue because you are not getting an error in your connect routine, but you may want to check those settings as well. control panel\administrative tools\Data Sources. It is probably under System DSN.