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

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.

im using genero studio application ....

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.

im using informix database

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.

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

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

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

omg
im using windows TT
totally different with u ><""

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!

Thank You very much

I am using Linux Suse with a csh shell.




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