Insert statement take a longer time in live server

[saion]

Let I have a page with displaying some data. My list page can display all data means page can connect with sql server & read data but when i am in entry page & click to save then it will take longer time in live server & finally failed. Note that in my development PC it worked nicely. And the commandtimeout is 0. Thats page try to save longer time but finally failed.

Please write your observation.

[PRR]

Your development pc is obviously different from your deployment pc.

1. Look into connection string you are using to connect to your DB server.
2. Timeout can be set to something higher. Default is 15 sec [MSDN]

ConnectionString = "username=;password=;database=northwind;server=mySQLServer;Connect Timeout=30";

[saion]

Hi Moderator,
Thanks for your reply. By increasing the connection timeout to 60 didn't resolve my problem. Note that All select statement will run smoothly but when i want to save data then IE progress bar indicator is going on & on. Another thing is yes i have hosted the project into different server.

[PRR]

Check if your connectionstrin g is valid...Are you using windows authentication for accessing database?

[Frinavale]

Hi Moderator,
Thanks for your reply. By increasing the connection timeout to 60 didn't resolve my problem. Note that All select statement will run smoothly but when i want to save data then IE progress bar indicator is going on & on. Another thing is yes i have hosted the project into different server.

Are you sure that the database user account with which you're saving the data to the database has permissions to do so?

Have you checked the Windows Event logs on the server to see if there are any error/warning messages pertaining to your application logged there?

[saion]

No i didnot use windows authentication to connect to the database. We have 5 affiliates & my application is hosted in our central server. All 4 affiliates can do everything except my affiliate. I thought that here may be some network admin related issues which i cant identify yet. Note it that i can access the data list but cant insert.

[Frinavale]

Well, make sure that the database administrator has set up your database user account with "insert/update" permissions.

[saion]

I have already assured that the user has enough permission since other affiliates(in other country) also uses my connection string. I thougt that few settings in my lan may cause the reason such as port etc.. But i can't figure out it. Plz help