SQL Express database disappears upon connection attempt from Visual Basic Express

Posted on 2006-04-24
Last Modified: 2008-02-01
I realize that the Visual Studio Express editions only allow one to use the wizards to connect to local data so I thought I'd try to code the connection to SQL Server 2005 Express. Using the first couple of chapters of StepbyStep and a trusted connection string "Data Source=jeff;initial catalog=Adostepbystep;integrated security=SSPI;" I get an error that the login has failed. What's worse is that every time there is an unsuccessful login, the original database disappears from SQL express. The only thing that remains is the database name -all the associated tables, views, etc are gone! Is there an online guide or book I can purchase to learn how to properly connect VB 2005 express to SQL server express databases. I will eventually purchase the Professional software products but have to wait for FY 07 - can anyone please help? Thanks
Question by:DOHMH
    LVL 28

    Expert Comment

    Check this site

    also try to use this connectionstring
    connection string
    <add key="ConnectionString" value="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Adostepbystep;Data Source=Jeff;U=xxx;P=xxx" />
    LVL 28

    Accepted Solution

    hi do you still need assistance

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how the fundamental information of how to create a table.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now