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
15 - Aurora

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