Connection to SQL Server only.

[Ken Varn]

I need to run the stored procedure sp_attach_single_file_db to attach a
local database using ADO.NET. I am not sure of the connection string I
should use for this since I am not connecting to any particular database,
only SQL Sever itself.

--
-----------------------------------
Ken Varn
Senior Software Engineer
Diebold Inc.

EmailID = varnk
Domain = Diebold.com
-----------------------------------

 

[Rogas69]

You are connecting to 'master' database

Peter

 

[Mythran]

You are connecting to 'master' database

Peter

server=SERVERNAME;database=master;...

 

[William \(Bill\) Vaughn]

Note that ADO.NET 2.0 will permit you do attach an MDF database file from
the connection string... AttachDBFilename=my.mdf;

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Pablo Castro [MS]]

Note that you can use AttachDbFileName in 1.0 and 1.1 as well. The new thing
in 2.0 is that we support relative paths now. In 1.0 and 1.1 you need to
make sure you provide a full path or a path relative to the SQL Server
process' current directory (I'd recommend to always specificy a full path).

--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.

Note that ADO.NET 2.0 will permit you do attach an MDF database file from
the connection string... AttachDBFilename=my.mdf;

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________