Typed DataSets in MS Access with Stored Procedures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using VS 2005 and a MS Access 2003 DB. In VS I use the server explorer
to drag and drop tables and existing queries into the dataset designer
window. I am having several problems.

1. In the Server Explorer tables are under the Tables folder but queries are
under the Views folder or if they have parameters they will be under the
Functions folder but never under the Stored Procedures folder. How does the
Server explorer classify MS Access queries?

2. For queries (i.e. "Views" or "Functions") in the dataset designer
whenever I use the "TableAdapter Configuration WIzard" Stored Procedures is
grayed out and only the "Use SQL option is available". How can I make those
other options available?

3. The main problem is queries which already exist in my database. I
cannot seem to fill the DataTableAdapter with any data. There are no errors
but no data either. I tried the same query inside MS Access and it does
return data. The datatable adapter for my tables works fine. I did use the
dataset properties window for the query to change the command type to "stored
procedure" but it still cannot retrieve any data. Why?

By the way if I manually code a non-typed dataset for a "stored procedure"
it works fine.
 
Since the initial post I discovered the problem was with the fact that in my
Access DB I was linking tables in a SQL Server DB. Although I could populate
the dataset with the linked tables I could not populate the dataset with data
from a query.

I then tried direct assess (read only) to the SQL Server DB and created a
querydatatable. The query wizard would only let me create a query that
returned scalar value. The option to return multiple rows was grayed out.
Why can't I develop a query that will return rows.
 
Back
Top