Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Unable to find data source and sql driver is not specified

KBH
6 - Meteoroid
I am trying to create an Access to Microsoft sql server database from alteryx anyone knows what I need to do how to download the exact drivers
 
I have this Error-Data-source-name-not-found-and-no-default-driver-specified/ta-p/400402
 
which sql driver I need to download ?
 
Thank you in advance 
 
 
2 REPLIES 2
AkimasaKajitani
17 - Castor
17 - Castor

Hi @KBH ,

 

Did you check this post?

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Data-source-name-not-found-an...

 

I think you can use this ODBC Driver.

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-serve...

 

I'm using this drive "ODBC Driver 17 for SQL Server" and it works well.

KBH
6 - Meteoroid

thank you for the odbc driver link that what I needed