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