I'm trying to create a script where I can query a Visual Foxpro table with an ODBC Connection and the Query Database function. I emailed support and they suggested I post with a sample of the table zipped up.
This is the copy of the email I sent them.
I have a client that has a Visual Foxpro Database. I’ve created an odbc connection and am trying to run a “Query Database” on it to test retrieving data. I’m not sure what should go in the three fields. The odbc name is “Check”. It is a table that has 3 fields, they are check,amount,iussed. In other words check number, amount and issue date. I wanted to do a very basic Sql query and say the amount. So I’m guessing I could say “Select check, amount,issued from check where check=’1’. It fails every time. I’m guessing because I didn’t put anything in the two previous fields. I’m not sure what goes in the fields ADO.NET or Connection string. Any help would be greatly appreciated.