Click here to Skip to main content
15,899,026 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Unexpected characters in print ouptut - VB2008 Pin
DaveAuld18-Nov-09 11:06
professionalDaveAuld18-Nov-09 11:06 
GeneralRe: Unexpected characters in print ouptut - VB2008 Pin
rbc102518-Nov-09 17:06
rbc102518-Nov-09 17:06 
QuestionProblem in VB while trying to execute SQL Code Pin
nhsal6918-Nov-09 3:37
nhsal6918-Nov-09 3:37 
AnswerRe: Problem in VB while trying to execute SQL Code Pin
Eduard Keilholz18-Nov-09 4:08
Eduard Keilholz18-Nov-09 4:08 
GeneralRe: Problem in VB while trying to execute SQL Code Pin
nhsal6918-Nov-09 4:17
nhsal6918-Nov-09 4:17 
GeneralRe: Problem in VB while trying to execute SQL Code Pin
Luc Pattyn18-Nov-09 5:02
sitebuilderLuc Pattyn18-Nov-09 5:02 
AnswerRe: Problem in VB while trying to execute SQL Code Pin
The Man from U.N.C.L.E.18-Nov-09 8:01
The Man from U.N.C.L.E.18-Nov-09 8:01 
GeneralRe: Problem in VB while trying to execute SQL Code Pin
nhsal6918-Nov-09 21:13
nhsal6918-Nov-09 21:13 
the full error is:

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

This only occurs when the input files are the "large" ones, they also use the same variables "first and "second" as the small ones which complete successfully.

After a bit of further investigation it appears as it is only when the VB send the calculation query to SQL that the error occurs (it creates the tables, which is the previous step)...

I am attempting to increase the timeout period from default of 15 sec to more but this doesn't appear to resolve the problem...

Any thoughts???

***edit***

when stepping though the code and executing the "SQLCmd.ExecuteNonQuery()" it takes a count of approx 30 before the timeout error occurs, no matter what the "Connection Timeout=***;" in the connection string is set to...
GeneralRe: Problem in VB while trying to execute SQL Code Pin
Ashfield18-Nov-09 21:30
Ashfield18-Nov-09 21:30 
GeneralRe: Problem in VB while trying to execute SQL Code Pin
nhsal6918-Nov-09 23:08
nhsal6918-Nov-09 23:08 
GeneralRe: Problem in VB while trying to execute SQL Code Pin
Ashfield19-Nov-09 1:25
Ashfield19-Nov-09 1:25 
GeneralRe: Problem in VB while trying to execute SQL Code Pin
The Man from U.N.C.L.E.18-Nov-09 22:44
The Man from U.N.C.L.E.18-Nov-09 22:44 
QuestionConsole application Pin
offroaderdan17-Nov-09 23:35
offroaderdan17-Nov-09 23:35 
AnswerRe: Console application Pin
Richard MacCutchan18-Nov-09 0:05
mveRichard MacCutchan18-Nov-09 0:05 
AnswerRe: Console application Pin
Dave Kreskowiak18-Nov-09 8:35
mveDave Kreskowiak18-Nov-09 8:35 
AnswerRe: Console application Pin
Ian Shlasko18-Nov-09 10:27
Ian Shlasko18-Nov-09 10:27 
AnswerRe: Console application [modified] Pin
DaveAuld18-Nov-09 11:02
professionalDaveAuld18-Nov-09 11:02 
QuestionHow to fire the DropDownList.SelectedIndexChanged event Pin
MacIntyre17-Nov-09 18:46
MacIntyre17-Nov-09 18:46 
AnswerRe: How to fire the DropDownList.SelectedIndexChanged event Pin
Dave Kreskowiak19-Nov-09 3:40
mveDave Kreskowiak19-Nov-09 3:40 
QuestionPermission Denied while Deleting Temporary Files Pin
Nash - ThE cOdE sLiZeR17-Nov-09 17:59
Nash - ThE cOdE sLiZeR17-Nov-09 17:59 
AnswerRe: Permission Denied while Deleting Temporary Files Pin
The Man from U.N.C.L.E.17-Nov-09 20:58
The Man from U.N.C.L.E.17-Nov-09 20:58 
GeneralRe: Permission Denied while Deleting Temporary Files Pin
Nash - ThE cOdE sLiZeR17-Nov-09 21:54
Nash - ThE cOdE sLiZeR17-Nov-09 21:54 
GeneralRe: Permission Denied while Deleting Temporary Files Pin
Shameel17-Nov-09 22:18
professionalShameel17-Nov-09 22:18 
GeneralRe: Permission Denied while Deleting Temporary Files Pin
Nash - ThE cOdE sLiZeR17-Nov-09 22:42
Nash - ThE cOdE sLiZeR17-Nov-09 22:42 
GeneralRe: Permission Denied while Deleting Temporary Files Pin
Shameel18-Nov-09 7:01
professionalShameel18-Nov-09 7:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.