cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Kepserver connecting with Mysql

SOLVED
Highlighted
Amethyst

Kepserver connecting with Mysql

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Kepserver connecting with Mysql

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

View solution in original post

2 REPLIES 2
Highlighted

Re: Kepserver connecting with Mysql

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

View solution in original post

Highlighted

Re: Kepserver connecting with Mysql

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

Announcements