Informix connection error 9293
Informix connection error 9293
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.
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.
Re: Informix connection error 9293
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.
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.
Re: Informix connection error 9293
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.
Thanks for your feedback.
Re: Informix connection error 9293
Hi.
Attached what you asked.
Yes, I use CTD1.5.1, TD4.2 and TD5.2
Hope to help.
My best regards.
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.
Re: Informix connection error 9293
Hello,
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,
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.[win32client]
clientname=Win32User
clientruntimedir="c:\program files\unify"
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,
Re: Informix connection error 9293
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
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
Re: Informix connection error 9293
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.
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.
You do not have the required permissions to view the files attached to this post.
Re: Informix connection error 9293
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.I believe that the sqlifx32.dll is not being found.
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?)
Re: Informix connection error 9293
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.
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.
Who is online
Users browsing this forum: [Ccbot] and 4 guests