How do you turn off Prepare Stored Proc with MDAC 2.1 to SQL 7 
Author Message
 How do you turn off Prepare Stored Proc with MDAC 2.1 to SQL 7

Does anyone know how to turn off the use of ODBC Stored Procedures to
prepare statements to run against SQL 7 using MDAC 2.1?  This is possible
under using earlier versions of the products but not with this combination.
This is the only way I have found to get MS Access to send the query to the
server instead of trying to resolve the query it self.  Without being able
to turn this off, MS Access just crawls or times out especially with queries
with several joins over large tables.  Executing the same query directly on
SQL server nets an almost immediate result.


SQL Database Administrator



Sun, 07 Oct 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. How can I explicitly turn off logging (to tempdb) inside a stored proc

2. HELP: MDAC 2.1 and MDAC 2.5

3. MDAC 2.1 to MDAC 2.0

4. MDAC 2.6 on the Server and MDAC 2.1 on the Client - Big Problems

5. MDAC 2.0 & 2.1 V MDAC 1.5

6. MDAC 2.0 Vs MDAC 2.1 - Compatibility Issues.

7. ODBC Drive returns records using MDAC 2.0 but not MDAC 2.1 SP 2

8. MDAC 2.6 on the Server and MDAC 2.1 on the Client - Big Problems

9. MDAC 2.6 on the Server and MDAC 2.1 on the Client - Big Problems

10. mdac 2.1 to mdac 2.6

11. MDAC 2.1 vs MDAC 2.5?

12. MDAC 2.1 (GA) and MDAC 2.5 (RTM)


 
Powered by phpBB® Forum Software