CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:
Zone: > NEWSGROUP > Asp.Net Forum > visual_studio.visual_studio_2005 Tags:
Item Type: NewsGroup Date Entered: 12/24/2007 12:01:37 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 3 Views: 14 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
4 Items, 1 Pages 1 |< << Go >> >|
biobot
Asp.Net User
SQL Server Management Studio Express does not open my database12/24/2007 12:01:37 AM

0/0

Hi,

I created a database in Visual Studio 2005 Express and the program I created seems to be writing to it OK (no errors at debug). But when I try to open the database with SQL SMS Express, I get the following error message:

"There is no editor available for 'C:\pathname\filename.mdf'. Make sure the application for the file type (.mdf) is installed."

In VS2005 Express, my database and table are visible, and the connection checks out, but the data doesn't appear. I am aware that there are two copies maintained, one in the solution folder and one in the bin, but shouldn't I be able to verify that data is being recorded to one of them?

BTW, I posted similar on SQL Forum, and was referred back to this one??? 

biobot

biobot
mkamoski
Asp.Net User
Re: SQL Server Management Studio Express does not open my database12/24/2007 12:37:18 AM

0/0

 Have you tried "attach" in SMS?

Right-click the "Databases" node, choose "Attach", etc.

HTH.

Thank you.

-- Mark Kamoski 

http://www.WebLogicArts.com
biobot
Asp.Net User
Re: SQL Server Management Studio Express does not open my database12/24/2007 3:09:01 AM

0/0

Mark,

Great minds think alike, well anyway I did try that. This is what I'm seeing in the DB in my project's bin folder. The first row is seeded, but I don't know what the other row means? I may be wrong about my program writing to the DB?

0                                                  11/21/07   NULL 17:30                                              21:00                                              2:30                                              
Int32                                              String     String                                             String                                             String                                             String                                            
NULL NULL NULL NULL NULL NULL
 

 

biobot
Benson Yu - MSF
Asp.Net User
Re: SQL Server Management Studio Express does not open my database12/26/2007 3:06:55 AM

0/0

Hi biobot,

SQL Server Management Studio Express is tool that can connect to the SQL Server instance, so that we can use it to manage the objects in the SQL Server instance. However, it can not directly the open the database file via ?File | Open | File?? (except mobile database).

If you need to use SQL Server Management Studio to view othe objects in a database, the database must already been registered in the SQL Server instance. To register an existing database in a SQL Server instance, you can use ?Attach? like mkamoski said.

By the way, the table you posted does show any information to us. You probably need to clarify what the object type. Is it a table or view? What?s the table name of view name? Additionally, post the column name will be helpful.

Sincerely,
Benson Yu
Microsoft Online Community Support

Please remember to click ?Mark as Answer? on the post that helps you, and to click ?Unmark as Answer? if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
4 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Pro Excel 2007 VBA Authors: Jim DeMarco, Pages: 361, Published: 2008
Beginning DotNetNuke Skinning and Design: Skinning and Desing Authors: Andrew Hay, Nina Meiers, Shaun Walker, Pages: 432, Published: 2007
Pro Access 2007 Authors: Martin W. P. Reid, Pages: 395, Published: 2007
Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours Authors: Alison Balter, Pages: 436, Published: 2006
Client-Side Reporting with Visual Studio in C# Authors: Asif Sayed, Pages: 465, Published: 2007
Professional Community Server Themes Authors: Wyatt Preul, Benjamin Tiedt, Pages: 337, Published: 2007
Beginning SQL Server 2005 Express for Developers: From Novice to Professional Authors: Robin Dewson, Pages: 436, Published: 2007
Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers Authors: Brennan Stehling, Pages: 408, Published: 2007
Accelerated SQL Server 2008 Authors: Rob Walters, Robert E. Walters, Michael Coles, Robin Dewson, Robert Rae, Fabio Claudio Ferracchiati, Donald Farmer, Jan D. Narkiewicz, Pages: 816, Published: 2008
Beginning Transact-SQL with SQL Server 2000 and 2005 Authors: Paul Turley, Dan Wood, Pages: 570, Published: 2005

Web:
SQL Server Management Studio Express does not open my database ... SQL Server Management Studio Express does not open my database. Last post 12-25- 2007 10:06 PM by Benson Yu - MSFT. 3 replies. Sort Posts: ...
SQL Server Management Studio Express To connect to a SQL Server Express Database Engine instance by using SSMSE ... The 2005 version of Management Studio does not work with Server Express 2008. ...
SQL Server setup SQL Server Management Studio Express 2008 Like an idiot, I downloaded and upgraded my 2005 SQL Server Express ... have a SQL Server Express 2008 database, but no Management Studio. ...
The Black Art of Writing a SQL Server Management Studio 2005 Add-In The SSMS tools pack (another free but not open-source) SSMS add-in say that they support SQL Server Management Studio Express. Other posts such as this one ...
Cannot open mdf file in Microsoft SQL Server Management Studio ... 4, Cannot open (.mdf) files with sql server management studio express ยท SQL Server 2005 .... I did not attach the mdf file to my database instance. ...
SQL Server Management Studio Express 2008 2005, and my 2005 database is no longer available. .... Server Management Studio Express and it did not run. This is what I ...
SQL Server Management Studio Express won't open but appears in ... SQL Server does not short circuit this and I suspect that the .... The next day, when I try to open SQL Server Management Studio Express I get the Startup ...
SQL Server 2005 FAQ - ORCS Web, Inc. Managed Complex Hosting Solutions How much does it cost to upgrade my Shared SQL Server database to SQL Server 2005? ... Microsoft SQL Server Management Studio Express (SSMSE) provides a ...
TheMSsForum.com >> SQL Server >> Management Studio Express File ... I accidentally created a sh*tload of tables in my database. .... \SQL Server Management Studio Express\Projects which is not where I want to save my files. ...
sql server management studio express data attach won't open some ... I am unable to attach the database in my instance of sql server 2005 express ... I'm still not certain while Management Studio Express will ...




Search This Site:










include .js file - master page or content page ???

type casting nullable value

authentication and levels

robots.txt file

help - operation must use an updateable query.

render at desing time in webcontrol

vb.net to c#

getting filesize with file upload

online webcam

domain permissions

scheme information in dataset

calendar problem

connecting to a database

webpage background is becoming with popup window

authentication roles

0.95

assign a default role with createuserwizard

custom membership provider for sql server modified from msdn source causing an error on creating account

datatier to datagrid (or other control)

form submit in dnn text/html module

integrating asp.net membership with my application

dataset questions...

deleting a streamed file.

design survey with asp.net

defining custom item templates in web projects

individual level security

skinobject with database access

linking dynamic drop downs

how to upgrade module from dnn v1 to dnn v2.2?

quick fix for the date problem
 
All Times Are GMT