04-13-2020 03:10 PM - edited 07-15-2021 12:31 PM
Data stored in a SQL Server database that contains spatial object data do not show up in an Input Data tool in Alteryx Designer. The field only displays the message, "None - View Browse Tool Map Tab" or "[Null]" or other characters like an apostrophe in the column as it seems the data is stripped away.
An incompatible SQL Server ODBC or OLE DB driver is used. At this time, OLE DB 18.3 or lower is fully supported in Alteryx.
NOTE: The connection string should start as such: odb:Provider=SQLNCLI11.1
The column will now show up as such:
I have this exact same issue. It started with the newest update to 2020.1
Except when following these steps, I can login to my SQL server through all the other drivers but when I select the SQL Server 11 Driver it doesn't let me login even after the Test Connection works successfully.
I have the same issue. My DB is SQL server 2014, both native client 10 and 11 are working for me. I found a fast way to connect to the database by entering the connection string directly in the box as shown below, then
odb:Provider=SQLNCLI11.1;User ID=xxxxxx;Password=xxxxxx;Initial Catalog=xxxxxx;Data Source=xxxxxx;