"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:%23XxRkh7DGHA.796@TK2MSFTNGP10.phx.gbl...
> See if this helps:
>
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Nick K" <nospam@hotmail.com> wrote in message
> news:eT0gKC7DGHA.1032@TK2MSFTNGP11.phx.gbl...
> >I am attempting to connect to a SQL Server 2005 database using a Visual
> > Studio.Net 2003 application.
> >
> > When I use this connection string, I get a Keyword not supported: 'user
> > instance'. error.
> > <add key="SiteSqlServer" value="Data
Source=.\SQLExpress;uid=sa;pwd=;User
> > Instance=True;AttachDBFilename=|DataDirectory|MyDB.mdf;Initial
> > Catalog=MyDB;" />
> >
> > When I remove the "User Instance=True", I get a
> >
> > Database 'c:\Program Files\Microsoft SQL
> > Server\MSSQL.1\MSSQL\DATA\MyDB.mdf'
> > already exists. Could not attach file '|DataDirectory|MyDB.mdf' as
> > database
> > 'MyDB'.
> >
> > What kind of connection string do I use and why doesn't VS2003 recognize
> > the
> > "User Instance=True"?
> >
> >
>
>

"Nick K" <nospam@hotmail.com> wrote in message
news:eT0gKC7DGHA.1032@TK2MSFTNGP11.phx.gbl...
>I am attempting to connect to a SQL Server 2005 database using a Visual
> Studio.Net 2003 application.
>
> When I use this connection string, I get a Keyword not supported: 'user
> instance'. error.
> <add key="SiteSqlServer" value="Data Source=.\SQLExpress;uid=sa;pwd=;User
> Instance=True;AttachDBFilename=|DataDirectory|MyDB.mdf;Initial
> Catalog=MyDB;" />
>
> When I remove the "User Instance=True", I get a
>
> Database 'c:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\DATA\MyDB.mdf'
> already exists. Could not attach file '|DataDirectory|MyDB.mdf' as
> database
> 'MyDB'.
>
> What kind of connection string do I use and why doesn't VS2003 recognize
> the
> "User Instance=True"?
>
>

"Nick K" <nospam@hotmail.com> wrote in message
news:%23Tn$rO8DGHA.2708@TK2MSFTNGP11.phx.gbl...
>I read the document. I don't see an explanation of the "User
>Instance=True",
> keyword not recognized error I am seeing. Is this because my SQLClient is
> the .Net Framework 1.1? I'm currently using VS 2003
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:%23XxRkh7DGHA.796@TK2MSFTNGP10.phx.gbl...
>> See if this helps:
>>
> http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>>
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>>
>> "Nick K" <nospam@hotmail.com> wrote in message
>> news:eT0gKC7DGHA.1032@TK2MSFTNGP11.phx.gbl...
>> >I am attempting to connect to a SQL Server 2005 database using a Visual
>> > Studio.Net 2003 application.
>> >
>> > When I use this connection string, I get a Keyword not supported: 'user
>> > instance'. error.
>> > <add key="SiteSqlServer" value="Data
> Source=.\SQLExpress;uid=sa;pwd=;User
>> > Instance=True;AttachDBFilename=|DataDirectory|MyDB.mdf;Initial
>> > Catalog=MyDB;" />
>> >
>> > When I remove the "User Instance=True", I get a
>> >
>> > Database 'c:\Program Files\Microsoft SQL
>> > Server\MSSQL.1\MSSQL\DATA\MyDB.mdf'
>> > already exists. Could not attach file '|DataDirectory|MyDB.mdf' as
>> > database
>> > 'MyDB'.
>> >
>> > What kind of connection string do I use and why doesn't VS2003
>> > recognize
>> > the
>> > "User Instance=True"?
>> >
>> >
>>
>>
>
>