473,326 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Insert statement take a longer time in live server

4
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.
Aug 6 '09 #1
7 1607
PRR
750 Expert 512MB
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]
Expand|Select|Wrap|Line Numbers
  1. ConnectionString = "username=;password=;database=northwind;server=mySQLServer;Connect Timeout=30";
  2.  
  3.  
Aug 6 '09 #2
saion
4
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.
Aug 6 '09 #3
PRR
750 Expert 512MB
Check if your connectionstring is valid...Are you using windows authentication for accessing database?
Aug 6 '09 #4
Frinavale
9,735 Expert Mod 8TB
@saion
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?
Aug 6 '09 #5
saion
4
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.
Aug 9 '09 #6
Frinavale
9,735 Expert Mod 8TB
Well, make sure that the database administrator has set up your database user account with "insert/update" permissions.
Aug 10 '09 #7
saion
4
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
Aug 12 '09 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

28
by: Fábio Mendes | last post by:
I'm sorry if it's an replicate. Either my e-mail program is messing with things or the python-list sent my msg to /dev/null. I couldn't find anything related in previous PEP's, so here it goes a...
18
by: Robin Lawrie | last post by:
Hi again, another problem! I've moved from an Access database to SQL server and am now having trouble inserting dates and times into seperate fields. I'm using ASP and the code below to get the...
1
by: Metal Dave | last post by:
I do not understand the error handling of SQL Server here. Any error in bulk insert seems to halt the current T-SQL statement entirely, rendering it impossible to log an error. The first statement...
20
by: John Bailo | last post by:
I have a c# program that loops through a table on a DB2 database. On each iteration it assigns data to values in the SqlParameter collection. The command text is an INSERT statement to a Sql...
3
by: rhaazy | last post by:
Using ms sql 2000 I have 2 tables. I have a table which has information regarding a computer scan. Each record in this table has a column called MAC which is the unique ID for each Scan. The...
2
by: Ted | last post by:
I have BULK INSERT T-SQL statements that work for all of my basic data tables except for one. Here is the problem statement (with obvious replacement of irrelevant path info): BULK INSERT...
21
by: lesperancer | last post by:
I've got an access97 reporting mdb that pulls data (77,000 rows) from a sql server table into a local table to run reports if the local table is part of the reporting MDB, the insert statement...
6
by: rn5a | last post by:
During registration, users are supposed to enter the following details: First Name, Last Name, EMail, UserName, Password, Confirm Password, Address, City, State, Country, Zip & Phone Number. I am...
1
by: Maklar60 | last post by:
I am attempting to execute an INSERT statement on my page but continually get the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' Incorrect syntax near '<'. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.