Refering to MySQL Database in 4GL

[SamyO]

Hey,

I'm trying to refer to a MySQL database in a 4GL program with no success. This is the error I get when I try to compile my program:

DATABASE statusdb
| Can not open Database dictionary 'statusdb'. Run fglschema database.
| See error number -6601.

So I try fglschema statusdb and:

ERROR: "statusdb" Unknown error message -930.

Then I look up the error number and I get:

-930 Cannot connect to database server servername.

This is the first time I try using MySQL for a 4GL program and I think the problem is related to environment variables not being set properly. The problem is, I'm really not sure what should be set and what they should be set to.

Anything that will help point me in the right direction is appreciated.

Thanks in advance,
Samy

 

[SamyO]

Update

I decided to compile and run a program I found in $FGLDIR/src called testbase.4gl. This program failed at the attempt of creating a database and displayed the following error message:

status error nr -6365:
Database driver not connected yet.

I tried looking up the error number for more information with no success. I'm not sure what the message is referring to when it says "Database driver" but I know I can get into mysql manually and access the statusdb database with no problems.

 

[olded]

Sam:

Informix 4GL is a proprietary environment. If you get it to connect to MySQL, I will be very much surprised. If you do, please let us know.

I'm not familiar with the 6365 error. The finderr utility doesn't show it as a valid informix error.

Regards,


Ed

 

[SamyO]

Ed,

I'm pretty sure it's possible to connect to a MySQL database using 4GL because they provide an adaptation guide for MySQL (

http://www.4js.com.au/docs/odi/odiagmys.htm).

However, we have never done it before.. we're curently using Oracle and Informix databases but want to try out MySQL.

Again, my guess is that I have to set some environment variables that tells it that it's a MySQL database that I'm trying to refer to. However, I'm unsure of what I have to set and what I have to set it to.

Thanks,
Samy