LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview Database Connectivity error -2147217865

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?

 

 

Download All
0 Kudos
Message 1 of 3
(4,025 Views)

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

0 Kudos
Message 2 of 3
(3,993 Views)

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.

Thanks and Regards
Himanshu Goyal | LabVIEW Engineer- Power System Automation
Values that steer us ahead: Passion | Innovation | Ambition | Diligence | Teamwork
It Only gets BETTER!!!
0 Kudos
Message 3 of 3
(3,974 Views)