I have a code provided below it runs on some machine and dosen't on some ..Means some time it dose not open connection and some time gives error on GetOleDbSchemaTable ..

Can any one help..



String sConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Data.xls;Extended Properties=""Excel 8.0;HDR=Yes""";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
// Get the data table containing the schema
DataTable dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables , null);

Try checking the MDAC versions installed on the two machines. This sounds like a discrepancy between database engines.

-Peter

Thanks Planoie
I have worked it out what I did
<identity impersonate="true" userName="domain\user" password="pwd" />
and in your C:\Documents and Settings\Default User\Local Settings\temp
agve permission to the user it worked