Top channel protocol violation: expecting preamble

[laurence71]

A friend of mine give me an Excel trigger to work with Gruss.
I tried it but there was an error : "Run-time erro '429' : ActiveX component can't create object".
I saw on your forum that Gruss does't work with Office 2010 click to run version so I have switched from Office 2010 Click-to-Run to MSI-based Office. I have checked my firewall settings, I have added the folder where I have copied the Excel file in the "Trusted Locations" of Excel... And it was working. There is in this Excel trigger an import button to import soccer matches (over/under) of the day. It uses COM connection to do it.
Now I ask my friend to make a small change (about odds) and he gave me another version of the Excel, and since it doesn't work anymore even if I use the previous version.
Here is the error message : "Run-time error '-2146233077 (8013150b)' Top channel protocol violation: expecting preamble", the Excel debugger stops at "sports = ba.getSports()".
Com Server option in Betting Assitant is ticked. I can connect the Excel file with it but I can't import soccer matches. I have even tried BA_Clean_COM_Registry.exe but it's still not working...

What can I do ? Thanks in advance for your help.

Have a great day.

Laurence.

[GaryRussell]

Did you first uninstall Betting Assistant before using the clean registry utility? Ie. Did you take the following steps?

1) Uninstall BA
2) Run BA_Clean_COM_Registry.exe
3) Re-install BA

Also what version of Betting Assistant are you using?

[GaryRussell]

I did a remote assistance session with another user who had the same error message. I discovered that another process was using port 8000 which Betting Assistant uses to communicate with the COM interface. The solution is to use another port.

If you uninstall BA and re-install from the link below it should solve the problem. This version includes a config file which tells the COM dll to use port 8001. You will also need to change the COM preferences in BA to use port 8001.

http://www.gruss-software.co.uk/Betting ... M_fix2.msi

Please let me know if this helps.