ado 2.7 
Author Message
 ado 2.7

    Has anyone had any problems wih ADO 2.7?  This comes with visual  When running stored procedures using the ado command
object (from within Visual Basic 6 Sp4) i have noticed that if i dont change
the activeconnection setting between executing stored procedures , that
every execution of the same stored procedure after the first takes minutes
rather than 2 seconds.  I am using the same parameters etc. If i run the
stored procdure from the query analyser is takes 2 second every time.

The following code resets this condition

adoCmd.ActiveConnection = AdoCn

Another machine in the same department which doesnt have 2.7 doesnt have
these issues.

Its a bit of a bizarre one.  Guessing it is a bug with 2.7 anyone know where
there might be a bug list.

Thanks in advance


Fri, 20 Feb 2004 23:46:40 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Datagrid with ADO 2.7

2. ADO 2.7 in VB.NET

3. Setting the ActiveConnection property of a Command Object (ADO 2.7)

4. ADO 2.7 recordset binding

5. ADO 2.7 in VB.NET

6. using ADO 2.7 on Windows 95 machine

7. ADO 2.7 in VB.NET

8. ADO 2.7 and References

9. ADO 2.7 mishandling Identity fields

10. ADO 2.7 Libary Question?

11. Question Ado 2.7 Field Object , Vb6.0

12. error ado 2.7


Powered by phpBB® Forum Software