RE: Connection to SQL Server dropping

SSC Guru

Points: 323506

November 28, 2012 at 8:24 am

just reading up and want you to check the basics.

search the code and see if there is a {MyConnection}.Close, where {MyConnection} is the variable name for your Connection...it might be being closed when you don't expect it to...

especially if this is vb/vba...are there any On Error Resume Next commands? it might be that an error gets suppressed that prevents subsequent code from executing correctly.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!