Problem using MSFOxpro Provider,error could not open file
-
I am a GIS programmer in a company in India.I have seen your bog fixing in CODE comments. I have to Alter a DBF file , basically I have to add a column to my DBF table. but I am getting error like Couldn't open C:\final data\22.dbf file Same when I am using in other method with select query works fine ... I do hve the same problem which u faced but still I am not getting the right answer for this .Plz help me .The Code snippet which I am using is as follows. try { string ConnectionString="User ID=;DSN=;Collating Sequence=MACHINE;Data Source= ' C:\\final data\\22.dbf ' ;Provider=VFPOLEDB.1;Cache Authentication=False;Mask Password=False;persist security info=False;Mode=Share Deny None;Extended Properties=;Encrypt Password=False"; OleDbConnection dconn=new OleDbConnection(); dconn.ConnectionString = ConnectionString; dconn.Open(); OleDbCommand mycmd=new OleDbCommand(); OleDbCommand myCmd = new OleDbCommand("ALTER TABLE 'C:\\final data\\22.dbf' ADD UID int ", dconn); myCmd.ExecuteNonQuery(); } catch(OleDbException ex) { MessageBox.Show(ex.Message); } Plz help me in this regards,Its urgent Thanks a Lot Anil Dhiman GIS Engineer Nucleus Netsoft & GIS Ltd hi it is rudara