Results 1 to 15 of 15
  1. #1
    Join Date
    Apr 2011
    Posts
    7

    Unanswered: How to solve this error?

    -----------Source Code-------
    SCHEMA custdemo

    MAIN
    DEFINE l_store_name LIKE customer.store_name

    CONNECT TO "custdemo"

    CALL select_name(101)RETURNING l_store_name
    DISPLAY l_store_name

    DISCONNECT CURRENT

    END MAIN


    -----error Display------
    SQL statement error number -6366 (0).
    Could not load database driver dbmdefault.



    this error how to solve?

  2. #2
    Join Date
    Sep 2004
    Posts
    51

    How to solve this error

    The error is coming from the application. I cannot locate the error with the informix applications. Can you verify what application tool you are using.

  3. #3
    Join Date
    Apr 2011
    Posts
    7
    im using genero studio application ....

  4. #4
    Join Date
    Sep 2004
    Posts
    51

    How to solve this error?

    The error message indicates an error using driver dmbdefault. Which database version are you using, Informix, SqlServer, Oracle, etc. I need to install Genero to find out how it picks up the database type and version.

  5. #5
    Join Date
    Apr 2011
    Posts
    7
    im using informix database

  6. #6
    Join Date
    Sep 2004
    Posts
    51

    How to solve this error?

    In the environment make sure that both Informix and Genero has been configured. I ran into the same error using fglschema when the informix environment was not set up. At a minimum make sure INFORMIXSERVER, INFORMIXSQLHOSTS and LD_LIBRARY_PATH is set.

    Also run fglschema database name to create the schema file.

    In the $FGLDIR/dbdrivers directory make sure the dbmifx*.so file exists.

    I hope this helps.

  7. #7
    Join Date
    Apr 2011
    Posts
    7
    teach me how to set the INFORMIXSERVER, INFORMIXSQLHOSTS and LD_LIBRARY_PATH...because i 1st time using genero studio...

    if $FGLDIR/dbdrivers directory dont have the file, how can get the file?

    if can post some pic ><"

  8. #8
    Join Date
    Apr 2011
    Posts
    7
    in the directory file only have dbmifx9x.dll

    i in the environment set place but i cant find the INFORMIXSERVER, INFORMIXSQLHOSTS and LD_LIBRARY_PATH
    so i dont know where need to set the environment value....

  9. #9
    Join Date
    Sep 2004
    Posts
    51

    How to solve this error?

    I am using Linux Suse with a csh shell.

    setenv INFORMIXSERVER=ids11tcp
    setenv INFORMIXSQLHOSTS=/home/informix/sqlhosts
    setenv LD_LIBRARY_PATH ${INFORMIXDIR}/lib:${INFORMIXDIR}/lib/esql:${INFORMIXDIR}/lib/tools:${INFORMIXDIR}/lib/c++:/usr/lib


    I created the sqlhosts file in my home directory to use with either the tools or server. The fourth column for onsoctcp is the port used in the services file. The settings above will only work for Informix.

    informix@linux11:~> cat sqlhosts
    ids11 onipcshm linux11 ids11
    ids11tcp onsoctcp linux11 ids11tcp
    ids11tcp1 onsoctcp linux11 ids11tcp1

    I hope this helps





    informix@linux11:~>

  10. #10
    Join Date
    Apr 2011
    Posts
    7
    omg
    im using windows TT
    totally different with u ><""

  11. #11
    Join Date
    Sep 2004
    Posts
    51

    How to solve this error?

    Not so different.

    First find out if informix server is installed, If not then you will need to contact Fourjs for this issue.

    From the start button click on programs, is IBM Informix Dynamic Server listed.

    IF not I'm done.

    However, FYI the sqlhosts file on Windows is in the registry.

    The environment can be checked by going to a command prompt then type set.

    If you created the database from the fourjs studio then it should be using fourjs database and not informix.

    HTH!

  12. #12
    Join Date
    Apr 2011
    Posts
    7
    Thank You very much

  13. #13
    Join Date
    Jun 2011
    Posts
    1
    I am using Linux Suse with a csh shell.




    _____________________
    Healthy living every day! P90x Workout Videos,a good lifestyle !

  14. #14
    Join Date
    Feb 2013
    Posts
    1

    Genero Could not load database driver

    Hi

    I'm trying to run DSconfig sample application in Genero Runtime Suit on Windows Server 2008. In Genero Studio it works
    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??

  15. #15
    Join Date
    Sep 2004
    Posts
    51

    How to solve this error

    From what I have found is that you are using the wrong database.

    Genero uses a schema file not the database directly.

    I will usually use the same name for the schema file as the database uses.

    You need to run fglshema program on your database.

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •