Flex Code in Macola Progression 7.9.330 on SQL server 2019.

[AndrewForrest]

Good Day,

We are upgrading to Macola 7.9.330 on a new SQL server 2019, Standard Macola is up and running but we are having problems with screens containing flex code.
I have check with ECi and have been told that Flex should work!
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Case ID: xxxxxx
Account Name: Howe Leather
Title: Note 7: Progression Crystal Reports and screens with Flexibility modifications are not supported when run on a Windows Server 2019 machine
Good Afternoon Andrew.

Please ignore Note 7 on the Supported Platform.

Thank you,
Product Support Specialist
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

I have cleared the flex code opened the screen then VBA, imported the flex code checked the references (added in Macola ERS 5.0 Object Library) compiled the program 'OK', saved it then closed the screen. when I reopen the screen I get an Error
"Microsoft Visual C++ Runtime Library - Runtime Error Program Q:\macsql\macexe.exe - Abnormal Program termination"
followed by
"MSL System Warning - Abnormal Cleanup of MacSqlConnMan in MacMSS.dll, No server Exit OP provided"

To Upgrade from 7.8.900 to 7.9.330 we created a jump server at our current level of SQL server then restored the 7.9.330 databases to the new SQL 2019 server.

Words of wisdom gratefully received...


"Don't worry about the world coming to an end today.
We're already in tomorrow in Australia."

 

[dgillz]

Andrew,

I have run into this a couple times and Flex will work on workstations but not the server. MS Dynamics has the same issue as it also offers a VBA solution.

I was able to get a newer version of vbe6.dll to overcome this issue, but it has only worked for 2 of the 3 servers I tried it on. This link may help.

https://www.microsoft.com/en-au/download/details.aspx?id=19870

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[AndrewForrest]

Hi Dan,

Thanks for your assistance, I managed to get on line with a Macola Tech, and we seem to have sorted this out, we needed to apply VBA65-KB974945 patch and reboot the server. The Macola client is now running with Flex & ERS on the SQL server.
I have also installed the client on another server and it is running OK.

Thanks Again - keep fit.

"Don't worry about the world coming to an end today.
We're already in tomorrow in Australia."