Accessing MySQL from Natural

, , ,
1

Is there a way to access MySQL from Natural ( both on Linux Environment ) ?
Thanks!

2

You need Entire Access to do so.

3

Reading Entire Access documentation, on supported Database Server topic, I only found this : ODBC-compliant servers (local access). I don’t understand what this mean!?:shock: maybe… Must I write a driver by myself ?
Thanks !

4

If this is all on a PC, couldn’t you use USR1052 to start up MySQL (not within my area of expertise, only a guess).

Getting data back and forth might be a mess (see disclaimer, last sentence) but it would seem to be feasible.

steve

5

Steve, are you serious or are you jocking???
:shock::shock::shock:

6

The database can run on the same machine as Natural (local access) or on some machine on the network (remote access). You won’t need to write any drivers - that’s what Entire Access is intended to do.

Local access should be a bit easier to set up, with a single machine acting as database server and Natural client.

7

Like I said, I am not at all familiar with MySQL.

However, from within Natural I can write a workfile, then transfer control to MS WORD, play with the file, then return to Natural and access the altered workfile. This seems to be similar to what you want to do.

steve

8

Steve runs Natural and Adabas under Windows.

Axt runs Natural and mySQL under Linux.

In either case, the normal proedure is to bring up the database (Adabas or mySQL), then invoke Natural.

9

Ok. I understand what you said Steve. And thanks to Ralph too! I’ll try to runs MySQL and then make a query from natural!
So, by step I need to :

  1. Install MySQL
  2. Install Natural
  3. Install Entire Access
  4. generate Entire Access Driver
  5. Generate a sample table “employees” on My SQL
  6. Generate the “employees” Natural DDM
  7. Write a Natural program to extract data from My SQL
  8. If i want to start/stop MySQL from natural I can use USR1052 user exit!
    Right?
    I’ll post any news about this topic!
    Bye!