Reasons to hate Microsoft: the error message “Microsoft OLE DB Provider for ODBC Drivers error ‘80040e14’
Syntax error or access violation”
could mean ‘your user doesn’t have the right to execute this stored procedure’, a syntax error, or ‘could not find the named stored procedure’.
Couldn’t they have spent the extra day it would have taken to write useful relevant error messages? If you’re after a fix for ODBC Drivers error ‘80040e14’, two quick test fixes: check that the stored procedure actually exists, and check that your db user has permission to run it. If you know other solutions, leave a comment and I’ll add them.