SQL Server Express Attach

  • Thread starter Thread starter elziko
  • Start date Start date
E

elziko

I am trying to create a conneciton to an SQL Server Express database from
..NET. Here is my connection string:

'Data Source=.\SQLEXPRESS;AttachDbFilename="c:\database.mdf";Integrated
Security=True;Connect Timeout=30;User Instance=True'

However, I get the following error:

'An attempt to attach an auto-named database for file c:\database.mdf
failed. A database with the same name exists, or specified file cannot be
opened, or it is located on UNC share.'

I then used SSEUtil to list all attached databases and it was not there, and
I also tried to detach it anyway but I was told that 'No valid database path
matches teh value specified.' and rightly so.

But then I tried to attach the database from within SSEUtil and it quite
happily attached the database just fine. Surely if I can't attach using
ADO.NET that why can I attach using SSEUtil?

Any ideas?

TIA
 
Andrew said:
See if these help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing
Express with MSDE
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
User Instances
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring
Express for Remote Access
Click to expand...

Thanks, I read through those links and didn't find anythig that really
helped. From what I see teh way I'm connecting shouldn't cause any problems!
It almost seems like SSE things the database is still attached when its not.
FWIW, the mdf I'm using is on my local machine.
 
How are you trying to attach from .NET? are you using C# or an ASP.Net
Page? I assume you're using .Net 2.0. Can you attach from the IDE? How
did you create this database in the first place?
 
Roger said:
How are you trying to attach from .NET? are you using C# or an
ASP.Net Page? I assume you're using .Net 2.0. Can you attach from
the IDE? How did you create this database in the first place?
Click to expand...

I found a tiny typo when I was building my connection string where I was
using a forward slash instead of a back-slash. Very frustrating!

Thanks to both of you for helping though!
 
Back
Top