Accessing SQL Database From difference Client PCs.
-
Hi All, I Developed an Application in vb.net 2005 using sql server 2005 express. So far I installed in single PCs and is working fine. But now i want the application to be access by client PCs but update the SQL database on a centralized server PC. e.g. MASTER_PC will have the SQL database & the main application will run on PC1, PC2 and PC3; so that users can access the database from their respective PCs. Overall to say, I just need a central location where the SQL database can be stored, and all employees can run and modify the database through their application via internet/LAN(or some other source) Please suggest me how to go ahead with this: 1) As I have 4 PCs in my office, Do i need to create a LAN ? 2) Do I need to do any major modifications in my application? Any links/tutorial/references will be highly appriciated. Thanks R.S.
-
Hi All, I Developed an Application in vb.net 2005 using sql server 2005 express. So far I installed in single PCs and is working fine. But now i want the application to be access by client PCs but update the SQL database on a centralized server PC. e.g. MASTER_PC will have the SQL database & the main application will run on PC1, PC2 and PC3; so that users can access the database from their respective PCs. Overall to say, I just need a central location where the SQL database can be stored, and all employees can run and modify the database through their application via internet/LAN(or some other source) Please suggest me how to go ahead with this: 1) As I have 4 PCs in my office, Do i need to create a LAN ? 2) Do I need to do any major modifications in my application? Any links/tutorial/references will be highly appriciated. Thanks R.S.
For your connection string, it's easiest to troubleshoot a client if you use DSN connection as opposed to ipaddress. I am not sure if you need to create a LAN since I have always set these up when I already had a LAN. If you've already networked your PC's, then the main step is modify the system DSN on each pc. This can be done by modifying registry settings or through odbccad32.exe. I am assuming that you will want to call your database by name. With Oracle, you also might create a TNSNames file. This is not necessary for SQL Server. Clients can access the database when the login with VPN or are on your network at the office. Assuming that your have a Major modifications to your application should not be necessary.
-
Hi All, I Developed an Application in vb.net 2005 using sql server 2005 express. So far I installed in single PCs and is working fine. But now i want the application to be access by client PCs but update the SQL database on a centralized server PC. e.g. MASTER_PC will have the SQL database & the main application will run on PC1, PC2 and PC3; so that users can access the database from their respective PCs. Overall to say, I just need a central location where the SQL database can be stored, and all employees can run and modify the database through their application via internet/LAN(or some other source) Please suggest me how to go ahead with this: 1) As I have 4 PCs in my office, Do i need to create a LAN ? 2) Do I need to do any major modifications in my application? Any links/tutorial/references will be highly appriciated. Thanks R.S.
1. Aren't your 4 PC's on a single network? If they are, all you need is to set up your server to allow remote connections. Then all your PCs should be able to connect to your database. If they are not on same network, but all are connected to internet, still you can connect to your database. Here[^] is a link to help you. 2. I don't think the code would change.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!