Click here to Skip to main content
15,567,415 members
Please Sign up or sign in to vote.
2.00/5 (2 votes)
See more:
I have created a windows LAN application, and successfully installed in server system. But when installing in client system and running it, it is showing a 'timeout expiry' error
Posted
Updated 9-Nov-12 6:01am
v2
Comments
Herman<T>.Instance 9-Nov-12 11:02am    
in sql settings it is allowed to query the db from other ip? is the user set up in the database? Is a firewall blocking you? perhaps more information needed.

Three steps clear them one by one to connect with database on server from remote location(Client - pc)

1. Lan connection is not proper
Solution : ping server from client

2. Server should have configured properly that it can allow to access database from remote location

3. Connection string is not proper

one by one try to solve steps
and search on google if stuck or ask us, in which step you need help

Happy Coding!
:)
 
Share this answer
 
Hi,

As you must be knowing for SQL-SERVER we have different connections for different computers. Your problem might be that of improper connection string. To check the connection string you can do one thing. Install the Visual Studio in the client machine. From there in any application try to create any bound database connection to your database in server using any database control like DataGridView. In the process of establishing the connection you will be finding a step when Visual Studio will be generating a connection string. Check whether this connection string matches with the connection string provided by you. If not use this Visual Studio generated connection string. If there is a lan connection problem you can check it out with ping. Try disabling the firewall. It works many times.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900