OleDB Connection Error

[bman213]

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]

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!