This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
odbc:DSN=COnnectionName|||SchemaName.TableName -> This is required for Updates/Deletes
odbc:DSN=COnnectionName|||TableName -> Insert was working without schema name
Even though we have hard coded the schema name in ConnectionName, it does not pickup for Updates. The error was also misleading. I am sure its a bug in Alteryx. It should not work differently for different type.
Just for a little flavor, I'm seeing that error when I do specify the schema. What makes the difference on my instances is that I have to use all lowercase table name for the Update to work (despite creating the table all uppercase).
Lisa LePome Senior Customer Support Engineer -- Knowledge Management Coach Alteryx, Inc.