Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sven8
Starting Member
2 Posts |
 Posted - 2013-02-21 : 10:06:23
|
| Hi,I want to work in a wireless network. My two (or more) computers are in that network, and I want one SQL Server 2008 database (for example with the name Test_SQL). I want from both computers write en raed on that database. So when I write something to that database with computer A, that computer B also has that data in the database.Best regards,Sven |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
chieubuon
Starting Member
7 Posts |
Posted - 2013-02-22 : 00:38:02
|
| I think you can create Tesl_SQL on the one of your computers (or your server working in the same wireless) and from any computer you can connect to that database by ODBC to update data |
 |
|
|
Sven8
Starting Member
2 Posts |
Posted - 2013-02-22 : 03:46:21
|
| But how can I change the location of the database db, in this case Test_SQL?The data will place in C:\Program Files\Microsoft SQL Server\100\MSSQL10_50.MSSQLSERVER\MSSQL\DATAI can't change this to a netwerk driver. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-23 : 02:15:51
|
| Assuming you can create an ODBC (or other method) to the target database , than you don't need to place the data on a Network Share.You're actually connecting a SQL Server service - which has a database attached ,In the odbc the connection will be to a SQL Server , such as MYSERVER\MYINSTANCE and then you reference a dbJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Two computers and one database