Hi,
I created a query in my MS Access database. I'm trying to add the query to a dataset I've created in VS2008 by dragging it from Server Explorer into my dataset.
My problem is that my query shows up under 'Functions' (ie. NOT under Views), and when I drag it into my dataset I get a Merge Data Objects Issues message with the following warning:
Parameter information for stored procedure/function could not be retrieved. parameters collection will be empty.
I don't have any parameters in my query, but I am using the Nz function in the query.
Any ideas of how I can add this query to my VS project?
Thanks,
I created a query in my MS Access database. I'm trying to add the query to a dataset I've created in VS2008 by dragging it from Server Explorer into my dataset.
My problem is that my query shows up under 'Functions' (ie. NOT under Views), and when I drag it into my dataset I get a Merge Data Objects Issues message with the following warning:
Parameter information for stored procedure/function could not be retrieved. parameters collection will be empty.
I don't have any parameters in my query, but I am using the Nz function in the query.
Any ideas of how I can add this query to my VS project?
Thanks,