Connecting to SQL 2005 Express over a network share

[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

 

[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

 

[Paul Clement]

¤ 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)