ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

OleDB Connection Error

bman213
6 - Meteoroid

Hi all,

 

I am having some weird issues in trying to connect to Microsoft SQL Server with an OleDB connection. I have Spatial data (Geometry) in my database, and when I try to pull from an ODBC connection, I manage to get all the data, including the geometry data to come through for 2 out of 20 datasets. All the rest I get the data, but I dont get the Geometry data. 

So the work around was to try use an OleDB connection to the database. When I connect this way and test the connection, I get a successful connection. However, when I try to run the actual connection, it gives me an error that connection is unsuccessful. 

Has anybody got any experience to fix this issue??

 

Thanks in advance!

TrevorS
Moderator
Moderator

Hello @bman213 


Thank you for your contribution to the Community!

To help make it easier for others to assist, it would be helpful to get some additional information on your process. Here's what we recommend you include in your reply:

* What Alteryx Version are you using?
* Do you have a Workflow with sample data you can share?
* What about a Screenshot?
* How would one replicate the issue?
* Can you share the full error message?

Posting for Fastest Possible Solution

Thank you very much!

Community Moderator
Labels