Sunday, February 12, 2012

cannot generate ResultSet code

I am using Visual Studio 2005 and SQL Server mobile edition. From Visual Studio I went to Data->Add New Data Source. From there I created and added an SQL server Mobile database. I want to use result sets instead of data sets. A file was added to my profect called: "databaseNameDataSet.xsd". In the properties for that file, when I change the Custom Tool property to MSResultSetGenerator, I get the following error:

Failed to generate ResultSet code. Typed ResultSets are only valid for Microsoft SQL Server Mobile Edition databases.

But I am using a SQL Server Mobile Edition database. Any help will be appreciated.

We have tried to do the same but everything seems to be working on our side. Can you please let us know the exact repro steps so that I can repro here locally. Also can you try doing yourself the same steps in a fresh project?

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||I have tried starting a new project and doing it with an existing project. You asked me to tell you the steps I did, but I already told you all the steps. I did finally get it working by starting a new project and adding an example database(northwind). For some reason that worked. I think somehow when it doesn't work, is when I create a new database, and it shows up in my solution explorer and in my server explorer, but not in my data sources. Why would it not be in my data sources when I just added it using the method mentioned where I choose add new data source? Anyway, even though I don't know what I did I finally got it addded as a data source, and it is working for now.|||

Glad that things are working on your end. Thanks for using SQL Mobile.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||i had to remove the |DataDirectory| tag in my connection string then it worked , when i add it back in the MSResultSetGenerator fails.

No comments:

Post a Comment