SQL Sever OleDB Error

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

Workflow

Settings

Common Use Cases

Server

Best Practices

Bug

Help

Accepted answers

dineshp

Restarting the server fixed the problem.

All comments

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

Restarting the server fixed the problem.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703