topic Re: Getting Started on Community in Alteryx Server Discussions

Re: Getting Started on Community

KGouni — Thu, 22 Aug 2019 10:04:01 GMT

Hi,

I am connecting to SQL Server using in-DB Connection, I used ODBC Admin and it says: the file "servername|||" is not in a known format.

I have tested this connection in ODBC Data Source Administrator and it says successful.

Any sample connections or inputs would be great.

Thanks!!

Re: Getting Started on Community

BrianR — Tue, 24 Sep 2019 20:30:30 GMT

Hi - unfortunately it's not completely clear what's occurring here based on your description. Are you sure you have configured your in-database connection correctly? To test this, I typically start with a regular, non-in database connection to make sure I have access to a given data source. Once I have confirmed this, I then move on to configuring my In-Database connection.

Here's an article from earlier this year (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Troubleshooting-Database-Connections/ta-p/57322) that might help get you pointed in the right direction, take a look.

Re: Getting Started on Community

joshuaburkhow — Fri, 03 Jan 2020 20:42:29 GMT

Hi @KGouni Just curious if you were able to get this resolved? If so can you mark this as resolved and share what it was so that others can find it on the community?