> I'm trying to connect to DB2 version 7.1 using DB2 Connect > version 7 into our MVS. Our ColdFusion 5 Enterprise > automatically identifies the connection in CFIDE, which > is great. However, MX does not - it simply doesn't appear > as a datasource, and so I cannot see DB2 with CFMX. I've > tried different hit or miss DB2 Connect Configurations > here, none of which have worked out yet.
ODBC datasources don't automatically appear in the CF Administrator in CFMX - you have to configure an ODBC Socket connection within the CF Administrator, and specify your System ODBC datasource within it. Also, others have reported performance problems using ODBC to talk to DB2, so you may want to try using a JDBC driver for DB2. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
