SQL Sever OleDB Error

[dineshp]

Hi,

Any one encountered below error when scheduling workflow in gallery which uses a SQL Server OleDB connection. I'm using OleDB instead of ODBC to avoid cursor on SQL Server.

Error - ToolId 115: Error opening connect string: OleDBPro is not initialized or MS Data Link Object not available!

Version: v11.7

Connection: OleDB 64bit

Thanks

[fmvizcaino]

Hi @dineshp ,

Maybe you have done that already, but doesn't kill to say it =D

The oledb driver for SQL server needs to be installed in your Alteryx Server also.

Best,

Fernando V. 

[dineshp]

@fmvizcaino Driver is already installed and it was working fine until Friday. FRom yesterday it started acting like this.

[dineshp · Accepted solution]

Restarting the server fixed the problem.