| Author |
Topic |
|
CBee
Starting Member
15 Posts |
 Posted - 2010-11-30 : 12:07:14
|
| I would like to connect multiple PCs to one sql 2005 database. Must I use SQL Server Compact Edition? If not, how do I make the connections? If so, where do I find out how to do so?Thanks,Charlie |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-30 : 12:10:14
|
| >> Must I use SQL Server Compact Edition?Do you mean must or could?Depends on the client you are using how you make the connections. What are you going to use the database for?A .net app? I would guess not otherwise you wouldn't be asking this.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
CBee
Starting Member
15 Posts |
Posted - 2010-11-30 : 15:28:58
|
| I mean can I just use sql 2005 installed on each PC to connect to a master database or MUST I use SQL Server Compact Edition? I did a search for multiple database connections and it looked like I would have to install SCE on the PC with the master db. I don't want to have to do that if I can just access the master db from sql 2005 clients.Thanks,Charlie |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
CBee
Starting Member
15 Posts |
Posted - 2010-11-30 : 16:01:04
|
| on to the second part of my question then - how do I manage this? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
CBee
Starting Member
15 Posts |
Posted - 2010-11-30 : 16:31:33
|
| I am making queries from a third party application and also writing data to the database from a different application.Currently, I am using a query similar to the following:DECLARE $PostUrl Provider=SQLOLEDB;SERVER=.\PROVIDUSSTD;USER=sa;PASSWORD=velocityscape;DATABASE=posts "select _source, _notes,_title from posts.dbo._post"Declare is a function of the third party application. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
CBee
Starting Member
15 Posts |
Posted - 2010-11-30 : 16:50:13
|
| I was unsure as to if this was a server question or an application question since I am wanting to be able to issue the above command from various computers on my network.Thanks for your inputCharlie |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-01 : 04:30:39
|
| There's no problem with running that from multiple machines against a single server.You don't need sql server installed on the client machines but you will need a connectivity layer which I presume will be installed with whatever you are running that statement in.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
Multiple connections to sql 2005