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

 Have you tried "attach" in SMS?

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

HTH.

Thank you.

-- Mark Kamoski 

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?

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.