TimeOut Expired 2147467259 (80004005)

[khann]

hi...Im encountering this error.
Timeout Expired : 2147467259 (80004005)
Is there any other way to solve it??

ive tried this
cnn.ConnectionTimeout = 100000000
cnn.CommandTimeout = 100000000

but still...


thanks very much for the help...

 

[cdukes]

Try setting the timeout values to 0. This should indicate that no timeout period is set and the command should run until finished.


Hope this helps,

Chris Dukes

 

[khann]

hey Chris..thanks so much...c",)

 

[bones108]

I am also getting the same error on my script. I tried an extremely high number for the ConnectionTimeout and CommandTimeout properties as well as zero values. However, I am still seeing "80004005 Timeout expired" errors at random points of execution. This is a sample of the code involved with the ADO execution:

Set DBConn = CreateObject("ADODB.Connection")
dbAlumni.ConnectionTimeout = 0
DBConn.Open "Provider=sqloledb;Data Source=" & cServer & ";Initial Catalog=" & cDB & ";User Id=" & cUser &";Password=" & cPass & ";"
Dim intFamilyID, intAlumniID, intRelationID, strFirstName, strMiddleName, strLastName, strSuffix, bolDeceased
set ar = CreateObject("ADODB.recordset")
set ac = CreateObject("ADODB.command")
ac.CommandTimeout = 0
ac.ActiveConnection = DBConn

.
.
.

records = "'" & intFamilyID & "','" & intAlumniID & "','" & intRelationID & "','" & strFirstName & "','" & strMiddleName & "','" & strLastName & "','" & strSuffix & "'," & bolDeceased
queryAlumni = "INSERT INTO Family VALUES (" & records & ")"
ac.CommandText = queryAlumni
ac.Execute

Any assistance in this matter would be greatly appreciated. Thanks!