ColdFusion DSN with DB2 via ODBC

Question

I'm attempting to connect a ColdFusion application to a DB2 ODBC DSN.

Here's my error message:

Connection verification failed for data source: <DSN NAME>
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 

I've installed DB2 client tools on the server ColdFusion runs on. I've verified the credentials are correct.

Answer 1

I'm not a DB2 guy, but have you seen the Coldfusion DB2 Universal Driver doc located here? http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasources_ADV_MJS_07.html

Based on your comments, you're using ODBC Socket instead. So while this isn't 1 to 1 what you're asking, it might have something useful: Configure Solaris to DB2 ODBC http://kb2.adobe.com/cps/171/tn_17188.html

The other thing to keep in mind is that DB2 is only supported in CF Enterprise and Developer Editions. http://www.adobe.com/products/coldfusion/systemreqs/

Answer 2

http://kb2.adobe.com/cps/801/80121c8.html

This CFMX doc ended up being what we went with to get it working.

Thanks to SO for pointing us in the right direction.