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

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Kepserver connecting with Mysql

Sri1
14-Alexandrite

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

ACCEPTED SOLUTION

Accepted Solutions
AndrewBlack
12-Amethyst
(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
12-Amethyst
(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

Announcements


Top Tags