AttachDBFileName

Group,
Does the AttachDBFileName requires a running SQL Server Express (or any
edition) on that server?
Meaning, can it be accessed like MS Access, not necessarily need a software
installed on that computer, though using OLEDB or connecting with ODBC,
DSN-less still allow you to connect to that database.
Please help.Even Access requires that software be installed on the computer.
AttachDBFileName points to an attachable SQLS database file in a
SqlClient connection string. Here's some links to the relevant
documentation:
http://msdn2.microsoft.com/en-us/library/ms254499.aspx
http://msdn2.microsoft.com/en-us/li...tionstring.aspx
http://msdn2.microsoft.com/en-us/li...dbfilename.aspx
--Mary
On Fri, 16 Feb 2007 09:50:32 -0800, Ronin
<Ronin@.discussions.microsoft.com> wrote:

>Group,
>Does the AttachDBFileName requires a running SQL Server Express (or any
>edition) on that server?
>Meaning, can it be accessed like MS Access, not necessarily need a software
>installed on that computer, though using OLEDB or connecting with ODBC,
>DSN-less still allow you to connect to that database.
>
>Please help.|||The software doesn't necessarily have to be on "that" computer. SQL Server
needs to be running on some machine to which your PC or program has access.
You can't use a database file without first attaching it to an installed
instance of SQL Server and the database file must be local to the server -
on direct-attached or SAN storage but not on a NAS or network drive.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--