Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

run-time error '-2147467259(80004005)' time out expired Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2014 12:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 4, 2014 8:17 PM
Points: 3, Visits: 30
Hi all ,

I have problem with my application, when uploading picture into sql server 2000 my application showing error message ( Run-time error '-2147467259(80004005)' Time out expired ). This error appear after my technical team replace old server with the new server.

FYI
old server running on windows server 2000 and sql server 2000
new server running on windows server 2003 and sql server 2000

In my case, this error appear only on office hour and my picture size above 20 kb , but when i trying after office hour and my picture size under 20 kb.. the error messages is not appear.

Anyone know how to solve my problem?
Post #1550039
Posted Wednesday, March 12, 2014 7:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 13,289, Visits: 12,138
rahma.andany (3/12/2014)
Hi all ,

I have problem with my application, when uploading picture into sql server 2000 my application showing error message ( Run-time error '-2147467259(80004005)' Time out expired ). This error appear after my technical team replace old server with the new server.

FYI
old server running on windows server 2000 and sql server 2000
new server running on windows server 2003 and sql server 2000

In my case, this error appear only on office hour and my picture size above 20 kb , but when i trying after office hour and my picture size under 20 kb.. the error messages is not appear.

Anyone know how to solve my problem?


Hi and welcome to the forums. You didn't provide anywhere near enough details to offer anything resembling help here. The only thing we know is that your connection timed out. We don't know anything else. Sounds like maybe you have blocking on your sql server but it is hard to know for sure.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1550239
Posted Wednesday, March 12, 2014 7:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 4, 2014 8:17 PM
Points: 3, Visits: 30
Sean Lange (3/12/2014)
rahma.andany (3/12/2014)
Hi all ,

I have problem with my application, when uploading picture into sql server 2000 my application showing error message ( Run-time error '-2147467259(80004005)' Time out expired ). This error appear after my technical team replace old server with the new server.

FYI
old server running on windows server 2000 and sql server 2000
new server running on windows server 2003 and sql server 2000

In my case, this error appear only on office hour and my picture size above 20 kb , but when i trying after office hour and my picture size under 20 kb.. the error messages is not appear.

Anyone know how to solve my problem?


Hi and welcome to the forums. You didn't provide anywhere near enough details to offer anything resembling help here. The only thing we know is that your connection timed out. We don't know anything else. Sounds like maybe you have blocking on your sql server but it is hard to know for sure.


Thanks for your response, i'm sorry if my information is not complete
My application develop under vb 6 and here's my code to put picture in sql server 2000

Dim cn As ADODB.Connection
Dim RsFile, RsX As ADODB.Recordset
Public FileID As String
Dim FNum As Integer

Private Sub Cmdexit_Click()
Unload Me
End Sub

Private Sub Dir1_Change()
File1.Path = Dir1.Path
End Sub

Private Sub Drive1_Change()
Dir1.Path = Drive1.Drive
End Sub

Private Sub File1_Click()
TxFileName.Text = File1.FileName
cmdImportADO.Enabled = True
End Sub

Private Sub Form_Load()
Dim StrCn As String
Dim a As String

Set RsX = New ADODB.Recordset
Set RsFile = New ADODB.Recordset

TxFileName.Text = ""
cmdImportADO.Enabled = False


End Sub

Private Sub CmdImportADO_Click()
Dim fPath, fNama, fType As String
Dim StrQ As String
Dim xN As Byte
Dim TmpData() As Byte
Dim FSize As Long
Dim RsX As ADODB.Recordset

Load frmUpdPic
a = frmUpdPic.dbcass.Value

If File1.ListIndex >= 0 Then
cmdImportADO.Enabled = False
fNama = File1.FileName
fPath = File1.Path
If Right(fPath, 1) <> "\" Then
fPath = fPath & "\"
End If

StrQ = "select COUNT(*) as N from fixasset_mtr Where picture1 ='" & File1.FileName & "'"
Set RsX = New ADODB.Recordset
RsX.Open StrQ, cnFin, adOpenKeyset, adLockOptimistic
xN = RsX!n
RsX.Close
'If xN = 0 Then
StrQ = fPath & fNama
Open StrQ For Binary As #1

ReDim TmpData(LOF(1))
Get #1, , TmpData
Close #1

StrQ = "select * from fixasset_mtr where Asset_no = '" + a + "'"
'" & FileID & "'"
Set RsX = New ADODB.Recordset
RsX.Open StrQ, cnFin, adOpenKeyset, adLockOptimistic
If Not RsX.EOF Then
RsX("picture1").Value = File1.FileName
RsX("Picture").AppendChunk (TmpData)
RsX.Update
RsX.Close
End If
End If
cmdExit.Enabled = True
End Sub


When i try to upload picture, sometime appear error in RsX.Update
it sound like my code getting wrong, but this error not always appear.
The error messages will appear when picture size above 20 kb and uploading picture on working time.


Any idea?
Post #1550500
Posted Wednesday, March 12, 2014 11:14 PM This worked for the OP Answer marked as solution
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 4, 2014 8:17 PM
Points: 3, Visits: 30
Sean Lange (3/12/2014)
rahma.andany (3/12/2014)
Hi all ,

I have problem with my application, when uploading picture into sql server 2000 my application showing error message ( Run-time error '-2147467259(80004005)' Time out expired ). This error appear after my technical team replace old server with the new server.

FYI
old server running on windows server 2000 and sql server 2000
new server running on windows server 2003 and sql server 2000

In my case, this error appear only on office hour and my picture size above 20 kb , but when i trying after office hour and my picture size under 20 kb.. the error messages is not appear

Anyone know how to solve my problem?


Hi and welcome to the forums. You didn't provide anywhere near enough details to offer anything resembling help here. The only thing we know is that your connection timed out. We don't know anything else. Sounds like maybe you have blocking on your sql server but it is hard to know for sure.


Thank you for your response, I have found the source of this problem.
This error occurs when my application try to put some picture and the SQL server failed to perform autogrow.

i just need to change sql server setting for autogrow file from 10% to 10 Mb and this error messages is disappear.
Post #1550546
Posted Thursday, March 13, 2014 7:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 13,289, Visits: 12,138
Glad you got it figured out and thanks for letting me know.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1550720
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse