Daemon, Thanks for replying. 1. Are you saying to put this in the connection string for a DB2 UDB connection? Give it the Data Library, Userid and password and it will work?
locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG;CreateDefaultPackage=TRUE; locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG; No it failed. First Pass Connection String? Second Pass Connection String? What do u mean, use the first connection string.. to create..then edit and enter second connection string? 2. Can this be done simpler.. like where is the package for the DataDirect Drivers for DB2 macromedia.jdbc.MacromediaDrivers? Can you configure an "Other" native connection using the same DataDirect Drivers..? with url jdbc:datadirect:db2://server1:50000;DatabaseName=SAMPLE;CollectionId=DEFAULT; PackageName=JDBCPKG but i guess you are creating the package above. How do u specify Libraries? Has anyone done any performance testing against JTOpen/IBM AS400 Toolkit Drivers provided by IBM? Thanks for following up on this again. Joe On Fri, 13 Dec 2002 14:50:45 -0500 Damon Cooper <[EMAIL PROTECTED]> wrote: > Hey guys... > > Here's some info that may help > > 1) Connecting using CFMX DB2 drivers on AS/400, > mainframes, etc, etc: give this sample a try: > > 1) The connect string is required to connect. > > a) First pass connection string in CFAdmin > dsn > ==================================== > > locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG;CreateDefaultPackage=TRUE; > > b) Second pass connection string in CFAdmin > dsn (sans createdefaultpackage): > > ============================================================ > > locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG; > > 2) The JDBC dirvers in CFMX Updater Release 2 > are based on the DataDirect Technologies > 3.1.0007 driver set. I don't believe this high > patch level is yet publicly available from > DataDirect. We worked with them to ensure some > patches we cared about that affected you got > fixed before we were willing to include them in > Updater 2. Updater 1 and previous shipped > 3.0.0005 or thereabouts, plus a few extra > patches from DataDirect. > > 3) Most notable about this driver set are > > a) The dozens of bug fixes > > b) Significant performance improvments in the > driver suite (we found ~10% performance > improvement in the SQL Server driver, ~20+% > performance improvement in the Oracle driver, > and we understand there are big gains for DB2 > customers as well), and > > c) Solid STABILITY fixes (most notably, > "THREAD WHACKER" timeout watcher threads were > not being properly killed themselevs previously > in some cases, which could very well account > for some "thread runaway" conditions we'd heard > about). > > 3) Doc: the JDBC Reference for each DD driver > we provide is here: > > ftp://ftp.allaire.com/outgoing/damonc/jdbcref.zip > > 4) The MySQL driver we ship was created by MM > himself...you should be able use the latest > MySQL JDBC driver via the "Other" option in the > Admin, since it's essentially from the same > guy. > > Hope that helps (more than a kick in the head > with a steel-toed boot, anyway....) > > Damon > > > ------------------------------ > Date: Fri, 13 Dec 2002 09:49:19 -0800 > From: "Joe Eugene" > Subject: RE: Java in CF (CFMX) - MM Drivers > Message-ID: > > MM-Product Team... > When Vernon Viehe(MM Community manager) > exited.. there were promises from MM..that MM > would provide better support through other MM > Folks... *****Is this a JOKE?***** Vernon did a > much better job..than whoever is in that place > now. > > This Thread Question was directed to MM..since > there is no DOCUMENTATION on details of drivers > and such.. NEVER Got an Answer.! > > CFMX Updater 2 Release Notes... > DB2-Specific Issues > An exception could be generated when connecting > to DB2 AS/400 v4R5. 15002962(ID). > > ***STILL DOING THE SAME THING with V4R5 and > V5R1*** > > Is MM(Product-Team) going to provide the > documentation details.. or do we have to wait > another year.. for a reponse...? > > BTW.. This Thread is dating back early last > Month. > > Joe > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
