Hi all,
I have develop one windows application where i am using sql server 2000 database as a backend. i have created database on server machine and i am developing the application on Development machine using VS 2005, now my problem is whenever i run the application it get's stuck on connection.open statement and it takes planty of time to connect and get the data from server database, where as when i kept the database on development machine it is working fine and quickly , please tell me that how can i reduce the time taken by the applicatiion to connect to server and fetching the data from server database, can we develop such client server application in c# windows application or i have to create web application for the same.
thank u in advance