Clear Connection Pool

• mike-511834

  SSC Enthusiast

  Points: 166

  More actions

  August 22, 2008 at 8:46 am

  #72720

  Does anyone know how i can see the connection pool or how i can clear the connection pool in SQL.

  the problem i have is that i can not connect to mysql sever via link server in SQL. the error i encounter is that the connection pool is full. the only way i have been able to resolve this is by a reboot of the SQL server. is there another way to do this?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  August 22, 2008 at 6:49 pm

  #862182

  In SQL Server, we can modify the connection setup under the connection tab in the Properties dialog.

  I cannot remember MySQL clearly. But MySQL should have the similar setting. You need to configure the connection in your way.