Connecting to SQL 2005 Express over a network share

30 Mar 2006 3:42 AM

Phil Williams

Hello,
To my amazement I cannot connect to a SQL 2005 Express over a network share.
Now reading through the newsgroups I can understand why this can be a
problem BUT...

HOW does one go about having two PCs read/write data to a centralized SQL
2005 Express Database?

Any help would be GREAT!
Phil

30 Mar 2006 4:34 AM

Sahil Malik [MVP C#]

Move it to a real SQL Server IMO.

More reading here -
http://codebetter.com/blogs/sahil.malik/archive/2006/03/19/141449.aspx

- Sahil Malik

Show quote

"Phil Williams" <Phillandsa***@hotmail.com> wrote in message
news:%23O21Gw6UGHA.4740@TK2MSFTNGP14.phx.gbl...
> Hello,
> To my amazement I cannot connect to a SQL 2005 Express over a network
> share.
> Now reading through the newsgroups I can understand why this can be a
> problem BUT...
>
> HOW does one go about having two PCs read/write data to a centralized SQL
> 2005 Express Database?
>
> Any help would be GREAT!
> Phil
>

30 Mar 2006 2:19 PM

Paul Clement

On Thu, 30 Mar 2006 15:42:54 +1200, "Phil Williams" <Phillandsa***@hotmail.com> wrote:

¤ Hello,
¤ To my amazement I cannot connect to a SQL 2005 Express over a network share.
¤ Now reading through the newsgroups I can understand why this can be a
¤ problem BUT...
¤
¤ HOW does one go about having two PCs read/write data to a centralized SQL
¤ 2005 Express Database?

The following should help:

http://www.sqlmag.com/Article/ArticleID/49736/sql_server_49736.html

Just keep in mind that SQL Express is not a file based database system and should still be operated
in a server based environment (for multi-user access) just like SQL Server.

Paul
~~~~
Microsoft MVP (Visual Basic)