Error EOleException cleaning up expired database items. Database: Greylisting. Error: "Provider cannot be found. It may not be properly installed". RSS Back to forum
@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.
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;
that is, I must have one version on all servers?
ok, now I will try it
yes, i reinstall Netive client on version 10, and it soved my problem
Thank you!
@Nikolay.Yakimov:
Thank you for the update Nikolay.
Let me know if anything else comes up. I will be happy to assist.
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?