Code working on one PC
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Code working on one PC
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.
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.
Best Regards,
Adam
Adam
-
- 4StarLounger
- Posts: 574
- Joined: 27 Jun 2021, 10:46
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Re: Code working on one PC
Thanks for the reply. So what should I do now to make my code work with Windows 11 Pro 22H2?
Best Regards,
Adam
Adam
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Code working on one PC
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.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Re: Code working on one PC
It's still not working after the cumulative update for Windows 11 version 22H2 for x64-based systems (KB5020044)
Best Regards,
Adam
Adam
-
- 4StarLounger
- Posts: 574
- Joined: 27 Jun 2021, 10:46
Re: Code working on one PC
Cumulative Update Previews (which is what KB5018496 is) are separate from the regular cumulative updates.
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Re: Code working on one PC
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.
Best Regards,
Adam
Adam
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Code working on one PC
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).
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Re: Code working on one PC
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.
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.
Best Regards,
Adam
Adam
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Code working on one PC
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.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 574
- Joined: 27 Jun 2021, 10:46
Re: Code working on one PC
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.
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.
-
- UraniumLounger
- Posts: 9300
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Re: Code working on one PC
Would reverting to the installation prior to the update be a workable solution until another is found?
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Re: Code working on one PC
When I revert back to windows 10. The code is working.
Best Regards,
Adam
Adam
-
- NewLounger
- Posts: 1
- Joined: 17 Feb 2023, 07:07
Re: Code working on one PC
2023년도 1월에 발표된 KB5022303 업데이트 패치로도 해결이 되지 않나요?
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Code working on one PC
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?
Translation of previous reply from Korean by Google:
Doesn't the KB5022303 update patch released in January 2023 also solve it?
Best wishes,
Hans
Hans