Error SQL Driver Connect(ODBC driver)

Question

Hi All,

I am getting this error message for ODBC driver.
Error SQL Driver Connect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have inputted all my SQL connection details but still it throws the same error. The same connection is working fine on my peer's laptop.

I am using Alteryx 2022.3 version. ODBC data source Administrator (64-bit) is also installed on my system.

Please provide some inputs on the same.

Thanks Everyone

apathetichell · Answer

@Kait--- this is in your ODBC 64 -.not in Alteryx.You get your database working there first-> then in Alteryx.

alexnajm · Answer

The workflow is not the question - The driver to connect to SQL Server needs to be installed and set up the same way as your colleague via the ODBC Admin. Have you done this?

If not, talk to your colleague / IT team to get that going

Kait · Answer

Yes i have imported the workflow from his system only.