SQL SERVER 2019 Replication ErrorCode:55012

Hi everyone, today I tried SQL replication on SQL server 2019. My purpose is to mirror data to another database. I followed a guide for doing that.

I shared the guide link which I followed

SQL Replication: Basic setup and configuration

I get just one issue, solving this problem took almost 5 hours. I hope you will find this comment and you can solve the same problem easily

2021-02-05 11:42:54.95 Retrieving publication and article information from the publisher database 'DESKTOP-DSGBELA\SERVER1.ccs'
2021-02-05 11:42:54.96 [0%] Activated articles for publication 'last_try' at the publisher.
2021-02-05 11:42:54.98 [0%] The replication agent had encountered an exception.
2021-02-05 11:42:54.98 Source: Replication
2021-02-05 11:42:54.98 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentException
2021-02-05 11:42:54.98 Exception Message: An unspecified error had occurred in the native SQL Server connection component.
2021-02-05 11:42:54.98 Message Code: 55012
2021-02-05 11:42:54.98

As you see there is an unspecified error :) with 55012 code.

Firstly you have to update your oledb(attention please x64 or x86)

https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

Secondly, you have to add an address to define your oledb “msodbcsqlr17.dll” and “msodbcsqlr17.rll” on your path which in your environment variables

C:\WINDOWS\SysWOW64\1033
C:\WINDOWS\SysWOW64\