Error -25596 when trying to connect to use the Informix Online Server native data source

[Former Member]

Hi All,

We currently use a very old version on crystal (v9) and have recently downloaded the current version (14.1.1.1036) in order to investigate the effort involved in upgrading.

In the past we have always connected to our IBM Informix Server using the native Crystal Reports Informix Online Server data source, but all attempts with the current version of Crystal Reports are failing with error -25596.

The error is reported by Informix and it has this description:

-25596  The INFORMIXSERVER value is not listed in the sqlhosts file or the

Registry.

The default database server name that the INFORMIXSERVER environment

variable specifies must be a valid database server name in the file

$INFORMIXDIR/etc/sqlhosts on UNIX or the registry on Windows. Check

that the specified server is listed in the sqlhosts file or the

registry.

However, I'm of the opinion that the server is known and is configured OK (it's configured using the Informix SetNet32 application and it has resulted in this registry key being populated:HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informix\SqlHosts\prod1_devdb1 (NB: prod1_devdb1 is the name of the server I am trying to connect to).

I can create ODBC datasources on my PC and they work OK.  I can also run our legacy VB6 application (using the Crystal 9 COM objects) and connect using the native drivers to the Informix database.

My PC is running 64 bit Windows 7 Enterprise (fully patched).  Our Informix server is version 11.7 running on a SUSE server.

Any suggestions for where to start looking to solve this?

[Former Member · Accepted solution]

This issue has been solved.  I upgraded to the latest version of the IBM Informix SDK (from version 3.70 to version 4.1) and it worked after that.

I'm not 100% sure if it was the upgrade itself, or a change I was forced to do the Path on my PC in order to do the upgrade.  The path change was to add "C:\Windows\SysWOW64" to the start of the Path (it was already in the Path, but not at the start).

Thanks also to Don for his assistance with this issue...

[former_member11696]

Hi Scott,

I checked the PAM and that version is supported...

As a test if you configure a System ODBC connection does that work? Make sure you use the 32 bit ODBC Admin. And both the 32 and 64 bit ODBC Admin executables are odbcadm32.exe. The one you want to use is located here:

C:\Windows\SysWOW64

CR Designer is a 32 bit application so it means you need to use the 32 bit Client. Typically the Client detects the OS platform and installs the 64 bit version, but in this case you must use the 32 bit client.

If you are using the 32 bit client then try enabling CR DB logging to see if it tells you anything new...

Add these 3 values to the System Environment variables:

LOGGING_DIR = c:\logging

LOGGING_ENABLED_ASSERT = 1

LOGGING_ENABLED_RUNTIME = 30

Create the logging folder of course, and then try to connect. Close CR Designer first.

To turn off logging remove the lines, you can rename crlogger.dll to *.org but if you install a patch that file will get updated and logging will be enabled again. So if you notice slow performance look in the logging folder first...

Don

[Former Member]

Hi Don,

Thanks for  the response.

I think I'm running the 32 bit version of Crystal.  It's installed in C:\Program Files (x86)\SAP BusinessObjects and Help-->About--MoreInfo shows lots of the loaded modules live in c\Windows\SysWOW64.

I'll ran the logging, but the logs didn't seem to contain anything significant.  In fact, interestingly enough, once the native Informix login form is displayed, the log isn't updated until the form is closed.  That is, I enter my credentials, click OK, see the -25596 error and acknowledge it, all without the log being updated. 

FYI, all I am doing after starting crystal is going into the File-->Log On of Off Server option (I'm not actually trying to use a report at this stage). 

With in that option, if I select ODBC as my connection method, I can connect OK (e.g. using a data source named "globalstar:prod1_devdb1:devdb1").  I can also see in the logs that the connection was made successfully.

One other interesting point is that I have validated the Informix server. I have successfully tested a native connection to "prod1_devdb1" using the Informix ILogon Demo application (it gets installed when the Informix drivers are installed on a PC).  I also find that if I deliberately mistype the server name (e.g. I enter prod1_devdb1x), I see a -25596 error (as you would expect).

Regards Scott

[former_member11696]

Hi Scott,

Correct, that is where CR is installed, it is a 32 bit app.

Is the informix client install in the PATH statement? CR still uses it to find the client.

Did the logs show you logging on with the user name, PW is **** out...?

Can you paste in the info from the log, remove any senisitive info of course... but verify the IP or Server name is absolutely correct.

Don

[Former Member]

Hi Don,

My path has a correct reference to Informix Client:

C:\Program Files (x86)\IBM Informix Client SDK\bin

I will post another reply with the contents of the "runtime" log.  The process I followed was:

1. Delete log files

2. Start CR

3. Try to log onto Informix Server

4. Acknowledge error message and the cancel out of logon form

5. Close CR

The entire log file is included in the post below.  The only modifications I've made was to deleted the blank lines...

NB the "assert" log was empty bar for a heading record. 

[Former Member]

TIMESTAMP	THREAD_ID	FILENAME	LINE_NUMBER	LOGGED_DATA	LEVEL
2014-5-1-3-54-31	10828	..\cserrinf.cpp	523	Error 14722 (..\csdll.cpp, 117): : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\crw32_res_xx.dll	1
2014-5-1-3-54-51	10828	.\QESession.cpp	445	Set Product View Locale: 1033	20
2014-5-1-3-54-51	10828	.\QESession.cpp	479	Set Preferred View Locale: 3081	20
2014-5-1-3-54-51	10828	.\QESession.cpp	501	Set Process Locale: 3081	20
2014-5-1-3-54-51	10828	.\qecommon.cpp	117	This property is currently in a read-only state and cannot be modified. File Name: ".\QEProperty.cpp". Line: 217	1
2014-5-1-3-54-54	10828	.\xml.cpp	211	Leaving DbInitialize()	20
2014-5-1-3-54-54	10828	.\xml.cpp	153	In DbInitialize()	20
2014-5-1-3-54-54	10828	.\xml.cpp	211	Leaving DbInitialize()	20
2014-5-1-3-54-54	10828	.\xml.cpp	385	In DbFetchDatabaseType()	20
2014-5-1-3-54-54	10828	.\xml.cpp	399	Leaving DbFetchDatabaseType()	20
2014-5-1-3-54-54	10828	.\xml.cpp	4732	In DbFreeString()	20
2014-5-1-3-54-54	10828	.\xml.cpp	4735	Leaving DbFreeString()	20
2014-5-1-3-54-54	10828	.\jdbc.cpp	241	Leave DbInitialize()	20
2014-5-1-3-54-54	10828	.\jdbc.cpp	185	Enter DbInitialize()	20
2014-5-1-3-54-54	10828	.\jdbc.cpp	241	Leave DbInitialize()	20
2014-5-1-3-54-54	10828	.\jdbc.cpp	555	Enter DbFetchDatabaseType()	20
2014-5-1-3-54-54	10828	.\jdbc.cpp	564	Leave DbFetchDatabaseType()	20
2014-5-1-3-54-55	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-54-55	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-54-55	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-54-55	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	194	Leaving DbInitialize()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	148	In DbInitialize()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	194	Leaving DbInitialize()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	317	In DbFetchDatabaseType()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	326	Leaving DbFetchDatabaseType()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	1858	In DbFreeString()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	1861	Leaving DbFreeString()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-54-57	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-54-57	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-54-57	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-2	10828	.\crdb_wic.cpp	182	Leaving DbInitialize()	20
2014-5-1-3-55-2	10828	.\crdb_wic.cpp	127	Enter DbInitialize()	20
2014-5-1-3-55-2	10828	.\crdb_wic.cpp	182	Leaving DbInitialize()	20
2014-5-1-3-55-2	10828	.\crdb_wic.cpp	381	Enter DbFetchDatabaseType()	20
2014-5-1-3-55-2	10828	.\crdb_wic.cpp	397	Leave DbFetchDatabaseType()	20
2014-5-1-3-55-2	10828	.\crdb_wic.cpp	404	In DbFreeString()	20
2014-5-1-3-55-2	10828	.\crdb_wic.cpp	407	Leaving DbFreeString()	20
2014-5-1-3-55-9	10828	..\crdb_p2s.cpp	570	Entering SQLLogOnSQLServerWithExtendableOptions	20
2014-5-1-3-55-45	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-45	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-45	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-55-45	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-46	10828	..\crdb_p2s.cpp	577	Leaving SQLLogOnSQLServerWithExtendableOptions	20
2014-5-1-3-55-46	10828	..\serverhandle.cpp	356	succeeded: serverName=prod1_devdb1,databaseName=globalstar,userID=scottr	1
2014-5-1-3-55-46	10828	..\..\convert.cpp	864	Error: message=, DbError=202	1
2014-5-1-3-55-46	10828	..\cserrinf.cpp	523	Error 31816 (..\..\src\data\queryenghelp.cpp, 549): Logon failed.:	1
2014-5-1-3-55-53	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\jdbc.cpp	173	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-53	10828	..\..\src\print\format\imageretriever.cpp	905	Destroy API called. Image Retriever was not used. No cleanup necessary.	20
2014-5-1-3-55-53	10828	.\xml.cpp	219	In DbTerminate()	20
2014-5-1-3-55-53	10828	.\xml.cpp	271	Leaving DbTerminate()	20
2014-5-1-3-55-53	10828	.\jdbc.cpp	250	Enter DbTerminate()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	203	In DbTerminate()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	252	Leaving DbTerminate()	20
2014-5-1-3-55-53	10828	.\crdb_wic.cpp	190	In DbTerminate()	20
2014-5-1-3-55-53	10828	.\crdb_wic.cpp	241	Leaving DbTerminate()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	203	In DbTerminate()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	252	Leaving DbTerminate()	20
2014-5-1-3-55-53	10828	.\crdb_wic.cpp	190	In DbTerminate()	20
2014-5-1-3-55-53	10828	.\crdb_wic.cpp	241	Leaving DbTerminate()	20
2014-5-1-3-55-53	10828	.\xml.cpp	219	In DbTerminate()	20
2014-5-1-3-55-53	10828	.\xml.cpp	271	Leaving DbTerminate()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\xml.cpp	112	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	113	In DllMain()	20
2014-5-1-3-55-53	10828	.\javabeans.cpp	136	Leaving DllMain()	20
2014-5-1-3-55-53	10828	.\xml.cpp	112	Leaving DllMain()	20

[former_member11696]

Hi Scott,

When you try to log on which Database driver are you selecting?

Current version no longer have a Native Informix driver so you have to select ODBC or OLE DB or possibly JDBC.

when you try to connect which driver are you selecting?

Logs show it's trying to use XML or JDBC.

If that's is the case then hit the F1 key and follow the info on how to configure a JDBC driver.

Don

[Former Member]

I'm using the native Informix Online Server option:

[former_member11696]

Hi Scott,

In the log the error 202 seems to be the cause. According to informix error codes:

Error Codes from -200 Through -899

Error codes from -200 to -899 indicate problems in the execution of an SQL
statement. These codes are returned to the SQLCA. An ISAM error code accompanies
many of these messages.

This can typically mean the user may not have permissions to the table or there are differences in the clients being used.

Don