Informix connection error 9293

General discussion forum about all databases other than SqlBase.
itsrb

Informix connection error 9293

Post by itsrb » 30 Sep 2010, 16:56

Upgrading(attempting) to 5.2(SP2) from 4.1. Cannot connect to Informix database.

Environment: Windows XP SP3

SQL.INI entries:

[win32client]
clientname=Win32User
clientruntimedir="c:\program files\unify"

[win32client.dll]
comdll=sqlifx32

No other sql.ini or sqlifx32 files are present on the system.

System path:

C:\Program Files\Unify;C:\Program Files\Unify\Team Developer 5.2;C:\Program Files\Business Objects\Common\3.5\bin\NOTES\;C:\Program Files\Business Objects\Common\3.5\bin\NOTES\DATA\;C:\Program Files\HEAT\;C:\INFORMIX\BIN

SetNet32 version: 7.20 (also have attempted version 2.90)

Error (IDE or EXE):

9293 GCI NDL Cannot load any communication DLLs, network may not be installed

Reason: This error is currently undocumented.

Remedy: Contact your local Gupta Technologies, LLC certified technical
support center for assistance.

----------------------------------------------------

After the initial installation, the system path was set to:

C:\Program Files\Unify\Team Developer 5.2;C:\Program Files\Unify\Team Developer 5.2\axis2c\lib;C:\Program Files\Unify\Team Developer 5.2;C:\Program Files\Gupta\Team Developer 2005.1;C:\Centura\Dbcnvt;C:\Centura\Samples;C:\Centura;C:\orant\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\Lenovo;C:\INFORMIX\BIN

Obviously the 5.1 version would not function at that point. Once the entries of 5.2 were removed, the 5.1 version was
again functional.

ivano_osti
Brazil
Posts: 415
Joined: 17 Nov 2017, 20:02
Location: Itapira-SP, Brazil

Re: Informix connection error 9293

Post by ivano_osti » 30 Sep 2010, 19:30

Hi.

I connect with Informix with no problem.

When I was evaluating TD5.1, I had to change my iconnect(setnet) to a newer (see attachment).

I just had success to connect after using the new iconnect.

If you don't have success, I send you my sql.ini

My best regards.
You do not have the required permissions to view the files attached to this post.

itsrb

Re: Informix connection error 9293

Post by itsrb » 30 Sep 2010, 21:08

I would prefer not to change the SetNet version(specifically considering in the published TD5.2 documentation, it references the same version that I am using)....I would consider this only as a last option. That would be great if you could send your sql.ini and also perhaps your system path? Question - do you have other versions of TD installed as I do?

Thanks for your feedback.

ivano_osti
Brazil
Posts: 415
Joined: 17 Nov 2017, 20:02
Location: Itapira-SP, Brazil

Re: Informix connection error 9293

Post by ivano_osti » 01 Oct 2010, 12:04

Hi.

Attached what you asked.

Yes, I use CTD1.5.1, TD4.2 and TD5.2

Hope to help.

My best regards.
You do not have the required permissions to view the files attached to this post.

Ana Paula Bonani

Re: Informix connection error 9293

Post by Ana Paula Bonani » 04 Oct 2010, 23:41

Hello,
[win32client]
clientname=Win32User
clientruntimedir="c:\program files\unify"
Your clientruntimedir must point to the location of the TD Informix router and other TD DLLs. In other words, from your PATH, it must point to C:\Program Files\Unify\Team Developer 5.2.

Please change your sql.ini clientruntimedir to see if that's the cause of the problem.

If it doesn't, please use Dependency Walker (https://www.dependencywalker.com) to find if there are any dependent DLLs missing in your system for the connection to work.

Hope this helps,

itsrb

Re: Informix connection error 9293

Post by itsrb » 06 Oct 2010, 14:46

I have actually tried that, among several other things, without success. In your scenario, i believe it does not find the sqlifx32.dll file.

Path:
C:\Program Files\Unify;C:\Program Files\Unify\Team Developer 5.2;C:\Program Files\Unify\Team Developer 5.2\axis2c\lib;C:\Program Files\Unify\Team Developer 5.2;C:\orant\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\Lenovo;C:\INFORMIX\BIN

Sql.ini:
[win32client]
clientname=Win32User
clientruntimedir="C:\Program Files\unify\Team Developer 5.2\"

[win32client.dll]
comdll=sqlifx32

(there are no other sql.ini/sqlifx32.dll files)

Error - 9293 Cannot Load Any Comm DLLs

itsrb

Re: Informix connection error 9293

Post by itsrb » 06 Oct 2010, 20:27

Hello

I have actually tried that, among several other things, without success. I believe that the sqlifx32.dll is not being found.

Path:
C:\Program Files\Unify;C:\Program Files\Unify\Team Developer 5.2;C:\Program Files\Unify\Team Developer 5.2\axis2c\lib;C:\Program Files\Unify\Team Developer 5.2;C:\orant\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\Lenovo;C:\INFORMIX\BIN

Sql.ini:
[win32client]
clientname=Win32User
clientruntimedir="C:\Program Files\unify\Team Developer 5.2\"

[win32client.dll]
comdll=sqlifx32

(no other sql.inn/sqlifx32.dll files exist)

Error = 9293 Cannot load any comm DLLs.
support.zip
You do not have the required permissions to view the files attached to this post.

Jeff Luther

Re: Informix connection error 9293

Post by Jeff Luther » 07 Oct 2010, 00:47

I believe that the sqlifx32.dll is not being found.
I just did a start/run... of sqlifx32.dll and up popped my PE Explorer pgm. (http://www.heaventools.com) for looking at DLLs, proving that file's in my PATH. Maybe try that running that yourself and see what happens.

This folder: C:\Program Files\Unify\Team Developer 5.2;
should be right where it lives. Isn't it there in that folder for you?

I see a diff. in my INI:
clientruntimedir="C:\Program Files\Unify\Team Developer 5.2"
I have that entry without a final backslash, as you show you have.

Last, don't know why I suggest this, but add: comdll=sqlws32
to [win32client.dll] after the other comdll= you have. sqlws32 (SQLBase I know needs to be last, if listed. Perhaps it's also required to have that entry?)

itsrb

Re: Informix connection error 9293

Post by itsrb » 07 Oct 2010, 14:38

Yes - the sqlifx32.dll is in the correct folder (see attached). No other sqlifx32.dll files exist.

1) i removed the "\" from the end of the clientruntime variable. (i had actually tried this before).

[win32client]
clientname=Win32User
clientruntimedir="C:\Program Files\Unify\Team Developer 5.2"

2) i added the sqlws32 entry.

[win32client.dll]
comdll=sqlifx32
comdll=sqlws32

[infogtwy]
remotedbname=crstsm6,DATABASE crstst_m6, -sreserve_soc_m6_tst -hu7mtst.motel6.com -vreserve_soc_m6_tst

So with this entry, I get a 9268 - cannot connect error. If I remove it, then i am back to the 9293 - cannot load dll error.

I still believe that for some reason, it does not recognize the sqlifx32 entry.
You do not have the required permissions to view the files attached to this post.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests