10-12-2011 11:02 PM
Hi,
I'm new in database and i need help. I had created a database and tried to connect it using labview.
I having the following error when I try to access to the my database throught Database Connectivity toolkit.
Error Message:
Error -2147217865 occured at NI_Database_API.lvlib:Conn Execute.vi-> Main Page.vi
Possible reason(s):
ADO Error: 0x80040E37
Exception occured in Microsoft OLE DB Provider for ODBC
Drivers: [MySQL][ODBC 3.51 Driver][mysql=5.1.54-community]
Table 'imax.trend'doesn't exist in NI_Database_API.lvlib:Conn Execute.vi-> Main Page.vi
Can any1 help? Refer attachments for the error message and the labview block diagram.
Is it due to database configuration problem?
10-16-2011 11:24 AM - edited 10-16-2011 11:24 AM
Hi!
The error states that the table you are trying to access does not exists.
Have you configured properly the ODBC connection?
Does your user have access to the database and table?
You can give a look here: http://digital.ni.com/public.nsf/allkb/47A8CF66D5E3C8CC8625720A006139D6
Marco
10-17-2011 08:07 AM
Hi,
First check your test connection in UDL. If this test connect is success in your UDL then save user name and password in UDL itself, no need to give user name and password in your DB connection establish VI.
Enable your highlight execution option and run code and observer where you are getting this error. During the connection establish or in your query.