Hi,
I need to run a script on CVP reporting server to fetch some reporting database and further feed for our custom reporting engine. I wrote the script in perl and could run from my laptop using odbc connection. It works fine and I can connect to Database and I can fetch the tables.
 
However, I need to run this script on CVP reporting server. When I create the ODBC connection it throws error saying
Unspecified System Error = -11356[Informix-ODBC Driver]Unspecified system Error=-11048.
 
Following are my odbc parameters.
Servername=<DB instance name>
hostname=<hostname>
Service=1526
protocol=olsoctcp
option=
database=cvp_data
userid=useridd
password=password
 
-----------------------------------------------
Client Locale=EN_US.UTF8
DatabaseLocale=EN_US.UTF8
Use Dabase Locale=<yes>
rest are all default values
 
------------------------------------------------
And my odbc driver version is 3.50 TC6
 
With above configuration I am able to connect to database from remote machine but can not connect on the same machine where informix (ie Reporting Server) is installed.
 
 
 
Does anybody know if this is feasible?. What this error means ?
Thanks
Rao