Error SQL Driver Connect(ODBC driver)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Database Connection
- Developer Tools
- Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you set up your driver like your colleague?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes i have imported the workflow from his system only.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kait--- this is in your ODBC 64 -.not in Alteryx.You get your database working there first-> then in Alteryx.
