Input Tool Connect To Saved Data Connection - Asking to resolve file type?

So I can pull in data from my database from an input tool, but now I'm trying to put the data connection on the gallery so that it can be shared among my team.

When I select the data connection it immediately gives me a popup asking to resolve the file type:

I don't get this when I manually connect to the database from an input tool. And any option I try gives an error, either root element missing, or something like "the file 'aka:5absdsdlfkj' does not exist."

Is there something I'm missing?

Input

Database Connection

Accepted answers

StephenMack

Turns out in that case you need to create a DSN on each machine, meaning sharing it on the server isn't really helpful at all.

To do a connection string without a DSN I had to dive into the driver DLL files. Apparently the MySQL driver isn't just "odbc:DRIVER={MySQL ODBC 5.3 Driver}" but "odbc:DRIVER={MySQL ODBC 5.3 Unicode Driver}".

Now it looks like it's working...and I never have to go through this mess again!

All comments

unknown

The Gallery Connection that was made may not be an appropriate connection string. Can you copy that connection string into an input tool and does it work? If not, then it is probably that issue.

StephenMack

I have verified that connection string with other software and it connects and runs queries just fine.

Even if it wasn't correct I'm not sure what that would have to do with the resolve file type. I'm kind of confused as to what alteryx is doing here

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177