Genero database connectivity problem

[pravin...@gmail.com]

Hi,

I am trying to develop sample database application using Genero. But I
face following error:

Program stopped at 'search.4gl', line number 60.
FORMS statement error number -6366.
Could not load database driver dbmdefault. Set FGLSQLDEBUG to get more
details.

Whereas line#60, having 'CONNECT TO "custdemo"' or containing sql
statement.

I am not sure what is this error exactly. I checked Schema and
configurations regarding Genero DB. But still same problem.

Please help me in above error, if anybody has solution.

Thanks in advance.

Regards,
Pravin Bankar

[Art Kagel]

Something in the Genero environment is not set so the runtime engine could not find the shared library that contains the database drivers.  Not a Genero expert, but there should be a quick start guide that covers setting up the runtime environment.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

[Alexandre Marini]

Hello.
There is a good branch of publications here:
https://www-304.ibm.com/support/docview.wss?uid=swg27020968

Hope it helps.
Regards.

Em 03/10/2011 11:14, Art Kagel escreveu:

Something in the Genero environment is not set so the runtime engine could not find the shared library that contains the database drivers.  Not a Genero expert, but there should be a quick start guide that covers setting up the runtime environment.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

On Mon, Oct 3, 2011 at 11:03 AM, pravin...@gmail.com <pravin...@gmail.com> wrote:

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

--

Alexandre Marini

Tecnologia da Informação - DBA

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70 IBM Information Management Informix Technical Professional v3

 

[Francesco Veroni]

On Oct 3, 5:03 pm, "pravineban...@gmail.com" <pravineban...@gmail.com>
wrote:

Hi, normally this problem comes out because the variable
LD_LIBRARY_PROFILE has been not setted. Try to do that adding the
variable into Genero Studio environment configuration, under the
Informix voice. Be sure that this set of variables has been activated,
by default the related icon is not setted.

[pravin...@gmail.com]

On Oct 3, 8:14 pm, Art Kagel <art.ka...@gmail.com> wrote:
> Something in the Genero environment is not set so the runtime engine could
> not find the shared library that contains the database drivers.  Not a
> Genero expert, but there should be a quick start guide that covers setting
> up the runtime environment.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog:http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference.  Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>

> On Mon, Oct 3, 2011 at 11:03 AM, pravineban...@gmail.com <

>
>
>
>
>
>
>
> pravineban...@gmail.com> wrote:
> > Hi,
>
> > I am trying to develop sample database application using Genero. But I
> > face following error:
>
> > Program stopped at 'search.4gl', line number 60.
> > FORMS statement error number -6366.
> > Could not load database driver dbmdefault. Set FGLSQLDEBUG to get more
> > details.
>
> > Whereas line#60, having 'CONNECT TO "custdemo"' or containing sql
> > statement.
>
> > I am not sure what is this error exactly. I checked Schema and
> > configurations regarding Genero DB. But still same problem.
>
> > Please help me in above error, if anybody has solution.
>
> > Thanks in advance.
>
> > Regards,
> > Pravin Bankar
> > _______________________________________________
> > Informix-list mailing list

> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list

Thanks a lot Art for quick response.

Now I am able to rum my Genero application.
As I refereed demo applications and made changes in source code as
follow:

CONNECT TO "custdemo+driver='dbmads381'" USER "custdemo" using
"custdemo"

Thanks again. I will reach you again, if any issue in Informix 4gl /
Informix Genero.

Thanks & Regards
Pravin Bankar

[rskor...@gmail.com]

Hi

I'm trying to run DSconfig sample application in Genero Runtime Suit on Windows Server 2008.
I have changed fglprofile, by add my connectoin to informix db:

dbi.database.officestore.source = "C:/Users/Robert/Documents/My Genero Files/samples/databases/officestore/sqlite/officestore.db"
dbi.database.officestore.driver = "dbmsqt3xx"
dbi.database.custdemo.source = "C:/Users/Robert/Documents/My Genero Files/samples/databases/custdemo/sqlite/custdemo.db"
dbi.database.custdemo.driver = "dbmsqt3xx"
dbi.database.rstest.source = "rstest@ol_ifx1170"
dbi.database.rstest.driver = "dbmifx9x"

When i try to test any of these I always get the same error:
-6366 Could not load database driver

Something must be wrong because test officestore and custdemo not work

I have setup xcf file:

<APPLICATION Parent="defaultgwc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://www.4js.com/ns/gas/2.40/cfextwa.xsd">
<EXECUTION>
<ENVIRONMENT_VARIABLE Id="INFORMIXDIR">C:\Program Files\IBM\Informix\11.70</ENVIRONMENT_VARIABLE>
<ENVIRONMENT_VARIABLE Id="INFORMIXSERVER">ol_ifx1170</ENVIRONMENT_VARIABLE>
<ENVIRONMENT_VARIABLE Id="PATH">C:\Program Files\IBM\gsk8\lib64</ENVIRONMENT_VARIABLE>
<PATH>$(res.path.app)/DSConfig</PATH>
<MODULE>DSConfig.42r</MODULE>
</EXECUTION>
</APPLICATION>

dbaccess is working.
And I have set up enviroment variables in *.bat file:
set INFORMIXDIR=C:\Program Files\IBM\Informix\11.70
set INFORMIXSERVER=ol_ifx1170
set ONCONFIG=onconfig.ol_ifx1170
set PATH=C:\Program Files\IBM\Informix\11.70\bin;C:\Program Files\IBM\gsk8\lib64;


set PATH=C:\Program Files\IBM\Informix Genero\Genero Developer Suite\fgl\bin;C:\Program Files\IBM\Informix Genero\Genero Runtime Suite\fgl\dbdrivers
set FGLPROFILE=DSConfig.prf
rem Target front-end
set FGLSERVER=localhost:0
rem Path to resource files like forms and string files
set DBPATH=.\

rem Path to program modules
set FGLLDPATH=.\
fglrun DSConfig.42r

Could someone tell me what is wrong??