Skip to main content
S
Sri11-Visitor
1-Visitor
October 1, 2020
Solved

Kepserver connecting with Mysql

  • October 1, 2020
  • 2 replies
  • 2693 views

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

Best answer by AndrewBlack

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

2 replies

A
AndrewBlack1-VisitorAnswer
1-Visitor
October 1, 2020

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

S
slangleyCommunity Manager
Community Manager
October 13, 2020

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

Terms & ConditionsCookie settingsAccessibility statement