>>Hy !
>>
>>I'have this little problem
>>
>>In my VB application (ADO), when i'm running a query through ODBC,
>>it's 10 times slower than in the Query analyser of SQlServer.
>>
>>Is there a way or a method to execute it faster ???
>>Like a passthrough query ?? that is not interpreted by ODBC
>
>Why do you use ODBC? You can connect directly to SQL using ADO.

If you mean the OLEDB provider I would rephrase that to: with one less layer of abstraction. Or is there something else that you can connect to SQL with ADO?