- Can access FoxPro from .NET?
Yes, you can use the FoxPro OLE DB Driver provided by Microsoft, to connect to FoxPro through .NET. It may be done in C# the following way:
OleDbConnection oleDbConnection1 = new OleDbConnection("Provider=VFPOLEDB.1;"+
OleDbConnection oleDbConnection1 = new OleDbConnection();
oleDbConnection1.ConnectionString = "Provider=VFPOLEDB.1;" +
According to Microsoft, this works with at least Visual FoxPro 7. FoxPro 2.6 does not support DBC files, and as such you would have to access it the DBF way (according to programmer2programmer at least), such as :
"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general;"
Note that the first link also mentions how to configure and test the connection in Visual Studio (if you are using it of course). As for your second question,
- Can I put triggers on FoxPro 2.6?
Unfortunately, No, you can't create triggers in FoxPro 2.6 (thanks to user @Morons and the Internet)