Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Urgent Need. Kindly Help me to resolve this.
Say I Created 2 Table in MySql database .
User Table:
LOAD `userid`,
name;
SQL SELECT `userid`,
name
FROM justtry.`q_user`;
And
Attribute Table:
LOAD `userid`,
`type`,
value;
SQL SELECT `userid`,
`type`,
value
FROM justtry.`q_attribute`;
And in UDC , I Used SQL(Via ODBC)
and i created visible connection string :
Driver={MySQL ODBC 5.3 ANSI Driver};Server=172.10.5.146;Database=justtry;Trusted_Connection=yes;dsn=justtry;
But Still i am Getting an Error,
The User Directory connector (UDC) is not configured, because the following Error occured:
Exception When trying to connect to the data source. Edit the connection string in the user directory connector configuration
The User Directory Connector(UDC) is not operational
As Well find the image for Error. Both the Table i can able to fetch using Script Editor.
I got the solution string
Driver={MySQL ODBC 5.3 ANSI Driver};Server=server Ip Address ;Database= DatabaseName; Uid=userid; Pwd=Database Password ; PORT=3306 ;Trusted_Connection=yes;
Can some one Please update me on this
Did you find a solution for your problem? If so, what needed to change/configured?
try connection string as follows
dsn=YourODBC;Server=servername;Database=DBname;uid=userID;pwd=password;
YourODBC is the ODBC name you setup in your ODBC Data Source Administration
Also try Server as Server\InstanceName (e.g. Servername\SQLEXPRESS , for local db .\SQLEXPRESS)
I got the solution string
Driver={MySQL ODBC 5.3 ANSI Driver};Server=server Ip Address ;Database= DatabaseName; Uid=userid; Pwd=Database Password ; PORT=3306 ;Trusted_Connection=yes;