MS SQL Server - SQL Server Express Attach

Author

SQL Server Express Attach

elziko

2006-02-25, 9:27 am

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

'Data Source=. \SQLEXPRESS;AttachDb
Filename="c:\database.mdf";Integrated
Security=True;Connec
t 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 J. Kelly

2006-02-25, 9:27 am

See if these help:

http://msdn.microsoft.com/library/d...sseoverview.asp
Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express
with MSDE
http://msdn.microsoft.com/sql/defau...expuserinst.asp
User Instances
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access

--
Andrew J. Kelly SQL MVP

"elziko" <elziko@yahoo.co.uk> wrote in message
news:O4urfpSOGHA.3984@TK2MSFTNGP14.phx.gbl...
>I am trying to create a conneciton to an SQL Server Express database from
>.NET. Here is my connection string:
>
> 'Data Source=. \SQLEXPRESS;AttachDb
Filename="c:\database.mdf";Integrated
> Security=True;Connec
t 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
>
>
>

elziko

2006-02-28, 8:23 pm

Andrew J. Kelly wrote:
> See if these help:
>
> http://msdn.microsoft.com/library/d...sseoverview.asp
> Express Overview
> http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing
> Express with MSDE
> http://msdn.microsoft.com/sql/defau...expuserinst.asp
> User Instances
> http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring
> Express for Remote Access

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.

Roger Wolter[MSFT]

2006-02-28, 8:23 pm

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?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"elziko" <elziko@yahoo.co.uk> wrote in message
news:%232BBnO4OGHA.140@TK2MSFTNGP12.phx.gbl...
> Andrew J. Kelly wrote:
>
> 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.
>

elziko

2006-02-28, 8:23 pm

Roger Wolter[MSFT] wrote:
> 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?

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!

Sponsored Links