.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Database Explorer missing in VS2010

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :ASP.Net
 

I uninstalled VS2008 and set up VS2010. Since I already have SQL Server 08 Dev Edition in my computer, I didn't select the SQL Express option during the setup. When I try to add a new SQL Server Database item to an ASPX file of a website, it fails and the following message shows.

Connections to SQL Server database files (.mdf) require SQL Server 2005 Express or SQL Server 2008 Express to be installed and running on the local computer. 

However I can drag a SqlDataSource control to the page and successfully connected to a table of an existing .mdf. The only problem is I can't access the Database Explorer.

How can I solve this problem?




View Complete Post


More Related Resource Links

VS2010 Express ASP.net and database file with SQL Authentication

  

Hi,

I have installed Visual Studio 2010 Express in my local system.

Steps
1. File->New Website
2.Open datbase explorer, right click on dataconnection
3.Select Create new connection
4.use Microsoft SQL Server Database file
5. Type new databse filename
6. Now i want to use SQL authentication which is not working
7.If we use windows authentication its wokring without any problem
8.But i need sql authentication to be used.
9.I have not installed SQL studio. I am only using the one which is packaged in VisualStudio 2010 SQLClient.

Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication.

Thanks and regards
Mahesh kotekar
http://mahesh.kotekar.com  


VS2010 Express ASP.net and database file with SQL Authentication - How to create database file with

  

Hi, I have installed Visual Studio 2010 Express in my local system.

Steps 1. File->New Website

 2.Open datbase explorer, right click on dataconnection

 3.Select Create new connection

 4.use Microsoft SQL Server Database file

5. Type new databse filename

6. Now i want to use SQL authentication which is not working

 7.If we use windows authentication its wokring without any problem

8.But i need sql authentication to be used.

 9.I have not installed SQL studio.

 I am only using the one which is packaged in VisualStudio 2010 SQLClient. Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication.  I know that VS2010 setup also installs the SQL client which is requiredto create and manage sql databse files/quries etc

 

i dont know the default userID and password for SQLauthentication. As the express setup did not asked any credentials while installing SQL components

 

Thanks and regards

 Mahesh kotekar

http://mahesh.kotekar.com


cannot attach database from server explorer

  

Hello all,

In Server Management Studio, I am attempting to attach a database.  After selecting the database in the wizard

I receive an error: This file is in use, Enter a new name or close the file that's open in another program. 

I don't have SSMS open, and have restarted the computer to make sure the memory is cleared.  Not sure what to try next.  Any ideas?


Missing Database Node using SSMS 2008 Express

  
Hello,It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS the database node is missing.Before:After: I tried refreshing the database folder but still nothing. I even uninstall but it's still the same.Thank You for your help,-imperialx

Missing Database Node in SSMS 2008 Express

  
Hello, It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS and login back, the database node is missing. I have asked this question over at asp.net forums with images (http://forums.asp.net/t/1600718.aspx).   Thanks, -imperialx

VS2010 Deploying Database Project - Error: Cannot create file [...]MSSQL10.MSSQLSERVER\MSSQL\DATA\m

  
I had SQL Express from a previous installation of VS2010. I uninstalled All SQL and VS2010 and re-installed VS2010 (without Express) and then re-installed SQL Server 2008 Developer Edition. Now when I try to deploy a database project I am receiving the following error:     Creating EDDY.Cheetah.Database.Server... ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 5170, Level 16, State 1, Line 1 Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf' because it already exists. Change the file path or the file name, and retry the operation. ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 1802, Level 16, State 4, Line 1 CREATE

First Steps with VS2010 RC - System.Drawing; missing?

  
I'm a little confused! I was curious about the new VS2010 RC and as I wanted to start with a new Software Project I  wanted to give it a try. 1. Installation troubble with Silverlight but VS2010 loads without errors. 2. Now I wanted to try out this things with a full aero window and found a nice and simple code snipplet on the MSDN .NET FW4 Extend Glass Frame Into a WPF Application So I made this short changes in my first source code and I'm getting the strange message: Error    1    The type or namespace name 'Drawing' does not exist in the namespace 'System' (are you missing an assembly reference?)    D:\Projekte\Selfmade\Software\CAS_Information\CAS_Information\MainWindow.xaml.cs    19    14    CAS_Information I found a lot of c# code with a using System.Drawing; but on my installation I dont have such a namespace. What the heck is wrong there?   Windows 7 x64 - VS2010 RC

Cannot create database diagrams for sqlexpress .mdf file in Visual studio server explorer

  

Hello!

I've look around the forums but I can't get the solution for my problem. I've installed Visual studio 2010 with sqlexpress edition. Then I have renamed my computer. After renaming my computer I've deleted the directory C:\Users\uporabnik\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS. After restart, I have started VS2010, open Server explorer and I've added the connection to a new database. I've been able to add new tabels, bu when I've tried to add a diagram, it didn't work. In properties window od the database I saw, the the database owner was oldComputerName\username not newComputerName\userName. In sql server management studio I've reanmed the user oldComputerName\userName to newComputerName\userName. After attaching the database it worked fine.

I've returned to Visual studio 2010. When creating new database, the owner of new database is oldComputerName\userName. The next tip was renaming the  SQLServerMSSQLUser$ComputerName$SQLEXPRESS(and other names with sql...) in Local Users and gorups in Mange My computer. After restarting the compter I've got the same result. When creating new .mdf file in server explorer of visual studio, the database owner is oldComputerName\userName.<

Where to place code to update database using WPF in VS2010?

  

I have an app in WPF that has numerous controls that are bound to datatables that are filled from sqlserver.

I now need to add the code for updates, inserts and deletes

Where should I put the code to implement this?

I found code

this

._adapter.UpdateCommand.CommandText = "tool generated update command


in an auto-generated section of the source file that VS created it looks almost correct but I have never before seen an update statement with an order by clause.
I also found multiple instances of:
  if ((this .Adapter.UpdateCommand != null )) {
 this .Adapter.UpdateCommand.Connection = value ;             }
But I cannot find where value is defined or assigned
I have a tabbed interface with a selection list to move back and forth through the datatable. I want to update the data base with all changes to the current selection when a user changes selection or selects a different tab So what is the preferred method to initiate the update and where should

Event handler lightning bolt missing in VS2010

  

I have recently upgraded from VS2008 to VS2010 after a few months away from ASP.NET coding and I am hitting a problem I never had before. I seem to remember having a lightning bolt icon in the properties window for a web form that would automatically create the skeleton event handler code for any one of a range of page events. However, I cannot see this lightning bolt anywhere in VS2010.

Some guidance would be much appreciated. It would be a chore to have to create this code every time from scratch.

David  


oledbdm.h is missing (Win7, MSSQL 2008 & VS2010 beta)

  
Hello All,

I decided to write my first plug-in algorithm. I downloaded the DMMgdPlugInAPI.msi package, but the wrapper will not compile due to oledbdm.h missing on my system. I've searched my filesystem and double-checked to ensure I had the MMSQL SDK installed. Do I need to install SQL 2005(The word doc says it is installed with 2005) or is there some other way to get the header & library files under 2008? I can successfully compile SQL Server assemblies that have custom aggregates and functions in them. So, I know the compiler install works. 

Any help or suggestions would be greatly appearciated.

Thanks!

few sites are missing after taking backup and restore the content database

  

Hi All,

We have taken the backup of content database and restored it in the new server, after that attached the content database on sharepoint central admin, but few sites are missing after this. when checked the database server Number of records are matching in both the servers content database and also the data is matching, but still we are missing few sites. Do we need to do any specific change in sharepoint or database?


Missing column in MSlogreader_history table in the distribution database

  
We recently built a new two node cluster on a Windows 2008 R2 64bit OS. We installed SQL 2005 64bit Enterprise with SP3 and CU7. We want to run replication from node 1 (1 instance - publisher) to node 2 ( 2 instances - distributor instance and a subscriber instance). We use scripts to build transactional replication (push). These scripts have been used before in an identical setup except it is CU3 instead of CU7. On our new setup, with CU7, the MSlogreader_history table in the distribution databse is missing the @updateable_row column. We only have 15 columns in this system table on our new CU7 setup. The older CU3 setup has 16 columns in the MSlogreader_history table including the updateable_row column.

Replication monitor shows an error stating that the sp_MSadd_logreader has too many arguments specified (Code 1007).

Why is our MSlogreader_history table missing the updateable_row column, and how can this be fixed?

VS2010 Professional Toolbox tab "Data" Chart is missing

  

I installed VS2010 professional on on a clean Windows 7 laptop.

I opened VS2010 and selected an existing Framework 3.5 project solution that I knew used charting. The conversion wizard seemed OK. However, on the Toolbox under the Data tab, there is no entry for "Chart" as several sources suggest this where it should be. There is also an error message objecting to "Imports System.Windows.Forms.DataVisulaization.Charting". Can anyone please tell me what I have to do to put this right? Is it a missing dll? 


ODBC: My Database missing in list of default databases

  

Hello everybody

I have the following problem:

When creating a new ODBC data source to an SQL Server 2k5 I want to change the default database from 'master' to my database 'addresses'.

However my database 'addresses' doesn't appear in the drop down list.

I'm conneting with the 'sa' account.

I've activated all protocols in the SQL Server Configuration Manager.

What shall I do?

 

Any help is greatly appreciated.

Dominique.

 


Can't add an connection to database in VS2010

  

I used Data Connections to connect a database but couldn't make it.

1. I used Windows Authentication to log on to database, my database's name wasn't displayed in Select or enter a database name dropdown menu, so I enter my database's name then I pressed Test Connection button, it said "This connection can't be tested because the specified database doesn't exist or isn't visible to the specified user."

2. So I used SQL Server Authentication to log on to the server,then I put my database's name in Select or enter a database name dropdown menu box, then press OK it's said that "Login failed for user 'xxx' or Try to press Test Connection button it said that "Login failed for user 'xxx'.

I'm sure that I use a correct username and password and I think it's a problem about VS can't see my database in SQLExpress2008.

please give me an advice to solve the problem.

many thanks


Copy Database Wizard: Cannot choose databases, checkboxes are missing

  

Hello,

I try to move databases from one SQL 2008 R2 to another SQL 2008 R2 Server with the copy database wizard.
On the page where I should choose the databases to move or copy the checkboxes are missing. The databases are listed but no way to choose one of them.

I searched a lot but did not find out what the reason could be for this.
Any hints are appreciated, thank you!


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend