Not able to create data 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,
Though I am admin in GALLAERY, not able to create data connection by specifying the serer details. I have read only access to the required database.
Do I need admin rights on the database?
Please suggest.
Thanks,
Solved! Go to Solution.
- Labels:
- Database Connection
- Gallery
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you please help me understand what you mean when you say you're not able to create a data connection? Do you mean Adding a new connection via the Admin console in the Gallery? What is the error you see?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, I am trying to define the data connection for my team and have attached the error screenshot.
I have read only access to the database and able to connect using inbuilt connector.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @dtushar78
Looks like the connection is trying to find ODBC DSN on the server machine. Either create an ODBC connection with name "mcpm_test" on the server, or try using SQL Server Native Client explicitly by using below format:
odbc:Driver={SQL Server Native Client 11.0};Server=server,port;DATABASE=dbname;Uid=username;Pwd=password;Trusted_Connection=yes
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @anupD
Thanks for your solution.
I have installed the SQL server driver again in the server and it is working as expected. But, I am not able to resolve for Oracle On-prem database. I have installed the Oracle Client both in the server and my desktop. still it is not able to find the driver.
As I am new to Alteryx, I am jumping one connection issue to the other. Appreciate if anyone can point or guide on this.
Thanks,
Tushar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You might want to check the path that ORACLE_HOME variable is pointing to. It needs to be pointing to the directory where Oracle is installed. You can check the system variables in Control Panel or by executing SET command in cmd.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @AnupD for the suggestion.