Error EOleException cleaning up expired database items. Database: Greylisting. Error: "Provider cannot be found. It may not be properly installed". - ORF Forums

Error EOleException cleaning up expired database items. Database: Greylisting. Error: "Provider cannot be found. It may not be properly installed". RSS Back to forum

1

I have two servers.
One has been upgraded to version 6.3 from version 5.3
Previously Server1, a SQL database for processing greylists was deployed on it.
I move SQL Database on different Server(SQL) change connection string in settings and all work fine

Then I deployed a second server(Server2), and subscribe settings to Server1.
But in log i have errors:

-------------------------------------------------------------------------------

-- EVENT SUMMARY --
Time: 2020-10-22 18:58:47 GMT+0300 (local)
Sender Email: (not available)
Recipient Email: (not available)
Related IP: (not available)
Action: (not available)
Email Subject: (not available)

-- EVENT MESSAGE --
Error EOleException cleaning up expired database items. Database: Greylisting. Error: "Provider cannot be found. It may not be properly installed".

-- EVENT DETAILS --
Filtering Point: Non-filtering
Event Class: System Message
Severity: Error
Server: dmz-edge06.****
Event Source: (not available)
HELO Domain: (not available)
Message ID: (not available)
Log Mode: Verbose
ORF Version: 6.3 RELEASE

-------------------------------------------------------------------------------

I installed SQL MEnagment Studio, and and checked that connection to external SQL sever succesed.

I forgot to install something?

by Nikolay.Yakimov 1 month ago
2

@Nikolay.Yakimov: The second server is either missing the SQL Server Native Client (ODBC) driver, or the version of the driver is different from the one used in the ADO connection string. Please try the following:

1) Run the ODBC Data Source Administrator tool on Server 2: (C:\Windows\System32\odbcad32.exe), click the Drivers tab, and check if the "SQL Server Native Client xx.x" driver is installed.

If not, get it from:
https://www.microsoft.com/en-us/download/details.aspx?id=50402

2) Start the ORF Administration Tool on the "Publisher" ORF server and open the External Database configuration dialog (Blacklists > Greylisting > Database > External SQL Server - Configure). Note the version number in the "Provider=" parameter (e.g. v11.0: "Provider=SQLNCLI11") of the ADO connection string. It has to match the "SQL Server Native Client xx.x" version installed on Server 2.

Let me know if this has helped.

by Daniel Novak (Vamsoft) 1 month ago
(in reply to this post)

3

1)
ODBC Driver 17 for SQL Server 2017.175.01.01
SQL Server Native Client 11.0 2011.110.7462.06
2)
Provider=SQLNCLI10;Server=dmz-orf-sql\SQLEXPRESS,1234;Database=ORF;User id=orfuser;Password=****;DataTypeCompatibility=80;

by Nikolay.Yakimov 1 month ago
4

that is, I must have one version on all servers?
ok, now I will try it

by Nikolay.Yakimov 1 month ago
5

yes, i reinstall Netive client on version 10, and it soved my problem

Thank you!

by Nikolay.Yakimov 1 month ago
6

@Nikolay.Yakimov: Thank you for the update Nikolay.

Let me know if anything else comes up. I will be happy to assist.

by Daniel Novak (Vamsoft) 1 month ago
(in reply to this post)

New comment

Fill in the form below to add a new comment. All fields are required. If you are a registered user on our site, please sign in first.

It will not be published.
hnp1 | hnp2