Access data from mySQL

alfred58

I want to read data from a mySQL database:

ADOConn is Automation: Microsoft Active X Data Objects 2.8 Library (Connection)
ADOrs is Automation: Microsft Ative X Data Objects RecordSet 2.8 Library


OpenMethod := 1;
LockMethod := 3;
CREATE(ADOCOnn);
ConnStr := 'Driver={MySQL ODBC 3.51 Driver};SERVER=Localhost;PORT=3306;'+
'Database=co_webshop;User=root;Password=passw;Option=3';;
ADOCOnn.Open(ConnStr);
CREATE(ADOrs);
ADOrs.Open('Select Bestellnummer,Kundennummer,upd from rex_myshop_orders',ADOCOnn,OpenMethod,LockMethod);
ADOrs.MoveFirst;
MESSAGE(FORMAT((ADOrs.Fields.Item('Bestellnummer').Value)));

ADOrs.UpdateBatch;
ADOrs.Requery;
ADOrs.Close;
CLEAR(ADOrs);
ADOCOnn.Close;
CLEAR(ADOCOnn);

When i want to Open ADOConn i get the following message:

'Der Datenquellenname wurde nicht gefunden und es wurde kein Standardtreiber angegeben'.

The mySQL-Server is on the same server as navision.

Has anybody an idea why this does not work? ](*,)

girish.joshi

First of all, you should post your messasge, all of your message, in English [-X

But! We're here to help

According to freetranslation.com your error was

The data source name was not found and was indicated it no standard driver

which seems to indicate that the machine you are running on doesn't have that driver installed.

If the translation isn't very good, please correct it and we can continue to troubleshoot.