How to attach database

[ad]

I am useing SqlServer Express 2005.
I have a Database files in c:\db, the files is like db.mdf and db.ldf.
How can I attach them the the SqlServer Express with program?

 

[Mesut]

I assume you need to set up a connection string.
But I have problem setting up the connection string so I post a
question like you:
TOPIC: Something is wrong in my SQL ConnectionString but what?

Hopefully someone can respond on our e-mails so we learn both how to
do...

Mesut

 

[Patrice]

Try :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp

(the connection string now accepts a new AttachDBFilename property)

 

[Sahil Malik [MVP C#]]

Download SSEUtil from the web.
http://www.microsoft.com/downloads/...28-173F-472E-A85C-27ED01CF6B02&displaylang=en
and use it to attach/detach your database from the running instance of SSE.
It is very much like SQLCmd, but much friendlier.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

 

[ad]

It is amazing about the new AttachDBFilename, I am trying the posible of it.
but I end up with a problem.
I am using VS2005 to develop web application
My SqlServer is Sql2005 Standard. When I use the AttachDBFilename in my
connection, it is ok for general asp.net page. but when I use the connection
as typed dataset, it fail with message: "The user instance login flag is not
supported on this version of SqlServer.

Is user instance just support Sql2005 Express?