I'm having a problem, obviously. I have some old Foxpro tables I need to access, but they reside in different directories. Since C# requires that each directory be opened as a new connection, I see no way to execute one SQL statement across two different connections.
Its not possible for me to simply dump the tables into a Dataset and set up a relation, as ADO complains that I have multiple keys in one of the tables, and refuses to set up the relation.
So how do I execute one sql statement across two different connections? Am I simply out of luck? Thanks in advance
Its not possible for me to simply dump the tables into a Dataset and set up a relation, as ADO complains that I have multiple keys in one of the tables, and refuses to set up the relation.
So how do I execute one sql statement across two different connections? Am I simply out of luck? Thanks in advance