In EM go to Linked Servers > Providers > VFPOLEDB > Properties > Provider Options and try checking the Allow inprocess box.
>Hi All, I just setup a linked to server to access some old Fox4Dos tables and receive one of two errors when executing my SP, my SP (cutdown ) is this
>
>
>Select A.f1,A.f2
>from lcs...Account A
>Where A... etc
>
>
>I either get "The provider ran out of memory" etc...
>or "Couldn't convert the data value due to reasons other than sign mismatch" etc...
>
>any ideas ?
--sb--