Hi, I am unable to create a new database within Visual Studio. I can however create a database in SqlExpress and then see it in Visual Studio, but once in Visual Studio I can’t seem to do anything, e.g. If I right click the ‘Tables’ icon within a database in Visual Studio I should be able to click to create a ‘New Table’. But the only things I see when I right click the ‘Tables’ icon are ‘Refresh’ and ‘Properties’.
Also, when I create a Data Form Wizard, I first select the ‘Microsoft OLE DB Provider for SQL Server’ . I then go to the ‘Connection’ tab of the wizard and put in ‘(Home)\NetSDK’ as my server name, I then select ‘Use Windows NT Integrated security’ and then I am able to Select the database I want from the drop down list. Once I have done this I am able to go to the ‘Choose tables and views’ section of the wizard and I am able to select a table in the Available Items list and click the > button to move it to the selected Items list. After I have selected the table I click ‘Next’, and this is the point when I get a pop-up box that reads:
‘The following error occurred:”There were errors configuring the data adapter.”
Can anyone give me any pointers as to what might be going wrong here?