Forum Replies Created

Viewing 15 posts - 346 through 360 (of 465 total)

  • RE: Connection to SQL Server dropping

    Banana-823045 (11/29/2012)

    Actually, that's for a different purpose --- the intention with that one check is to log any query that takes too long. Think of it as a client-side performance...

    November 29, 2012 at 8:16 am

    #1563817

  • RE: Connection to SQL Server dropping

    L' Eomot Inversé (11/29/2012)

    I may be barking up the wrong tree here, but maybe you are running out of sockets? That's what TCP Error 10048 means, and I think...

    November 29, 2012 at 8:09 am

    #1563806

  • RE: Connection to SQL Server dropping

    Banana-823045 (11/29/2012)

    Brandie Tarvin (11/29/2012)

    I don't know what the connection pooling property in the Access app is

    I don't believe Access manages this directly; it defers to the ODBC Manager & Driver...

    November 29, 2012 at 7:54 am

    #1563788

  • RE: Connection to SQL Server dropping

    Brandie Tarvin (11/29/2012)

    So you can't find any events that indicate the SQL Server services shut down, recycled, or that a connection got dropped *before* you got the error posted in...

    November 29, 2012 at 7:48 am

    #1563784

  • RE: Connection to SQL Server dropping

    bleroy (11/29/2012)

    I would go back to basics on this.

    If you can, copy your MSAccess app as a new file, zap everything but the code you are interested in - in...

    November 29, 2012 at 6:33 am

    #1563738

  • RE: Connection to SQL Server dropping

    Brandie Tarvin (11/28/2012)

    pdanes, have you checked your connection pooling properties both in the app and on the server to make sure you can reuse existing connections and that the pool...

    November 28, 2012 at 12:53 pm

    #1563410

  • RE: Connection to SQL Server dropping

    Brandie Tarvin (11/28/2012)

    Bhuvnesh (11/28/2012)

    WHat if we use SSIS to do this stuff more robust more tracable .. more comfortable to handle heavy volume data. i will welcome suggest on this...

    November 28, 2012 at 12:49 pm

    #1563406

  • RE: Connection to SQL Server dropping

    Brandie Tarvin (11/28/2012)

    The error you posted doesn't look like a timed out connection, just a failed connection. That tells me that no connection was actually made. However, I'm not looking...

    November 28, 2012 at 12:47 pm

    #1563404

  • RE: Connection to SQL Server dropping

    Bhuvnesh (11/28/2012)

    WHat if we use SSIS to do this stuff more robust more tracable .. more comfortable to handle heavy volume data. i will welcome suggest on this suggest 🙂

    I...

    November 28, 2012 at 10:11 am

    #1563301

  • RE: Connection to SQL Server dropping

    Lowell (11/28/2012)

    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...

    Nope....

    November 28, 2012 at 10:04 am

    #1563293

  • RE: Connection to SQL Server dropping

    bleroy (11/28/2012)

    Have a look in the windows event log (http://support.microsoft.com/kb/308427), a number of categories there, check them all out (although Application log should be the most relevant), the right panel...

    November 28, 2012 at 9:46 am

    #1563271

  • RE: Connection to SQL Server dropping

    bleroy (11/28/2012)

    Not knowing what OS we are talking about, I will assume that the machine runs with Windows Server 2003+.

    My apologies - Alzheimer's working overtime today. It's Windows Server Standard,...

    November 28, 2012 at 8:13 am

    #1563183

  • RE: Connection to SQL Server dropping

    Brandie Tarvin (11/28/2012)

    Do you have Auto_Close enabled on your SQL Server properties?

    I do not. I'm looking at it right now. AutoCreate and AutoUpdate Statistics are both true, AutoClose, AutoShrink and...

    November 28, 2012 at 7:33 am

    #1563147

  • RE: Connection to SQL Server dropping

    bleroy (11/28/2012)

    Hi,

    Do you have access to the machine hosting the SQL Server DB? if so, can you check on there for the windows log, and sql serror logs?

    See if there...

    November 28, 2012 at 7:15 am

    #1563135

  • RE: LIKE with and without wildcards in WHERE clause

    GSquared (11/27/2012)

    pdanes (11/27/2012)

    There doesn't seem to be any clear consensus on all this, so I guess I'll have to build a bunch of test cases and see what comes of...

    November 27, 2012 at 4:09 pm

    #1562882

Viewing 15 posts - 346 through 360 (of 465 total)