I'm trying to use for the first time the COM server. I'm testing it on Access because I'm more used to it then Excel. The problem I'm facing is that the first time i run a function or some code it works fine but the second time it prompts an error message (in BA). Here is what I'm testing:
- Code: Select all
Dim ba As Object
Dim bal As Object
If ba Is Nothing Then Set ba = New BettingAssistantCom.ComClass
Set bal = ba.getBalance(1)
MsgBox (bal.availBalance)
MsgBox (bal.Balance)
MsgBox (bal.exposure)
MsgBox (ba.refreshrate)
The error is part on my OS language and it's the following:
Title: BettingAssistantCom
Problem initialising BA COM: System.Net.SocketException:
(In my OS language) Normally it is only permitted to use one socket
Then the error message goes on for some lines.
I don't know if I'm doing something wrong or if it some error with BA. Can anyone please help or shade some light. Thanks in advance.
Im using windows 7 and version 1.1.0.66x18
