quinta-feira, 10 de maio de 2012 07:42
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
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.
quinta-feira, 10 de maio de 2012 08:24
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
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
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
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
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 ...
- Marcado como Resposta Maggie LuoMicrosoft Contingent Staff, Moderator quinta-feira, 17 de maio de 2012 08:46