I have an issue regarding the User Directory Connectors. I have created an ODBC connection for SQL and tried to create User Directory Connector SQL(Via ODBC). Below is the screen Shot of the Connector I have created. But I am still getting an error. I have tried many things but I could not resolve it. I could not see any issue with the connection. But still still it is not working..Kindly help me with it.
We had a similar problem connecting to Teradata. Can you add the port in connection string as well ? We had missed the port number from connection string and were facing the same issue, but after adding the port the UDC worked just fine.
Thanks for your reply. That thread was really helpful but even if I configured it the same way, I was getting the error. I was thinking if I was missing any inverted comas while giving the server name or database name. Or do I need to specify the username and password?? If so, how?? Any help on that is highly appreciated.