VB.net kill connection

Yahoo Archive
1
Hi,

If you try and use close method from the conSession object
E.g conSession.close you get 'close' is not a member of Epicor.mfg.core.blconnectionpool.
Do I need to do something else?

Regards,

Ross

Sent from my iPad

On 28 Oct 2012, at 12:54, Jose Gomez <jose@...> wrote:

> in VB you need to call CLose.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Sun, Oct 28, 2012 at 8:32 AM, Ross Robertson <
> ross_robertson@...> wrote:
>
>> **
>>
>>
>> Dear all,
>>
>> I have been writing external applications outside vantage using visual
>> studio in vb.net and wanted to see if other people have had the same
>> issue with closing a connection or if I am missing something. I have the
>> following code below in a class in which I pass in a username and password
>> to create a connection. This then shows up under the user sessions on the
>> server as a connection(using vantage 8.408B progress database) and I can
>> use that connection as required in my application which works fine.
>> The issue is when trying to close this connection by using the dispose it
>> does not seem to get rid of the connection under the user sessions on the
>> server as I have had the debug console open before and called this went to
>> the admin tools on the server and the connection still sits there.
>>
>> Any help or ideas would be appreciated.
>>
>> Regards,
>>
>> Ross
>>
>> Public ConSession As Epicor.Mfg.Core.BLConnectionPool
>>
>>
>> Public Sub New(strUserId As String, strPassWord As String, strUrl As
>> String)
>>
>> 'Create the new connection
>> Try
>> ConSession = New Epicor.Mfg.Core.BLConnectionPool(strUserId, strPassWord,
>> strUrl)
>> Catch ex As Exception
>>
>> Finally
>> ' conepr = Nothing
>> End Try
>>
>>
>> End Sub
>>
>> Public Sub Destroy()
>> Try
>> ConSession.Dispose()
>> ConSession = Nothing
>> Catch
>>
>> End Try
>> End Sub
>>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
2
Dear all,

I have been writing external applications outside vantage using visual studio in vb.net and wanted to see if other people have had the same issue with closing a connection or if I am missing something. I have the following code below in a class in which I pass in a username and password to create a connection. This then shows up under the user sessions on the server as a connection(using vantage 8.408B progress database) and I can use that connection as required in my application which works fine.
The issue is when trying to close this connection by using the dispose it does not seem to get rid of the connection under the user sessions on the server as I have had the debug console open before and called this went to the admin tools on the server and the connection still sits there.

Any help or ideas would be appreciated.

Regards,

Ross



Public ConSession As Epicor.Mfg.Core.BLConnectionPool


Public Sub New(strUserId As String, strPassWord As String, strUrl As String)

'Create the new connection
Try
ConSession = New Epicor.Mfg.Core.BLConnectionPool(strUserId, strPassWord, strUrl)
Catch ex As Exception

Finally
' conepr = Nothing
End Try


End Sub

Public Sub Destroy()
Try
ConSession.Dispose()
ConSession = Nothing
Catch

End Try
End Sub
3
in VB you need to call CLose.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Sun, Oct 28, 2012 at 8:32 AM, Ross Robertson <
ross_robertson@...> wrote:

> **
>
>
> Dear all,
>
> I have been writing external applications outside vantage using visual
> studio in vb.net and wanted to see if other people have had the same
> issue with closing a connection or if I am missing something. I have the
> following code below in a class in which I pass in a username and password
> to create a connection. This then shows up under the user sessions on the
> server as a connection(using vantage 8.408B progress database) and I can
> use that connection as required in my application which works fine.
> The issue is when trying to close this connection by using the dispose it
> does not seem to get rid of the connection under the user sessions on the
> server as I have had the debug console open before and called this went to
> the admin tools on the server and the connection still sits there.
>
> Any help or ideas would be appreciated.
>
> Regards,
>
> Ross
>
> Public ConSession As Epicor.Mfg.Core.BLConnectionPool
>
>
> Public Sub New(strUserId As String, strPassWord As String, strUrl As
> String)
>
> 'Create the new connection
> Try
> ConSession = New Epicor.Mfg.Core.BLConnectionPool(strUserId, strPassWord,
> strUrl)
> Catch ex As Exception
>
> Finally
> ' conepr = Nothing
> End Try
>
>
> End Sub
>
> Public Sub Destroy()
> Try
> ConSession.Dispose()
> ConSession = Nothing
> Catch
>
> End Try
> End Sub
>
>
>


[Non-text portions of this message have been removed]