Connecting NAV to MySQL

Rahila
Rahila
in NAV Three Tier
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_Guzek
    Slawek_Guzek
    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 - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • Rahila
    Rahila
    Slawek_Guzek wrote: »
    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
  • Rahila
    Rahila
    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 .
  • Slawek_Guzek
    Slawek_Guzek
    edited 2018-11-07
    Rahila wrote: »
    Slawek_Guzek wrote: »
    ...Edit
    the above is for NAV 2009 of former, Classic Client...

    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • kriki
    kriki
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Tony_NCD
    Tony_NCD
    Sounds like all you need to do is set the ADO object that you defined, to run on client as opposed to the server.

Categories