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

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Kepserver connecting with Mysql

Sri1
13-Aquamarine

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
AndrewBlack
4-Participant
(To:Sri1)

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
AndrewBlack
4-Participant
(To:Sri1)

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

slangley
23-Emerald II
(To:Sri1)

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

Top Tags