>Hi Rick
>
>The reason for looking a direct connection without odbc between vfp and sql server, is the speed and stability.
>
>for example in some tests, some times updating 60 records from a view takes 5s and others takes 1:30 mn through views.
>
>Anyone can replace odbc or odbc drivers. And with a system of 100 terminals, this is not a good idea.
>
>and a direct connection is obviously faster. And vb has it through an ocx.
>
>We use shared connections, and all we can to optimize. We tried all, for example we reinstalled from zero, windows95 and installed visualfox pro odbc, to see if this could be faster; we tried intersolv, etc.
>
>Now we had decided to use developer 2000 and ORACLE WORKGROUP for big systems. we think they´re better.
>
>But we still would like to know if there is and option, like in visual basic, to connect without odbc.
>
>Please don´t emailme to
jdaza@bo.net, because the satellite is giving us problems. And some friends sentme emails that never reach us.
>
>Thanks
>Juanqui
if you have an ocx file that lets you do this in vb, try the ocx in vfp and see what it does. it should work the same, but i've heard of some cases where an ocx will work in one but not the other...