Unable to give Table or query in Input data tool while connecting Oracle DB through ODBC
- 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
I am trying to connect my Oracle DB through ODBC using DSN-less connection.
However, I am getting this error on canvas = "Error Data source name not found and no default driver specified" while trying to input the tablename or query space. I have used the below:
SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));uid=myUsername;pwd=myPassword.
Request your help on this. While running the flow on gallery, I get the error as "No table chosen; Please select a Table from data source." as I am unable to choose any table or query in the tool because of the above canvas error.
Solved! Go to Solution.
- Labels:
- Connectors
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
EDIT: This may also be helpful - https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-format-common-ODBC-DSN-less-...
At the very end of the string you have used a full stop, replace it with another ; instead like below:
An alternative you could try is:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi David,
thanks a lot for the reply. it seems my organisation has a set of rules for me to follow based on which the DB connectivity will happen. I am following them now and hopefully this shud fix the issue. Thanks again for the response
thanks,
Manasa G
