hi
i am opening foxpro 2.5 database in my ASP application. its working fine when i am opening it with the following line on the same machine:
cn.Open “Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=Driver={Microsoft FoxPro VFPDriver (*.dbf)};UID=;SourceDB=C:\Prod\pso\crm\db\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;”
but not working while database is on the other machine and using this line:
cn.Open “Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=Driver={Microsoft FoxPro VFP Driver (*.dbf)};UID=;SourceDB=\\reporter\db;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;”
please help