This document was generated from CDN thread
Created by: Raghavendra Rao on 27-04-2010 03:55:25 AM
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
Subject: RE: ODBC connection to CVP Reporting Server Failing.
Replied by: Raghavendra Rao on 27-04-2010 03:03:23 PM
Found the answer myself . The error was because environment variable INFOMIXDIR was not set properly. This directory should be pointing to where client sdk is installed. Issue resolved.