Connecting NAV to MySQL

RahilaRahila Posts: 3Member
Hello, I want to create a connection between my NAV 2018 and external DB MySQL . I just need a basic connection message when the connection is built successfully.

Answers

  • Slawek_GuzekSlawek_Guzek Posts: 1,596Member
    edited 2018-11-06
    Look at Microsoft ActiveX Data Objects automation objects. You will find a Connection object there:
    ADOConn : 'Microsoft ActiveX Data Objects 2.8 Library'.Connection
    
    IF ISCLEAR(ADOConn) THEN
      CREATE(ADOConn);
    ADOConn.Open(ConnectionString);// check www.connectionstrings.com/mysql/ for connection string syntax
    
    Edit
    the above is for NAV 2009 of former, Classic Client, for NAV 2018 please post in correct forum
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • BlackTigerBlackTiger Posts: 1,165Member
    There is .NET Connector for MySQL - https://dev.mysql.com/downloads/connector/net/8.0.html
    "You can’t just ask customers what they want and then try to give that to them.
    By the time you get it built, they’ll want something new.” Steve Jobs
  • RahilaRahila Posts: 3Member
    Look at Microsoft ActiveX Data Objects automation objects. You will find a Connection object there:
    ADOConn : 'Microsoft ActiveX Data Objects 2.8 Library'.Connection
    
    IF ISCLEAR(ADOConn) THEN
      CREATE(ADOConn);
    ADOConn.Open(ConnectionString);// check www.connectionstrings.com/mysql/ for connection string syntax
    
    Edit
    the above is for NAV 2009 of former, Classic Client, for NAV 2018 please post in correct forum

    Thanks for the reply but when i am doing exactly the same but while compiling i get the error that "You cannot create and AUtomation object "ADOConnection" on Microsoft Dynamics NAV Serevr. You must create it on a client computer."

    mggldrc6nvoe.png
  • RahilaRahila Posts: 3Member
    BlackTiger wrote: »
    There is .NET Connector for MySQL - https://dev.mysql.com/downloads/connector/net/8.0.html

    Thank you for the reply. Can you please give me the syntax as well like how to create after downloading .
  • BlackTigerBlackTiger Posts: 1,165Member
    There are many C# code samples on their website. It's pure .NET.
    "You can’t just ask customers what they want and then try to give that to them.
    By the time you get it built, they’ll want something new.” Steve Jobs
  • Slawek_GuzekSlawek_Guzek Posts: 1,596Member
    edited 2018-11-07
    Rahila wrote: »
    ...Edit
    the above is for NAV 2009 of former, Classic Client...

    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • krikikriki Posts: 8,570Member, Moderator
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
  • Tony_NCDTony_NCD Posts: 4Member
    Sounds like all you need to do is set the ADO object that you defined, to run on client as opposed to the server.
Sign In or Register to comment.