DB2 storedprocedure (on DB2 Server Connect 9.5) and CF8

Hi there,

We are having an issue running DB2 storedprocedure (DB2 Connect Server Version 9.5 Fix Pack 2 ) via ODBC Data source on ColdFusion 8.

the same storedprocedure running on CF5 (either with the DB2 Server Connect 9.5 or 7 installed) will return the data result properly but not on CF8

(the data result returned on CF8 is all unreadable chars such as "Ñ¦ vH §[][]Ÿ–Àå–[] [] 2 o...."). It must CF8 related problem if am not wrong.

Any one has a clue?

Thanks in advance for all you input!

-Tony

This topic has been closed for replies.

Inspiring

CF kinda moved its approach to DB connectivity from ODBC or OleDB to JDBC when CF was rewritten in Java. Can you not use the JDBC drivers instead?

--

Adam

Participant

Thanks for your quick reply!

I have been thinking about the it, but i havn't found any info about using JDBC drivers to connect DB2 Server Connect 9.5....any clue?

-Tony

Inspiring

I've never used DB2, so don't know any specifics. Surely it's just a matter of adding a DB2 datasource in CFAdmin..?

--

Adam

Sign up