I have a strange issue occurring on a project. I'm using the same base code I've used for multiple projects without issue. Uses ADODB connections to run sql strings against the database to return a dataset. I then work with the data in Excel and then call another string to pull a different set.
I started a new project about 2 weeks ago. Got everything up and running late last week and it was all fine up until last night. Now every time I try and make multiple Open calls in a row using automation, Excel crashes completely. The same code works fine on a different server. I can also do a single call without issue.
Since it is a hard crash, I am really struggling to find out what is causing the issue. My guess is that it is on the server side, but as far as I know, nothing has changed. I checked the logs in SQL server and the Event viewer and didn't see anything that stuck out.
Really look for help troubleshooting this. I am at a complete standstill and getting a lot of heat for the delay.
Any suggestions on where to look or what to try?