I'm trying to create a simple web form with an OleDbConnection to a Visual FoxPro 7 database (DBC) using the ADO driver for VFP, and an OleDbCommand with an SQL Select query with one parameter. I want to put the results of the query, which should be a few rows from my table, into a DropDownList. The problem is that I always get an error when the OleDbCommand runs ("Object reference to non-object").
In the VFP table, the parameter field is numeric, N(2) to be precise. Visual Studio .NET creates a parameter collection with one input parameter of type Decimal. I can get this to work fine if the parameter field is character.
Can somebody please send me an example of working code that executes an OleDbCommand with a parameter against a VFP table, where the parameter field is numeric?
Thomas M. Lamm
Bradbury & Associates