We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error Stored Procedure

imaran_669
8 - Asteroid

Hi everyone, someone could help me?

I am having trouble calling a MSSQL procedure from Alteryx. 

The strange thing is that the procedure I am supposed to call returns me an error: “..no target oledb object available..”

But if I call another random procedure, it runs perfect.

 

I attach screens of my configuration. 

 

Any suggestions? 

1 REPLY 1
Samantha_Jayne
Alteryx
Alteryx

Hi @imaran_669 

 

Can you check the permissions on the database between the two stored procedures? Are they the same?

Samantha Clifton
Alteryx
#alteryxrocks
Labels
Top Solution Authors