I have created a new Project from existing 2005 code (c#). After the conversion one of my datasources was not functioning the other was fine. The xsd file was there but could only be viewed in XML. After looking at it extensively, I finally figured out that about 1/3 of the xml code was missing. So I copied the remaining xml code from the original projects xsd file and pasted it into the new xsd file. After saving the xml code viola the visual part of the xsd file returned seemed to be in tact. I did a rebuild all and the project compiled and ran. All the data tables are loading data correctly.
However, when I try to execute one of the sql queries in the xsd file in the msvs 2008 IDE the following error is returned
FbMobileDBDataset.HorseM2.Fill could not be previewed
Cannot obtain provider factory for data provider named 'Microsoft.sqlserverce.client'
How can I add this referance to the project, this because there is no way now to add or change queries in the ide now?