ODBC Connection to Cache database from datastage server

[arvind_ds]

Hi Experts,

My requirement is to do data profiling on "Cache database tables" by using information analyzer tool. I have installed cache odbc drivers on datastage server successfully and have created below ODBC DSN as well in .odbc.ini file.

Cache_DSN
Driver=/opt/datastage/cache-client/bin/libcacheodbc35.so
Description=Cache ODBC DSN
Host=CacheDbserver.com
Namespace=Cache_DSN
UID=userid
Password=passwd
Port=1973
Protocol=TCP
Query Timeout=1
Static Cursors=0
Trace=off
TraceFile=iodbctrace.log
Authentication Method=0
Security Level=2
Service Principal Name=cache/CacheDbserver.com

Now when I ran sample script named example(as shown below), it reports Message sequencing error.

localdatastagehost:cd /opt/IBM/InformationServer/Server/branded_odbc/samples/example
> ./example
./example DataDirect Technologies, Inc. ODBC Example Application.

Enter the data source name : Cache_DSN

Enter the user name : userid

Enter the password : passwd
SQLSTATE = 08S01
NATIVE ERROR = 452
MSG = [Cache ODBC][State : 08S01][Native Code 452]
[libcacheodbc35.so]
Message sequencing error

Any clue on how to resolve this error. Thanks for your help.

[qt_ky]

Maybe it's just not showing correctly, but your DSN on the first line is normally surrounded by square brackets.

I have run into errors with DSNs that are over 8 characters long. You might try making it shorter, but if that were the problem here, then I would expect a different error message.

Have you tried searching on the error code or key words? If no results, then you may need to contact Support.

[ray.wurlod]

You are connecting to Cache, which is itself returning an error (code 452).
Consult your Cache documentation to learn what error code 452 means. It might also suggest remedial action.

[arvind_ds]

Thanks Guys for your valuable inputs. I will consult Cache DB admin and will post the resolution steps if I get any.