Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Hi,
I am trying to connect mysql with Kepserver. I installed the ODBC connector,
created the channel
Driver: ODBC CLient
Data source: MySQL ODBC 8.0 ANSI Driver 32bit
And created the device
Model : Mysql
And when i select the table select droup down its not showing the created table
Thanks,
Sri1
Solved! Go to Solution.
Good morning,
When you are creating the DSN to point to your MySQL database, ensure that you are using the 32bit Data Source administrator, and the credentials you are using within the DSN have full permissions to the database. Generally if we are not displaying a table you have created within the drop down, it is due to Windows level permissions that is trying to access the DSN.
You could also try to switch KEPServer to run as an interactive process so we are using your Windows credentials to connect. You can switch this through the Administration icon within the Runtime Process tab. NOTE: If you have configured DCOM permissions for a client to access this server, this will erase all of your permissions. Once you can see the table and auto generate the tags, you can switch it back to run as a system service, and the reconfigure DCOM permissions.
Kind Regards,
Andrew Black
Senior Technical Support Engineer
Good morning,
When you are creating the DSN to point to your MySQL database, ensure that you are using the 32bit Data Source administrator, and the credentials you are using within the DSN have full permissions to the database. Generally if we are not displaying a table you have created within the drop down, it is due to Windows level permissions that is trying to access the DSN.
You could also try to switch KEPServer to run as an interactive process so we are using your Windows credentials to connect. You can switch this through the Administration icon within the Runtime Process tab. NOTE: If you have configured DCOM permissions for a client to access this server, this will erase all of your permissions. Once you can see the table and auto generate the tags, you can switch it back to run as a system service, and the reconfigure DCOM permissions.
Kind Regards,
Andrew Black
Senior Technical Support Engineer
Hi @Sri1.
If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.
Thank you for your participation in our community.
Regards.
--Sharon