SQL Error Message since update to Excel 2409

Question

Dear forum users,

I have a severe problem preventing some of my Excel sheets from working properly. Since version 2408 of Excel 365 all vba code in it worked just fine. Since the update from September 2024 to version 2409 I get this error message each time I try to connect to a PostgresSQL database:

"Expression.Error: key=value argument incorrect in ConnectionString

Parametername: application name"

I am not aware of using any application name in any Connectionstring. I just programmed Excel VBA so that the actual SQL string ist built from cells within the workbook. How could I apply any application name in such a thing as a connectionstring, which I never knowingly used before.

any help would be greatly appreciated.

Stefan Lippitsch

Answer 1

Hi Stefan，

Welcome to the Microsoft Community.

We understand the problem you are experiencing. Unfortunately, vba and SQL are more advanced and specialized features and this community seldom deal with issues related to them. It is more suitable for posting on Stack Overflow.

Please use the vba or sql tag and other related tags to post this question to Stack Overflow.

• Newest 'vba' Questions - Stack Overflow
• Newest 'sql' Questions - Stack Overflow

Please note that Stack Overflow has guidelines such as requiring a descriptive title, a complete and concise problem statement, and enough detail to reproduce your problem. Feature requests or overly broad questions will be considered off-topic.

DISCLAIMER*: Microsoft provides no warranties and/or guarantees, implied or otherwise, and is not responsible for the information you receive from third-party linked sites or for any support related to the technology.*

I hope that after reaching out to the right community, you were able to get useful advice.

Sincere greetings,

Ian - MSFT | Microsoft Community Support Specialist