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