Advertisement

1 - 10 of 12 containing alltags:("commandtimeout") (0.001 seconds)
Hi, I have a command object and I have set the commandtimeout property to 1 i.e. 1 second. However, it completes after 4 seconds and doesn't throw an error. I then start a loop, call the sleep...
Zones: ProgrammingDate Answered: 08/30/2003 Grade: A Views: 0
Access adp with a SQL 7.0 backend.  I got it working, but I'm just wondering if I can rewrite the following snippet of my code to eliminate having to delete parameters in each case.  Basically if I...
Zones: MS AccessDate Answered: 04/22/2004 Grade: B Views: 0
I am using VB6 with MS Access2003 as DB. When I insert a new record or edit current record with ADODB.Recordset object, sometimes I get "record is locked" error message. I am thinking about usin...
Zones: VB DBDate Answered: 09/26/2005 Grade: A Views: 48
I am running a query on a recordset using ADO 2.0 to SQL Server 6.5. The resulting recordset is generally small, but the query has to parse through several large tables to get the resulting records...
Zones: VB DBDate Answered: 12/07/1998 Grade: A Views: 0
This is my VB code.  How can I convert it to an ASP page? /*********************************************/ Attribute VB_Name = "Module1" Option Explicit Private Sub Main()       Dim dteToday...
Zones: ASPDate Answered: 02/20/2002 Grade: A Views: 0
im using a lot of sprocs in a site, and many of them are starting to edge past the 30 second default timeout. ive set the CommandTimeout property of the worst offenders, but id like to just increas...
Zones: ASPDate Answered: 09/15/2003 Grade: A Views: 31
Hi Experts ... I've been messing with this for hours now and can't figure out why the commandTimeout doesn't work.  I'm testing and have purposely set the timeout to 1 second so that it will timeou...
Zones: Web DevelopmentDate Answered: 11/14/2005 Grade: B Views: 0
I'm on server 2003 w/sql 2005, with 5 relatively large tables (150,000-500,000 records, 180 columns).  I'm working to create a daily process which copies the current data from temp tables to 5 othe...
Zones: DatabasesDate Answered: 10/05/2006 Grade: A Views: 40
I have two VC++ programs -- one that only writes to a SQL database and another that reads from it.  I'm using ADO thru ODBC Drivers to connect both programs to the SQL Server and the database.  I c...
Zones: MS SQL ServerDate Answered: 10/02/2003 Grade: B Views: 4
Hello, I'm working with datasets in Visual Studio 2005, and have used the dataset designer to build them.  The only problem is that I need to change the CommandTimeout for the the table adapters...
Zones: MS Visual C#, Visual Studio ExpressDate Answered: 07/24/2007 Grade: A Views: 22