Connecting to remte database through windows application

Anant

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suchit Khanna17y ago
Sorry for late reply, there doesn't seem to be any issue in code..... What I could think is that may be its some issues from network side or may you could do one thing from your side is, check for the connection pool settings in your database you are using.
Anant17y ago
my code for retriving data is

public static string str = "Data Source=SERVER;Connection Timeout = 60;Initial Catalog=PLMFileTracker;Integrated Security=True";

public SqlConnection cn = new SqlConnection(str); // this is the connection string to connect to my sqlserver database on server machine

//code to access and retrive data is as follows

string Findme = "my select command";

SqlCommand cmdfinddt= new SqlCommand(Findme, cn);

try

{

            cn.Open();

         SqlDataReader dr = cmdfinddt.ExecuteReader();

         while(dr.Read())

         {

                  //add the data into combo box

                  combobox1.Items.Add(dr[0].ToString());

         }

         dr.Close();

    }

catch()

{

            messagebox.show("Error");

}

finally

{

         cn.close();

}
Suchit Khanna17y ago
Hi Anant, could you please share your code you are using to connect to database and fetch the data. You could do some performance tuning on your code at the same time you could make use of connection pooling at Sql Server side.