Have you benchmarked your results? If so, what are the differences in time? It is kind of hard to diagnose anything given your description below...

>Hello,
>
> I am using odbc connectivity in my application, this is bacause i have multiple databases eg .dbf .mdb as well as oracle.
>
> If i choose fox database in my application , this uses the odbc drivers for my sql. it seems that it is very very slow for query result. eg if i pass sql as select * from , it takes more time, it goes one by one records.
>
> but, this same query if i pass to fox, as fox database (not through odbc) it give results very fast. Is it any thing wrong with odbc or i am wrong.
>
> waiting for reply.
>
>TIA
>
>amit