Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error SQL Driver Connect(ODBC driver)

Kait
5 - Atom

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 

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux

Have you set up your driver like your colleague?

Kait
5 - Atom

Yes i have imported the workflow from his system only.

alexnajm
18 - Pollux
18 - Pollux

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

apathetichell
19 - Altair

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

Labels
Top Solution Authors