Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

SQL Sever OleDB Error

Highlighted
8 - Asteroid

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

 

dineshp_0-1574142678525.png

dineshp_1-1574142687224.png

 

Thanks

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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. 

Highlighted
8 - Asteroid

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

Highlighted
8 - Asteroid

Restarting the server fixed the problem. 

Labels