Hi Bharat,

You are trying to open vfp database/tables through MS SQL provider.

Check this site.
http://www.connectionstrings.com/

I hope this should help.



>Hi,
>
> I have create a connection like
> CREATE CONNECTION SCRUB CONNSTRING "Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};SourceDB=" + Destination_path_BT + ";SourceType=DBF "
>
>and then when I use the connection to create a view, I get the error
>"Error in connectivity error:[microsoft][odbc driver manager] Driver doesnot support this function"
>
>I am running "Create SQL VIEW rv_tbltemp2;
> connection SCRUB;
> as SELECT * FROM &gcTable order by claim_num"
> Actually it works fine when I run this in development environment. I get error only when I run on another computer that does not have Foxpro.
>
>Am I missing some file to copy there.
>
>Thanks & regards
>bharat