"ObjectTypeName must be specified" when creating new query
Posted: Tue 29 Aug 2006 17:18
I have a dataset with several datatables in it.
It works fine when there are no parameters in the query. If I add a TableAdapter with a query that includes parameters, I get message:
ObjectTypeName must be specified
when I click the "Finish" button on the wizard. At this point, the datatable is created, but contains no columns. To get a table created, I first must create the table with no parameters. That works fine. I then go back into the query and add the parameters. I will still get the error when I click "Finish", but then I go into the parameters on the Select statement, and change the DBType from "Object" to Int32 (or whatever) and the ProviderType changes from null to a valid type.
If I go back into the query to make a change, it happens all over again and I must go through all the parameters resetting the types.
I am using Studio 2005 and OraDirect.Net Pro, version 3.50.12.0. Using a direct connection to Oracle.
Thanks
Patrick Connelly
It works fine when there are no parameters in the query. If I add a TableAdapter with a query that includes parameters, I get message:
ObjectTypeName must be specified
when I click the "Finish" button on the wizard. At this point, the datatable is created, but contains no columns. To get a table created, I first must create the table with no parameters. That works fine. I then go back into the query and add the parameters. I will still get the error when I click "Finish", but then I go into the parameters on the Select statement, and change the DBType from "Object" to Int32 (or whatever) and the ProviderType changes from null to a valid type.
If I go back into the query to make a change, it happens all over again and I must go through all the parameters resetting the types.
I am using Studio 2005 and OraDirect.Net Pro, version 3.50.12.0. Using a direct connection to Oracle.
Thanks
Patrick Connelly