If you are getting trouble on this kind of error prompting
Run-time error '-2147217900 (80040e14)' Syntax Error or Access Violation like
shown at the image below:
Figure 1.0
at my experience, this error come up when i call a stored procedure from my SQL Server
2005 database, and i declare my code look like this
Figure 1.1
at the codes shown at the figure 1.1, if you trace it thouroghly you found out my error,
so the only error on this is my Command Text, where i forgot to declare, supposedly it
will come up with
MrCmd.CommandText = "Update_Products"
this code will placed under the Call New_Cmd
Happy Coding ^_^
The Hardest Thing to Do is to DO Nothing ^_^
Run-time error '-2147217900 (80040e14)' Syntax Error or Access Violation like
shown at the image below:
Figure 1.0
at my experience, this error come up when i call a stored procedure from my SQL Server
2005 database, and i declare my code look like this
Figure 1.1
at the codes shown at the figure 1.1, if you trace it thouroghly you found out my error,
so the only error on this is my Command Text, where i forgot to declare, supposedly it
will come up with
MrCmd.CommandText = "Update_Products"
this code will placed under the Call New_Cmd
Happy Coding ^_^
The Hardest Thing to Do is to DO Nothing ^_^
Posts
Leave a comment