Hello, I have a ODBC connection to an Excel spreadsheet and for most of today, the connection was fine and I had several successful queries. However for some reason, now the ODBC connection is erroring out.
It's giving me these two errors:
Error 1: [ODBC Excel Driver] Too many client tasks
Error 2: [ODBC Driver Manager] Driver's SQLSetConnectAttr failed
I've tried all sorts of things to reestablish the connection but so far it hasn't helped. Googling the error online hasn't been helpful either. I don't know if there's a windows service for ODBC drivers I can stop/start but I don't see anything that stands out.
Also not sure how it happened...are you only allowed X amount of calls to a spreadsheet using ODBC or something?