Skip to main content
I
impalerware
Participating Frequently
April 23, 2010
Question

CF 8 ODBC service needed after 9 upgrade

  • April 23, 2010
  • 2 replies
  • 1152 views

We recently upgraded from CF8 to CF9 and for some reason CF9 will not work unless the CF8 ODBC service is running. If we stop the CF8 ODBC service none of our pages load. Anyone experience this before?

    This topic has been closed for replies.

    2 replies

    A
    Adam Cameron.
    Inspiring
    April 24, 2010

    We recently upgraded from CF8 to CF9

    It just occurs to me... when you say "upgrade", did you do an inline upgrade?  As opposed to installing CF9 in parallel to CF8, and then migrating the applications?

    My next suggestion would be to revert to your CF8 environment, and de-install / re-install CF9, but that's perhaps not so viable if you did an inline upgrade.

    --

    Adam

    I
    impalerwareAuthor
    Participating Frequently
    April 26, 2010

    The install was on the same server. So the installer made a new coldfusion 9 directory then migrated all the datasources for us.

    Everything seems to be working fine with the 8 ODBC service running but just seems weird that that it the case. I'm going to try re creating all the odbc datasources hopefully this week.

    A
    Adam Cameron.
    Inspiring
    April 23, 2010

    Do you use any ODBC datasources?

    When you say "none of our pages load", what exactly happens instead of the page loading correctly?  Does the browser just spin?  Do you get an error?

    Can you access the CF Administrator?

    Have you looked at the CF and JRun logs to see if there are any errors during start-up?

    --

    Adam

    I
    impalerwareAuthor
    Participating Frequently
    April 23, 2010

    We have a couple ODBC datasources that were migrated over as part of the upgrade process yes.

    When we try to go to a page the browser just spins and sits there on a blank page. The CF administrator does load though but eventually starts hanging.

    Where exactly are the JRun logs? I browsed the application and server logs via the CF administrator and didn't see anything out of the ordinary. Although the entries for when the server starts up don't contain anything about ODBC...

    A
    Adam Cameron.
    Inspiring
    April 23, 2010

    The JRun logs are in eithe [JRun install path]/logs for a multi-server install, or - I think - [CF dir]/WEB-INF/runtime/logs (or something like that) for a stand-alone install.  Search for *.log & you'll find 'em.

    If you were to steer clear of the Datasource screen in CFAdmin, does it still "start to hang" (does it "hang", or does it just "start to hang"? ;-)

    What sort of DBs are your ODBC datasources for?  Any reason you're using ODBC at all?

    --
    Adam

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices