1. connection string i try { ADS (ADS OLEDB / .NET Provider) also Provider=vfpoledb.1}

// ADS base Connection String, this work fine if both end use Advantage, but if xbase++ program do not use Advantage connection then "Locking situation "Occur" whoever access first another get file lock error. string connectionString = string.Format(@"Provider=Advantage OLE DB Provider;data source={0}; Advantage Server Type=ADS_REMOTE_SERVER;SecurityMode=ADS_IGNORERIGHTS;TableType=ADS_CDX;", folderPath);

to fix this i use : string connectionString = string.Format(@"Provider=vfpoledb.1;data source={0}; Advantage Server Type=ADS_REMOTE_SERVER;SecurityMode=ADS_IGNORERIGHTS;TableType=vfp;", folderPath);

1. My Novell server environment :

I have Novell Server and there ADBANTAGE 9.1 is install and all the Xbase++ / Caliper based written program access DBF file from that location using Novell window client :Userame /password

now im trying to build some webservice using VS2008 / Visual studio 2010 ( C# ) to access those .DBF file ( Read and Write ), and if i use ADS .NET provider then im able to do that, but if file not open by non ads program.

1. when it works when not works, So i tried with "vfpoledb.1" it works only via VS debug mode but not works in IIS "when i publish in IIS its giving me this error " System.Data.OleDb.OleDbException: Invalid path or file name. at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at NovelDBFConnector.DAL.Connect(String connectionString) in D:\NovelDBFConnector\DAL.cs:line 39 at NovelDBFConnector.DAL.ExecQuery(String connectionString, String qry) in D:\NovelDBFConnector\DAL.cs:line 55 at NovelDBFConnector.BLL.GetProductDetail(String barcode) in D:\NovelDBFConnector\BLL.cs:line 94 at NovelDBFConnector.PCheckService.GetProductDetail(String barcode) in D:\NovelDBFConnector\PCheckService.asmx.cs:line 24 "

2. My application type is asmx web service using WSDL.