• State Suggested Answer
  • Locked Locked
  • Replies 21 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 17437 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

MYSQL integration to sync account from mysql to D1IM7.1

dorisaini
over 8 years ago

Hi All,

 

I have installed and configured OrangeHRM system which is using mysql as backend database. I am trying to sync account from mysql to identity one. I have configured everything and see the schema as well for mysql using Native Database.

When I run execute then I am seeing below error

Could not load or assemble Mysql.Data. System cannot find the file specified.

 

I copied Mysql.Data.DLL file under windows, system32 and DELL/installation directory as well for job server and work station.

 

Please advise.

 

Thanks

Dori

Parents
  • 0 over 8 years ago
    So your are running the sync on a job service.

    Ensure that:

    - the MySQL.Data.Dll is present on the job service executing the sync
    - the Job service is configured as Native Database Connector, means the necessary DLLs like VI.Projector.Database.Native.MySql.dll are present.
    - take a look at the event log if you are able to detect if a dll the MySQL.Data.dll depends on is missing.

    Which version of the MySQL.Data.dll are you using?
Reply
  • 0 over 8 years ago
    So your are running the sync on a job service.

    Ensure that:

    - the MySQL.Data.Dll is present on the job service executing the sync
    - the Job service is configured as Native Database Connector, means the necessary DLLs like VI.Projector.Database.Native.MySql.dll are present.
    - take a look at the event log if you are able to detect if a dll the MySQL.Data.dll depends on is missing.

    Which version of the MySQL.Data.dll are you using?
Children
No Data