troubleshooting Question

SQLExecDirectA fails sometimes.

Avatar of Aaron Jabamani
Aaron JabamaniFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerVisual C++.NET
4 Comments1 Solution825 ViewsLast Modified:
Hi All,
        I'm using SQLExecDirectA to to execute a stored procedure. It works many times but i do often get below error.
@ .\src\db\odbc\Connection.cpp:343   Detail: -1 { Record# 1 Error# 3922 State [42000] - Syntax error or access violation  ODBC Diagnostics: Row# 1 Line# 1 Message State [1] Message Severity [16] Procedure [sp_bindsession] Server [HOPRIFDBSHSQL2Q]  || Record# 2 Error# 3922 State [42000] - Syntax error or access violation  } )

Please let me know why it is failing only some times. From the web, state 42000 mean, Syntax error or access violation...really confused since the same code work fine many times

Now i will explain the the call is made from our project.
We are having a legacy code(VC++, one of our business component) which talks to the database to fetch/store data.  We have our web application( 1.1 & C#) . The legacy code is hosted in our web server(IIS).

Please let me know if u need more details....and please let me know any kind of information which will help in resolving this.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros