September 15, 2003 at 8:52 pm
How do I connect 2 computers to a common sql server database stored on one machine. What should be the connection string and what software (operating system) should be installed on the machine which has the database and the other machines which run the exe. I want to implement a multi-user system
Mufaddal
Mufaddal
September 15, 2003 at 10:45 pm
I feel Windows 2000 should be an ideal OS for the server along with sql server 2000 or 7.0 as the database server.
On the Client Side Windows 98 would do.
If you are using visual basic as front end the ADO object library provider will help you in connecting to the database.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
September 16, 2003 at 10:29 am
If you are trying to "share" the database file between servers, you cannot do this. A server holds the locks on the file and it cannot be shared, even in a cluster.
IF you want multiple people to access the data, you "connect" with some client application.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply