Re: Help connect in aubit4gl

Yes,
at the minute - the CONNECT statement isn't implemented for Mysql.

You can still connect to a database using the DATABASE statement, and
specify the username/password in the environment or in the "acl" file.

If you need the ability to change the username/password - I can look at
implementing it - I don't think it would be too difficult, but I dont think
Mysql can handle concurrent "sessions" from the same client program (which
is why its not there atm)


On 8 January 2015 at 03:46, Herman Carrion L. <[email protected]>
wrote:

> Hi everyone...and happy  new year.
>
> Mi code:
>
> -----------------------------------------------------------------------------------------
>   1 DATABASE prueba
>   2 MAIN
>   3
>   4 DEFINE base1    CHAR(60)
>   5 DEFINE base2    CHAR(60)
>   6 DEFINE user1    CHAR(60)
>   7 DEFINE user2    CHAR(60)
>   8 DEFINE pass1    CHAR(60)
>   9 DEFINE pass2    CHAR(60)
>  10
>  11 LET base1="prueba" CLIPPED
>  12 LET base2="prueba_policentro" CLIPPED
>  13 LET user1="root" CLIPPED
>  14 LET user2="root" CLIPPED
>  15 LET pass1="fender" CLIPPED
>  16 LET pass2="fender" CLIPPED
>  17
>  18 CONNECT TO base1 AS con1 USER user1 USING pass1
>  19
>  20 SELECT * FROM usuarios
>  21         WHERE codigo="bodegaop"
>  22
>  23 END MAIN
>  24
>
> ------------------------------------------------------------------------------------------
>
> Compilation=Ok.
>
> Execution: ERROR.
>
> Err:Program ./k stopped at 'k.4gl', line number 20.
> Error status number -30156.
> Sessions not implemented.
>
> 4gl function call stack :
>     MAIN
>
> my database is mysql with native connection.
>
>  Thanks for the advice.
>
> Herman Carrion L.
> Guayaquil - Ecuador
> South America
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>

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