Datebase Explorer Informix Error

[abils@avmsoftbase.de]

Hello,

i have a problem with the connection from td4.1 and td5.1 on vista.

When I open the database explorer
there comes always the message from sqlifx32 that it cannot communicate with SQLRouter/Informix.
On XP with the same installation, all works fine.


The test Systems:
Vista SP1:
Informix CSDK 3.00 TC3
TD 5.1 SP3
TD 5.1 SP3 here we use the sqlifx32 with 148kb, which was shipped with the product.
TD 4.1 TC2 we use the sqlifx32.dll with 141kb, i think this was the dll from the Centura runtime 1.2.

XP SP3:
Informix CSDK 3.00 TC3
TD 5.1 SP3 here we use the sqlifx32 with 148kb, which was shipped with the product.
TD 4.1 TC2 we use the sqlifx32.dll with 141kb, i think this was the dll from the Centura runtime 1.2.

How could the problem be solved?

[Jean-Marc Gemperle]

Hi,

What is the version of the IFX client you are using? Generally this error is because SQLIFX32.DLL our router try to load the CLIENT API of the third party database you want to use and there might be missing dependencies. If your IFX client are the same on both VISTA and XP then in all logic it should work. Can you use WDEPEND dependancy walker (see google) and drop SQLIFX32.DLL in it if you have error this is your problem, if you see warnings it is OK....

I intalled couple days ago IFX 11 and IFX connect 3.5. and did not try it for the moment with the Gupta tools but that is the occasion to do....My WDEPENDS does not seems to show any problem and would EXPECT to be able to connect without this error, I let you know.

I also like to ask something about INFORMIX as I'm not that familiar with it and maybe you or other have a clue for me : On XP I have IDS 9 and use IFX connect 2.5. I also intalled the SQL Editor from informix this is a great tool if you don't know much IFX ( ie how to create database, with some specific NLS settings etc....) This tools is no longer existing by IBM/INFORMIX and fro some reason DBACCESS for me does not work on VISTA. I like to know what tool can be used EQUIVALENT to SQLEDITOR to create database users etc.....

Thanks

JM

[abils@avmsoftbase.de]

Hello,
thx for the answer, but all librarys seems to be correct. i traced it on both machine, there must be an other problem with vista.
perhaps any other ideas?

a good tool for informix is the serverstudio, but this ist not free...

regards,
alex

[abils@avmsoftbase.de]

hello i again, i work on this probleme for about two days now and i cannot find out, when this window comes.
i have now some xp computer, where it works and some where this message comes. when does this window come?
i tryed may things, but i cannot solve this problem, the informix csdk installation will be found by the td. i traced td with the dependancy walker, and all looks finde, but this window appear. i have tried to get the error on an working xp client, but i cannot reproduce this error.
please help... thx
regards, alex

[Jean-Marc Gemperle]

Hi,

So as promised gave it a try with
IBM Informix Connect 3.50
IBM Informix IDS 11.5
on Vista ultimate SP1 and no problem with SQLTALK and as well database explorer.

If you have this error with DBE ( dtabase explorer) I assume you would have too with SQLTALK. This error is really about TD SQLIFX32.DLL not be able to load needed DLL for some reason.


So for me this is an environment issue we need to find why. You might have a problem with the SQL.INI and CLIENTRUNTIMEDIR, it must point to the path where sqlwntm.dll, sqlbapw.dll and sqlifx32.dll are located basically the TD51 directory. You might use a mixed environmet and pickup the wrong version of the DLL...you can use process explorer from http://www.sysinternals.com also from TD 5.1 base version up to TD 5.1 SP1 you could not connect to informix you would have this error I recall, maybe you use that version of SQLIFX32.DLL...

So if you would have a VISTA +SP1 (fresh/clean)
and installed IFX 11.5 DEVELOPER version (free)
+TD 5.1 base version + SP3
and have a proper sql.ini you should connect garanty....because I can. So again we need to find what is the issue and I'm sure there is some mixup there...You use IFX connect 3.0. me 3.5 but I don't think this is the issue.

JM