1

I am very new to Informix and Gernero and I am trying to connect to my an Informix database server that I set up on my Virtual Box Linux environment. I am using Genero Studio to on my macos system to try and connect but can never seem to make a successful connection. I have searched all over but can't find any solid reasoning as to why I can't connect. If anyone has any experience with making a connection from Genero to an external Informix database, would you please be so kind as to giving some quick instructions as to how you managed to get a successful connection.

I already set up the following:

Sqlhosts file  
Informix Server- INFORMIXSERVERNAME
Informix Dir -   INFORMIXDIR

This is the error I get when trying to connect:

Connection to database failed:
SQL: CONNECT TO "acp@ol_informix1410_1+driver='dbmifx'" AS "fgldbsch" USER "staggers" USING "***"
 | 4gl source      : fgldbslib.4gl line=887
 | loading driver  : [/Applications/Genero Studio 3.20.07-167010.app/fgl/dbdrivers/dbmifx]
 | Dynamic linker error: [dlopen(/Applications/Genero Studio 3.20.07-167010.app/fgl/dbdrivers/dbmifx.dylib, 1): Library not loaded: @rpath/isqls09b.dylib
  Referenced from: /Applications/Genero Studio 3.20.07-167010.app/fgl/dbdrivers/dbmifx_9.dylib
  Reason: image not found]...
Connection to database 'acp@ol_informix1410_1' failed.
      -6366: Could not load database driver dbmifx. Set FGLSQLDEBUG to get more details.

Any help would be greatly appreciated. Thanks!!

tbowden
  • 1,008
  • 1
  • 19
  • 44
Jstagg
  • 11
  • 2
  • Did you try setting `FGLSQLDEBUG` in the environment, as suggested? The message `Library not loaded: @rpath/isqls09b.dylib` suggests that you've not set the `DYLD_LIBRARY_PATH` environment variable to where the Informix libraries are found (`$INFORMIXDIR/lib` and/or `$INFORMIXDIR/lib/esql`). – Jonathan Leffler Feb 23 '21 at 02:53
  • You may not get much response from Genero developers here as the order of precedence to find answers tends to be 1. documentation , 2. support, 3. developer forum, 4 then here. You would need to clarify what step you are doing when trying to connect to database, is it extracting a schema, using database explorer, running a program etc, all involve "connecting to database". As Jonathon said, error mesasge indicates DYLD_LIBRARY_PATH not pointing to INFORMIXDIR but that indicates that the connection is coming from Mac rather than Linux, so you may need to check Local v Remote config – fourjs.reuben Feb 23 '21 at 21:22

0 Answers0