>OLE DB Provider is installed and shows the erroro in my first post
>
>ODBC driver is also installed but it doesn't show when I open up ODBC even though machine has been rebooted

I'm not following you. What VFP Driver version you see in the Odbc Manager?

>
>I'm a bit stumped - I'm happy to use either method

It's up to you wich one to use.