Code working on one PC

[adam]

Hi anyone,

I have two PCs with the same windows operating edition. That is Windows 11 Pro.

PC 1 is version 22H2.

PC 2 is version 21H2.

Every time I try to run the code PC 1 gives me the following error:

[DBNETLIB][ConnectionOpen (SECDoClientHandshake ()).]SSL Security error

And when I click the Debug button it highlights the line:
cnn.Open ConnectionString:=strConn

from the code:
strConn = "provider=sqloledb.1;data source=MYSERVER;" & _
"user id=moderator;password=pass123;initial catalog = MY_V3_9"
cnn.Open ConnectionString:=strConn

But I do not get any error from the PC 2 with version 21H2. The code with this PC works totally fine.

Any help to overcome this would be kindly appreciated.

Thanks in advance.

[SpeakEasy]

Known bug

https://www.bleepingcomputer.com/news/m ... s-11-22h2/

[adam]

Thanks for the reply. So what should I do now to make my code work with Windows 11 Pro 22H2?

[HansV]

From the article in SpeakEasy's link:

Since KB5018496 is an optional preview update, it doesn't contain any security fixes and will not be installed automatically.

You can install it on your device by going into Settings > Windows Update, clicking 'Check for Updates,' and then selecting the optional preview to download and install.

[adam]

It's still not working after the cumulative update for Windows 11 version 22H2 for x64-based systems (KB5020044)

[SpeakEasy]

Cumulative Update Previews (which is what KB5018496 is) are separate from the regular cumulative updates.

[adam]

Can I get a clear answer of what I should do now. Would appreciate it. My code isn't working now and the work is stopped because of it.

[HansV]

If you don't get offered KB5018496 via Windows Update, you can download it from Microsoft Update Catalog. I assume that you'll need the X64 version (the second link).

[adam]

Thanks for the reply Hans. If I may ask

from the link you have provided why does it say

This update has been replaced by the following updates:

2022-11 Cumulative Update for Windows 11 Version 22H2 for x64-based Systems (KB5019980)
2022-11 Cumulative Update Preview for Windows 11 Version 22H2 for x64-based Systems (KB5020044)

Note: in my initial post I have mentioned that I have installed
cumulative update for Windows 11 version 22H2 for x64-based systems (KB5020044)

With your link am I downgrading? Please advise.

[HansV]

Sorry, I hadn't seen that. The update that you installed should have fixed the problem you mention. If it doesn't, I don't know what you should do.

[SpeakEasy]

Well, that's odd ...

As with Hans, if the patch doesn't fix it then I have no further advice I can give on this. Might be time to contact Microsoft.

[BobH]

Would reverting to the installation prior to the update be a workable solution until another is found?

[adam]

When I revert back to windows 10. The code is working.

[winekein]

2023년도 1월에 발표된 KB5022303 업데이트 패치로도 해결이 되지 않나요?

[HansV]

Welcome to Eileen's Lounge! I'm afraid that English is the only language we use here.

Translation of previous reply from Korean by Google:

Doesn't the KB5022303 update patch released in January 2023 also solve it?