question

MartynMatthews avatar image
MartynMatthews asked

Problem with unexpected "prepared statement" error

When a user executes a search, they sometimes get an ODBC error - "The prepared statement handle 1 is not valid in this context". The application is an Access front-end, using pass-through queries. There is no deliberate use of prepared statements. As far as I can tell, when this happens, it's usually the first interaction the user has had with the SQL Server back-end - subsequent searches or other interactions don't produce an error.
accessodbc
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.