Results 1 to 2 of 2

Thread: Wingtip Toys / importing DB with management studio

  1. #1
    .NET Framework
    .NET 4.5
    Join Date
    Jan 2019
    Posts
    1
    Rep Power
    0

    Wingtip Toys / importing DB with management studio

    Hi,

    i would like to use the wingtoys example with Management Studio and not with "Express".
    When starting VS2017 with the .sln file i get a error about that theres no express found for the database, how do you circumvent this?

    The tutorial comes with 2 DB files:
    aspnet-WingtipToys-20140821031535.mdf
    wingtiptoys.mdf

    when importing the wingtiptoys.mdf with management studio it works without errors but the database is shown as: WINGTIPTOYS_acd665c8c6124f2c8101d17272a8192e - Why is that?

    So the normal connection string looks like this:
    <!--<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-WingtipToys;Integrated Security=True" providerName="System.Data.SqlClient" />
    <add name="WingtipToys" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirec tory|\wingtiptoys.mdf;Integrated Security=True" providerName="System.Data.SqlClient" />
    </connectionStrings>-->

    and this is the one im using currently:
    <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=WINGTIPTOYS_acd665c8c6124f2c8101d17272a819 2e;Integrated Security=True;" providerName="System.Data.SqlClient" />
    </connectionStrings>



    this is the german error i get, sorry dont know how to translate that.
    Netzwerkbezogener oder instanzspezifischer Fehler beim Herstellen einer Verbindung mit SQL Server. Der Server wurde nicht gefunden, oder auf ihn kann nicht zugegriffen werden. Überprüfen Sie, ob der Instanzname richtig ist und ob SQL Server Remoteverbindungen zulässt. (provider: SQL Network Interfaces, error: 50 - Fehler in der Local Database Runtime. Es kann keine automatische Instanz erstellt werden. Fehlerdetails finden Sie im Windows-Anwendungsereignisprotokoll.
    )



    is there maybe a better example to start learning simple asp.net applications with webforms that works out of the box?
    I have to use Dot Net 4.5.1 or 4.7.2.

    Tutorial Url:
    https://docs.microsoft.com/en-us/asp...n-and-overview

  2. #2
    .NET Framework
    .NET 4.5
    Join Date
    Apr 2011
    Posts
    1,998
    Rep Power
    155
    I would expect that you would be able to attach the database to your SQL Server instance in SSMS and then you can change the connection strings as required. You can visit www.connectionstrings.com to learn how to write a connection string.

Similar Threads

  1. Question Resturant management system with database
    By Leen in forum C# General Discussion
    Replies: 1
    Last Post: 08-05-2018, 8:41 PM
  2. Question Inactivity Management Through a Hoot Mouse Keyboard
    By VanDream in forum Reporting / Printing
    Replies: 0
    Last Post: 11-18-2016, 4:54 AM
  3. Question Issue with Session Management
    By ruchika0015 in forum Web Services
    Replies: 0
    Last Post: 04-08-2014, 10:30 AM
  4. Automatic vs manual memory management
    By Romulo in forum C# General Discussion
    Replies: 2
    Last Post: 12-19-2013, 1:25 PM
  5. external app management
    By chare in forum C# General Discussion
    Replies: 0
    Last Post: 02-07-2013, 1:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •