About p_homann

p_homann · ‎03-24-2023

(reposting the same message . . . I had responded to the wrong post) Hi! Thank you for your response (I was afraid this post had died). The only difference we have been able to track down between the two computers is the Access and Excel ODBC drivers. Would you be able to check your driver version for: Microsoft Excel Driver (*.xls, *.xlsx, *xlsm, *xlsb) Microsoft Access Driver (*.mdb, *.accdb) (just in case you don't know where to this info: ODBC Data Source app --> Drivers tab) Thanks!

p_homann · ‎01-30-2023

Here is an example of the LIBNAME statement: libname check2 clear; libname check2 odbc complete="dsn=Excel Files; dbq=%trim(&workLoc)\MyFileName.xlsb; readOnly=false"; This is used multiple times throughout the process and only fails on this one PC (but works 8-10 times prior to failing). This code is inherited and has been used for many years and ported to several different PCs throughout its lifespan . . . this is the only PC where we have run into issues. Thanks again for your time!

p_homann · ‎01-30-2023

No, this is a stand-alone PC accessing files that are stored locally.

p_homann · ‎01-27-2023

Thanks again for your input, however I am already doing this.

p_homann · ‎01-27-2023

Thank you for the quick response. I rebooted the computer and tried again with no other apps open . . . unfortunately the same thing. I failed to notice yesterday, that when running the code on the problematic PC, some successful Excel connections are made earlier in the program, but once the first error is encountered, the remaining attempts all result in the error. Can you think of anything else to check, or is there a way to "monitor" client tasks?

p_homann · ‎01-26-2023

Hi! I have two computers running Windows 10 that have identical SAS installations, and (theoretically) everything else is the same as well. I am running some code that works fine on one computer, but results in the following errors on the other when trying to connect to MS Excel/Access: ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] Too many client tasks. ERROR: CLI error trying to establish connection: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks. Any suggestions on what I can compare on the two computers to figure out why one is having this issue? Thanks in advance!

Online Status	Offline
Date Last Visited	‎05-23-2024 06:45 PM

Re: CLI error - too many client tasks

Re: CLI error - too many client tasks

Re: CLI error - too many client tasks

Re: CLI error - too many client tasks

Re: CLI error - too many client tasks

CLI error - too many client tasks

CLI error - too many client tasks

Re: CLI error - too many client tasks

Re: CLI error - too many client tasks

Re: CLI error - too many client tasks

Re: CLI error - too many client tasks

Re: CLI error - too many client tasks

CLI error - too many client tasks

SAS Analytics Explorers