Entrar
 
HomeBibliotecaWikiAprenderGaleriaDownloadsSuporte ComunidadeFóruns
Recursos para Profissionais de TI >
> 
> 
MS SQL server blocking Client To link Database after network disconnected half way

Respondido MS SQL server blocking Client To link Database after network disconnected half way

  • quinta-feira, 10 de maio de 2012 07:42
     
     
    Entrar para Votar
    0

    I Have a Software write in VB 2008 and using MS SQL Database.
    Someday, The networking suddently disconnect when the client is
    link and doing transaction. After network is restored, the Client
    Software cannot link to Database and pop up error.
    What is want to know is, is there any blocking info keep in Server
    that blocking those disconnect link again server ? and if YES, where
    is the link keep ? or any solution on this problem.

    All expert please help me up ... Thanks in advanced ...

     

Todas as Respostas

  • quinta-feira, 10 de maio de 2012 07:46
     
     
    Entrar para Votar
    0

    Hello,

    No, the SQL Server don't block the client; only the existing connection is closed. Your client have to re-connect to SQL Server, if a disconnect occurs.

    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

     
  • quinta-feira, 10 de maio de 2012 08:24
     
     
    Entrar para Votar
    0

    hi, I still can connect the server from client using MS SQL Server Management Studio Express and access the database.

    But if i using Software, the software pop out error message meaning cannot link the database at Server. And I already restart

    Wins 7, it still cannot link by using software .... any solution on it ... Thanks

     
  • sábado, 12 de maio de 2012 08:18
     
     
    Entrar para Votar
    0

    could you please post the error message you get ?

    As Olaf has written, the existing connection is closed and all open transaction are rolled back and therefore your application should be able to reconnect as soon the SQL Server is up and running again and accept new connections.

    are you really sure that your VB app could not connect to the SQL Server ? please use SSMS and look at the activity monitor when you start your VB app to check if it can connect .

    Probably your VB app could connect but there may be some object left from last session and therefore it does not work, eg. if it creates temporary objects in tempdb which are not bound to current session and it tries to create them if may fail.

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

     
  • segunda-feira, 14 de maio de 2012 03:00
     
     
    Entrar para Votar
    0

    Hi, Daniel_Steiner, Thanks For the reply.

    The Error Message I got very long and I not capture it, but the meaning there is all

    some source like ... SQLClient Connection Cannot link the SQL server. My Problem that cannot

    connect to MS SQL server even that PC just boot up. Thks.

     
  • segunda-feira, 14 de maio de 2012 20:07
     
     
    Entrar para Votar
    0

    Hi Sheng,

    There's nothing inside the SQL server that will prevent a connection. You'll need to post the complete exception that you get for someone to help you.

     
  • terça-feira, 15 de maio de 2012 02:20
     
     Respondido
    Entrar para Votar
    0

    hi, Vaibhav Goel, Thks For Reply.

    But Very Sorry, My Customer Formated Thier Computer already, and

    the error never pop out again ... so I will post again if any other customer have this type of

    problem, thank all that try to help me ... THANKS ...