James Mcquade
Member
Hi all,
We are in the process of upgrading all of our Wonderware 7.0 and 9.5 applications to Wonderware 2014. We have converted six ver. 7.0 applications over with no problems.
We have just converted another ver. 7 application and we are getting this error every 3 or 4 days.
Error processing ‘EvCodeGrid.ConnectWithString’ on method call (execute).
Exception 0x80040E4D: [Microsoft][OBDC Microsoft Access Driver] Too many clients.
The host pc is windows 7 64 bit with 8 GB ram and we are running a windows 7 32 bit VM with 2 GB ram so we can have backups readily available.
We have backups of this application but are required to upgrade to the 2014 version.
The version 7 application has worked for years with no issues and we also have a similar version 9.5 application that has also worked for years.
We have tracked the problem down to an update grid window we are opening to get data from an access database. We either select the data or close the window. There is a built in disconnect function programmed into this window when the window is closed.
We have also found out that the version 7 application uses SQL connections to the data base while the 2014 version uses Active X connections to the data base.
Any thoughts or suggestions would be much appreciated.
Thanks in advance,
James
We are in the process of upgrading all of our Wonderware 7.0 and 9.5 applications to Wonderware 2014. We have converted six ver. 7.0 applications over with no problems.
We have just converted another ver. 7 application and we are getting this error every 3 or 4 days.
Error processing ‘EvCodeGrid.ConnectWithString’ on method call (execute).
Exception 0x80040E4D: [Microsoft][OBDC Microsoft Access Driver] Too many clients.
The host pc is windows 7 64 bit with 8 GB ram and we are running a windows 7 32 bit VM with 2 GB ram so we can have backups readily available.
We have backups of this application but are required to upgrade to the 2014 version.
The version 7 application has worked for years with no issues and we also have a similar version 9.5 application that has also worked for years.
We have tracked the problem down to an update grid window we are opening to get data from an access database. We either select the data or close the window. There is a built in disconnect function programmed into this window when the window is closed.
We have also found out that the version 7 application uses SQL connections to the data base while the 2014 version uses Active X connections to the data base.
Any thoughts or suggestions would be much appreciated.
Thanks in advance,
James