run program in a lan

16y ago

Accepted answer

While installing the application get the path or server name and store it as a global variable.....use this global variable in connection string of all form or dll wherever u have written the connection string and accessed data...

Just an idea.....

0

Kirtan Patel16y ago

You need to install SQL Server in Main Computer where you about to store ur database ..when ur software run for first time it will create database on the Server by Firing Stored Procedure there on server from local machine .. after database is created every client software can use the databse ..that is on the server ..

0

Crish16y ago

hi

you can access database on lan. Just you need to configure your databse server.

Go Program Files -> Microsoft SQL server 2005 -> Configuration Tools -> SQL server Surface Area Configuration.

Configure your server for Network. Allow it for network even. Also firewall set to off.

Don't forget to Mark Do you like this Answer that solved your problem!

0