cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We’re thrilled to announce our newest Alteryx Designer Expert Certified users! Learn more.

SMTP Sleeping Notifications

Meteor

Anytime I use an ODBC connection (Sql Server Native Client 11.0 driver), I get responses from my DBAs saying that I have new "sleeping" connections to the database that locks others from getting to the data. I have used Alteryx at a previous company before and have never come across this issue. The temporary solution is to add ";pooling=false" to my Input Data tool for every SQL data source which is very tedious, but I can't find anywhere in the ODBC Administration tool that allows me to turn off the pooling permanently at the driver level or at the ODBC DNS Connection level.

 

 

Alteryx
Alteryx
Meteor

I've tried both of these. Neither of them fix the problem. Any other suggestions?

Labels