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.