Re: Win binary installation/imix odbc - connecting to database?

Yup I think it’s our old make.inc needs configuring (4glpc used directly works fine)

From: [email protected] [mailto:[email protected]] On Behalf Of Mike Aubury
Sent: 30 January 2015 15:59
To: Malcolm Perrior
Cc: [email protected]
Subject: Re: [Aubit4gl-discuss] Win binary installation/imix odbc - connecting to database?

A4GL_FUNCTION errors ?

A4GL_FUNCTION is a C #define macro - it should be "magic'ed" away by the C pre-processor...

On 30 January 2015 at 15:50, Malcolm Perrior <[email protected]<mailto:[email protected]>> wrote:
Ah! I was using A4GL_SQLTYPE=odbc32 (having also tried ifxodbc, which couldn’t find the library).

I’ve moved on now to attempting to compile some of our 4gls and getting some A4GL_FUNCTION errors so I’ll carry on with checking the environment vars…

Thanks

From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Mike Aubury
Sent: 30 January 2015 15:12
To: Malcolm Perrior
Cc: [email protected]<mailto:[email protected]>
Subject: Re: [Aubit4gl-discuss] Win binary installation/imix odbc - connecting to database?

The error is just reporting the keyword that gave rise to the error.

It sees the "DATABASE", then the "test_db" - next word is "MAIN" - which is not a "@" or anything else that could continue to be a dbname - so the error says "MAIN"..

For Windows, if you've got the ClientSDK installed
You should be setting :

A4GL_SQLTYPE=esql


make sure you set

INFORMIXDIR
INFORMIXSERVER
SQLHOSTS
etc etc

And you should be good to go - the main issue you're having is almost certainly down to the configuration around the Informix database.

If you can run an ESQL/C program - but not an Aubit4GL one - then it moves to "Aubit" settings ;)




On 30 January 2015 at 14:05, Malcolm Perrior <[email protected]<mailto:[email protected]>> wrote:
Hi all
Probably a damn fool question but I just can’t find the answer in the manuals…

Noobie question with Aubit on Windows, please be gentle!

I’ve installed the latest aubit win binaries on a win 7 machine, have created an Informix database server and database, have set up the Informix Client SDK and an  odbc connection to the test database.

Testing this, I’ ve got a simple “test.4gl” file:

DATABASE test_db
MAIN
DISPLAY “Hello Me” at 5,5 ATTRIBUTE(red)
SLEEP 5
END MAIN

Compiling with 4glpc test.4gl –o test.exe fails with the comment “Could not connect to database test_db (?) (MAIN)” in the test.err file
It compiles and runs OK without the DATABASE declaration.

Hmmm. Why does it include (MAIN) in the error line; and have I got the database declaration wrong somehow?

Thanks


**********************************************************************
The information contained in this email is intended only for the individual or entity to whom it is addressed. It may contain privileged and confidential information and if you are not an intended recipient you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please notify us immediately by telephone on (020) 8628 3456. Please also destroy and delete the message from your computer.

Any opinions expressed in this message are those of the sender only and do not necessarily represent the views of Foresters. The sender may not be authorised to give financial advice and nothing in this message should be construed as offering such advice or entering into any contract on behalf of any Foresters Company.

Forester Life Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Forester Fund Management Limited is authorised and regulated by the Financial Conduct Authority. The Children’s Mutual is a trading name of Forester Fund Management Ltd.

Companies within the Foresters UK Group are registered in England as follows:
Forester Life Limited 2997655, Forester Fund Management Limited 4315370 and Forester Holdings (Europe) Limited 3013082.

Registered Offices for all companies within the Foresters UK Group:
Foresters House, 2 Cromwell Avenue, Bromley, BR2 9BF. T 020 8628 3400. F 020 8628 3500. E [email protected]<mailto:[email protected]> foresters.com<http://foresters.com>
**********************************************************************

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Aubit4gl-discuss mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss


________________________________________________________________________
This e-mail has been scanned for all viruses by Claranet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.claranet.co.uk
________________________________________________________________________

**********************************************************************
The information contained in this email is intended only for the individual or entity to whom it is addressed. It may contain privileged and confidential information and if you are not an intended recipient you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please notify us immediately by telephone on (020) 8628 3456. Please also destroy and delete the message from your computer.

Any opinions expressed in this message are those of the sender only and do not necessarily represent the views of Foresters. The sender may not be authorised to give financial advice and nothing in this message should be construed as offering such advice or entering into any contract on behalf of any Foresters Company.

Forester Life Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Forester Fund Management Limited is authorised and regulated by the Financial Conduct Authority. The Children’s Mutual is a trading name of Forester Fund Management Ltd.

Companies within the Foresters UK Group are registered in England as follows:
Forester Life Limited 2997655, Forester Fund Management Limited 4315370 and Forester Holdings (Europe) Limited 3013082.

Registered Offices for all companies within the Foresters UK Group:
Foresters House, 2 Cromwell Avenue, Bromley, BR2 9BF. T 020 8628 3400. F 020 8628 3500. E [email protected]<mailto:[email protected]> foresters.com<http://foresters.com>
**********************************************************************

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Aubit4gl-discuss mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss


________________________________________________________________________
This e-mail has been scanned for all viruses by Claranet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.claranet.co.uk
________________________________________________________________________

**********************************************************************
The information contained in this email is intended only for the individual or entity to whom it is addressed. It may contain privileged and confidential information and if you are not an intended recipient you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please notify us immediately by telephone on (020) 8628 3456. Please also destroy and delete the message from your computer.

Any opinions expressed in this message are those of the sender only and do not necessarily represent the views of Foresters. The sender may not be authorised to give financial advice and nothing in this message should be construed as offering such advice or entering into any contract on behalf of any Foresters Company.

Forester Life Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority. 

Forester Fund Management Limited is authorised and regulated by the Financial Conduct Authority. The Children’s Mutual is a trading name of Forester Fund Management Ltd.

Companies within the Foresters UK Group are registered in England as follows:
Forester Life Limited 2997655, Forester Fund Management Limited 4315370 and Forester Holdings (Europe) Limited 3013082. 

Registered Offices for all companies within the Foresters UK Group: 
Foresters House, 2 Cromwell Avenue, Bromley, BR2 9BF. T 020 8628 3400. F 020 8628 3500. E [email protected] foresters.com 
**********************************************************************

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss