Data Source Name does not show in drop down list after setting In-DB Connection
- 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 everyone,
i wanted to write in Maria DB, so i installed the necessary driver for Maria DB: https://help.alteryx.com/20213/designer/mariadb
After that i followed the setup of @jarrod (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Is-MariaDB-compatible-with-In-database...) and @PeterP (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Data-source-name-not-found-an...). The connection is successfully tested.
However the DSN does not show in drop down list for selecting. I tried forcing this with connecting querry but i failed too (Error: No database selected). Someone has an idea, what is it about?
Screenshot of setup and error:
Solved! Go to Solution.
- Labels:
- Connectors
- In Database
- Input
- Output
- Settings
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A few things:
1) You haven't finished setting up your In-DB connection yet so you will not be able to connect with either an Input Data or a Connect In-DB.
2) You need to choose your connection in the Connections drop-down under the Connection Type toggle in Manage In-DB.
3) Once that is done you should be able to choose the proper connection string in the dropdown connected to connected string.
I always test with a Connect In-DB and cache by tables/views there - as opposed to trying to connect via Input data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
2) You need to choose your connection in the Connections drop-down under the Connection Type toggle in Manage In-DB.
I think you mean the selection in drop-down in picture 2. There is no options under that toggle.
I though it could work by setting up the connection within the Driver Setup. So i can choose this driver as connection type. But it doesn't work neither.
Same error: No database selected
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry - this is the dropdown you need to have a value in.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for clarifying, So i set this up but i dont know what should i do next to create a table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
that means it worked!!!!
Click on Tables!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It feels so close.
The table is empty...
I'm sorry for my noobery
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Start by hitting refresh.
That says you had a table list from 2014. This is also for reading in/making sure you have a working connection. Once you do you can write using Output data/datastream in and Write-DB etc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
After hitting refresh button the table window remains, nothing changed. Last Refresh is still in 2014.
That means the connection is not working well?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's weird. Are there tables at the DB you are pointing to? Should there be tables - or is it only to writing to?
If it's only for writing to - hook up an Output data tool and writing your table now. You'll need to use a SQL table definition of "XXXX"."XXXX" (etc....)
