Accessing an SQL Server database file

[AlexDP]

My program has to access an SQL Server DB file that is in the same folder as
the executable. i dont want to setup a server. i was able to do this on my
own computer, the program would access any sql server db file without it
being attached to the server. When i take it to another system it fails to
run.
All systems have SQL Server Express and SQL Server 2005 installed.

Can someone please direct me through the steps to fix this problem?

There are 2 errors (on different pcs) i get when i try to access the db one
is:

Error 1

Generating user instances in SQL Server is disabled. Use sp_configure 'user
instances enabled' to generate user instances.
---------------------------
Error 2
---------------------------
System.Data.Sql Client.SqlExcep tion: An error has occurred while establishing
a connection to the server. When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26 -
Error Locating Server/Instance Specified)

at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )

at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj)

at System.Data.Sql Client.TdsParse r.Connect(Boole an& useFailoverPart ner,
Boolean& failoverDemandD one, String host, String failoverPartner , String
protocol, SqlInternalConn ectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean trustServerCert , Boolean integratedSecur ity, SqlConnection
owningObject, Boolean aliasLookup)

at
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance)

at
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance)

at
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n)

at
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options)

at System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject)

at
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject)

at System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)

at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)

at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)

at System.Data.Sql Client.SqlConne ction.Open()

at DBManager.SqlDB Manager.Connect ToDB() in C:\Documents and
Settings\Alessa ndro Del Piero\My Documents\Visua l Studio
2005\Projects\D BManager\DBMana ger\SqlDBManage r.cs:line 53

at DBModule.Form1. button2_Click(O bject sender, EventArgs e) in
G:\DBModule\DBM odule\Form1.cs: line 205
---------------------------
OK
---------------------------

[Otis Mukinfus]

On Sat, 11 Feb 2006 03:09:27 -0800, AlexDP
<Al****@discuss ions.microsoft. com> wrote:

[snip]

If you are using a provider (Internet) you will have to get the
provider to make the settings recommended in the second message.

If you are on a local network you will need to get the Network staff
to make the settings for you.

Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com

[Nicholas Paldino [.NET/C# MVP]]

Alex,

Check this link, it will tell you how to create a connection to SQL
Server and attach to a database file:

http://msdn2.microsoft.com/en-us/library/ms165716.aspx

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"AlexDP" <Al****@discuss ions.microsoft. com> wrote in message
news:6B******** *************** ***********@mic rosoft.com...

My program has to access an SQL Server DB file that is in the same folder
as
the executable. i dont want to setup a server. i was able to do this on my
own computer, the program would access any sql server db file without it
being attached to the server. When i take it to another system it fails to
run.
All systems have SQL Server Express and SQL Server 2005 installed.

Can someone please direct me through the steps to fix this problem?

There are 2 errors (on different pcs) i get when i try to access the db
one
is:

Error 1

Generating user instances in SQL Server is disabled. Use sp_configure
'user
instances enabled' to generate user instances.
---------------------------
Error 2
---------------------------
System.Data.Sql Client.SqlExcep tion: An error has occurred while
establishing
a connection to the server. When connecting to SQL Server 2005, this
failure
may be caused by the fact that under the default settings SQL Server does
not
allow remote connections. (provider: SQL Network Interfaces, error: 26 -
Error Locating Server/Instance Specified)

at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )

at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj)

at System.Data.Sql Client.TdsParse r.Connect(Boole an& useFailoverPart ner,
Boolean& failoverDemandD one, String host, String failoverPartner , String
protocol, SqlInternalConn ectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean trustServerCert , Boolean integratedSecur ity,
SqlConnection
owningObject, Boolean aliasLookup)

at
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance)

at
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance)

at
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n)

at
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options)

at System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject)

at
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject)

at System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)

at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)

at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)

at System.Data.Sql Client.SqlConne ction.Open()

at DBManager.SqlDB Manager.Connect ToDB() in C:\Documents and
Settings\Alessa ndro Del Piero\My Documents\Visua l Studio
2005\Projects\D BManager\DBMana ger\SqlDBManage r.cs:line 53

at DBModule.Form1. button2_Click(O bject sender, EventArgs e) in
G:\DBModule\DBM odule\Form1.cs: line 205
---------------------------
OK
---------------------------

[AlexDP]

Do you mind explaining to me how the connection string written their works?
because i read through it and then tried to use that connection string (of
course with my own db name) but the string is not a valid C# string, i mean
|DataDirectory| as its mentioned in the description is a keyword but its just
hanging there outside the qoutes and of course it didnt compile as it was, i
tried some other combinations, they didnt work either, so can u please either
tell me the correct connection string, or give me an example?

"Nicholas Paldino [.NET/C# MVP]" wrote:

Alex,

Check this link, it will tell you how to create a connection to SQL
Server and attach to a database file:

http://msdn2.microsoft.com/en-us/library/ms165716.aspx

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"AlexDP" <Al****@discuss ions.microsoft. com> wrote in message
news:6B******** *************** ***********@mic rosoft.com...

My program has to access an SQL Server DB file that is in the same folder
as
the executable. i dont want to setup a server. i was able to do this on my
own computer, the program would access any sql server db file without it
being attached to the server. When i take it to another system it fails to
run.
All systems have SQL Server Express and SQL Server 2005 installed.

Can someone please direct me through the steps to fix this problem?

There are 2 errors (on different pcs) i get when i try to access the db
one
is:

Error 1

Generating user instances in SQL Server is disabled. Use sp_configure
'user
instances enabled' to generate user instances.
---------------------------
Error 2
---------------------------
System.Data.Sql Client.SqlExcep tion: An error has occurred while
establishing
a connection to the server. When connecting to SQL Server 2005, this
failure
may be caused by the fact that under the default settings SQL Server does
not
allow remote connections. (provider: SQL Network Interfaces, error: 26 -
Error Locating Server/Instance Specified)

at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )

at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj)

at System.Data.Sql Client.TdsParse r.Connect(Boole an& useFailoverPart ner,
Boolean& failoverDemandD one, String host, String failoverPartner , String
protocol, SqlInternalConn ectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean trustServerCert , Boolean integratedSecur ity,
SqlConnection
owningObject, Boolean aliasLookup)

at
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance)

at
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance)

at
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n)

at
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options)

at System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject)

at
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject)

at System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)

at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)

at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)

at System.Data.Sql Client.SqlConne ction.Open()

at DBManager.SqlDB Manager.Connect ToDB() in C:\Documents and
Settings\Alessa ndro Del Piero\My Documents\Visua l Studio
2005\Projects\D BManager\DBMana ger\SqlDBManage r.cs:line 53

at DBModule.Form1. button2_Click(O bject sender, EventArgs e) in
G:\DBModule\DBM odule\Form1.cs: line 205
---------------------------
OK
---------------------------

[A.Kahtava]

I'm not sure where your problem is, but here are a couple pointers..
The string you are referring to should be a valid C# string..

"|DataDirectory |" should be replaced with your local database
directory.

The @ character proceeding the string means the string should be taken
literally.

The following string:
@"Data Source='.\SQLEx press'; Initial Catalog=; Integrated
Security=true; AttachDBFileNam e='" + |DataDirectory| + @"\MyDb.mdf' ";

is equivalent to:
""Data Source='.\SQLEx press'; Initial Catalog=; Integrated
Security=true; AttachDBFileNam e='"" + |DataDirectory| + ""\MyDb.mdf '"";

A guide to accessing SQL:
http://www.codeproject.com/cs/databa..._in_csharp.asp

Hope that helps,

-A.Kahtava