This Document is not yet Rated

Rate this Document

I Get Error -500 When Inserting More than 500 Records into a Database Using LabVIEW SQL Toolkit

Primary Software: LabVIEW Toolkits>>Enterprise Connectivity Toolset
Primary Software Version: 3.0
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem: I am using MS-Access ODBC driver. While I try to enter the number of records in MS-Access using Execute.vi in a for loop one at
a time (ie: Inserting records in Access Database). LabVIEW shows an error as follows:
Error : -500 occured .
Desc.-
Execute SQL - Max.no. of SQL stat.has been exceeded.

Solution: Call End SQL after Execute SQL and it should fix the problem.



Related Links:

Attachments:





Report Date: 12/30/1998
Last Updated: 11/30/2004
Document ID: 1GT7Q8WV

Your Feedback!	Poor  |  Excellent							Yes	No
Document Quality?							Answered Your Question?
	1	2	3	4	5
Document needs work? Please tell us why.
Please Contact NI for all product and support inquiries.