How can I close Accpac xapiSession?

[ygl]

In my VB .NET code I use the following code:
Dim glSession As ACCPACXAPILib.IxapiSession
...
glSession = New ACCPACXAPILib.xapiSession
...
glSession(i).Open("ADMIN", "ADMIN", accpacDbName, Now, 0)

I tried to do the following to close the above session:
glSession.Close()
I get the following error:
Run-time exception thrown : System.Runtime.InteropServices.COMException - Unspecified error

Does anybody know why am I getting "Uspecified error", what is it and how can I close the session to destroy ACCPAC object?

 

[DjangMan]

As an aside - why are you using the XAPI vs. the COMAPI interface?

At first glance (and I'm not a .NET developer) this line looks funny:

glSession(i).Open("ADMIN", "ADMIN", accpacDbName, Now, 0)

Do you have an array of glSessions?

In VBA you might simply need to assign your variable to nothing to close it:

set glSession = Nothing

Regards,

Django

 

[ygl]

Assigning a variable to nothing to close it works in VBA, but in .NET it only clears the association of the varible with the object. The object(Accpac session) still exists.
By hte way in my code I process an arrray of sessions, i.e. handle multiple companies in a loop.

 

[ettienne]

Should you not be using glSession(i).Close() and close each session in the array?
I don't think glSession.Close() will work.
Also setup an error jandler to get the returned errors, it may give you the unspecified error.

 

[ygl]

I am already doing it. I may have confused you since I wanted to include a simple code snipplet by not showing that I have an array of sessions and apparently I missed one. I also have error handling set-up and have captured "Unspecified error" message, which doesn't tell me much.
Below is my actual code:
Dim glSession() As ACCPACXAPILib.IxapiSession
Dim glName() As Boolean
Dim i As Integer
...
Try
...
If Not glName(i) Then
glSession(i) = New ACCPACXAPILib.xapiSession
...
glSession(i).Open("ADMIN", "ADMIN", accpacDbName, Now, 0)
glName(i) = True
End If
...
Catch ex As Exception
...
Finally
For i = 0 To glCompanyCount 'close all opened Accpac sessions
If glName(i) Then 'indicates that session was opened
glSession(i).Close() 'this is where I'm getting "unspecified error" message
End If
Next i
...
End Try

 

[ettienne]

I can only go by what you typed in your post, and that did not include (i) on the .Close.

Anyway, have you tried a test where glSession is not an array?

Are you opening any Accpac views? If so then these need to be closed before you close the session.

 

[ygl]

I am opening Accpac views. Let me try to implicitly close them.
Thanks.

 

[ygl]

Do you know how to close a view? There is no "Close" method for this object.

 

[ettienne]

There is in the COMAPI, I think you are missing out on a lot by using the xAPI.

 

[ygl]

Does anybody know where I can found documentaion on Accpac COMAPI?

 

[ygl]

Does any body know how to deal with views in Accpac comAPI?
I need to create batch, header and detail views in order to insert information in Accpac GL databases.
I did this in xAPi but based on intellesense of VB .NET the properties and methods of comAPI differ from xAPI.
I don't have any documentation on comAPI.
Any ideas are welcome.
Thanks.

 

[jayconverse]

Record a macro in Accpac and you'll have all the code you need.

Jay Converse
IT Director
Systemlink, Inc.

 

[ygl]

I though the recording macro gives you xAPI code, which I already have. By browsing comMapi object through my VB .NET program I see that it has different methods than xAPI. FGor example, I use "OpenView" method for a view in xAPI, but there is nothing like this in comAPI.

 

[jayconverse]

What version of Accpac are you running? Anything 5.2 or later gives you COMAPI code.

Jay Converse
IT Director
Systemlink, Inc.

 

[ygl]

I run 5.0 version

 

[jayconverse]

Finally, now we understand.

I'm not going to touch any XAPI development in 5.0, that's a obsolete product.

Jay Converse
IT Director
Systemlink, Inc.

 

[ygl]

The problem was that we had existing MS ACCESS VBA code developed way prior to Accpac 5.0. Some basic code was generated at that time by using macro generated code which was xAPI syntax.
Now that I'm trying to convert this logic into VB .NET and our version of Accpac is higher it is possible that the newly generated macro code will be in comAPI format.
Let me try to create macro VBA now in 5.0 and see if it gives me comAPI syntax.

Thanks for your help.