Solved TD-3935: TD 5.1 Informix Native Router

Post found bugs and possible workarounds.
Heinrich Wolf

TD-3935: TD 5.1 Informix Native Router

Post by Heinrich Wolf » 04 Dec 2007, 15:42

Hi,



I tested the connectivity with two different databases on Informix Dynamic Server over native router with a common sql.ini as shown below on two different Team Developer releases. On TD 5.1 I don't get connected to any of these databases. Error number 401 "Cannot open database" is raised. On TD 4.0 I get connected to both databases. You will find the native routers' log files below.



Please tell me how to establish a connectivity over sqlifx32.dll on TD 5.1

Kind regards

Heinrich Wolf



Contact Details: Heinrich.E.Wolf[at]SIEMENS.com

Platform: Windows

OS Version: XP Professional SP2

Product: Team Developer

Product Version: 5.1.0 Build 5917

Short Description: Informix Native Router

Stack traces? Router Log file see below

Third party software? Informix Dynamic Server

Repro Case!





sql.ini

[infogtwy]

remotedbname=himed7, DATABASE himed, -hfu17921d -ssqlexec -vfu17921d

remotedbname=himed, DATABASE himed, -hfu17908d -ssqlexec -vfu17908d

defconnect=off

longbuffer=200000



[win32client]

clientname=Win32User



[win32client.dll]

comdll=sqlifx32



[win32client.ifx32]

log=c:\himed\ifx32.log



[odbcrtr]

odbctrace=off

odbctracefile=c:\himed\sql.log



ifx32.log from TD 4.0

12/3/07 15:20:22 0> SQLRouter LOG Utility - version 2.1.0

12/3/07 15:20:22 0> SQLRouter/Informix 7.x - version 3.0.0

12/3/07 15:20:22 0> remotedbname=himed7, DATABASE himed, -hfu17921d -ssqlex

12/3/07 15:20:22 0> ec -vfu17921d ; Informix Dynamic Server 7.31

12/3/07 15:20:22 0> remotedbname=himed, DATABASE himed, -hfu17908d -ssqlex

12/3/07 15:20:22 0> ec -vfu17908d ; Informix Dynamic Server 10.0

12/3/07 15:20:22 0> defconnect=off

12/3/07 15:20:22 0> longbuffer=200000

12/3/07 15:20:22 1> [connect] dbname = himed username = wh9823

12/3/07 15:20:22 1> [set database parameter] param = 5106 value = 0

12/3/07 15:20:23 1> [disconnect]

12/3/07 15:20:34 1> [connect] dbname = himed7 username = himedcl

12/3/07 15:20:34 1> [set database parameter] param = 5106 value = 0

12/3/07 15:20:36 1> [disconnect]



ifx32.log from TD 5.1

12/3/07 15:30:41 0> SQLRouter LOG Utility - version 2.1.0

12/3/07 15:30:41 0> SQLRouter/ODBC - version 4.0.0

12/3/07 15:30:41 0> odbctrace=off

12/3/07 15:30:41 0> odbctracefile=c:\himed\sql.log

Ana Paula Bonani

Re: TD-3935: TD 5.1 Informix Native Router

Post by Ana Paula Bonani » 06 Dec 2007, 05:29

Hello,

This is defect TD-3935.
It has been fixed and will be available in TD5.1 service pack 1.

Thanks,
Ana
--
Unify Technical Support

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests