Connecting NAV to MySQL

Rahila

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.

Slawek_Guzek

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

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."

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

Rahila wrote: »

Slawek_Guzek wrote: »

...Edit
the above is for NAV 2009 of former, Classic Client...

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

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.