Skip to main content
K
Ken R Caldwell
Inspiring
January 14, 2013
Answered

CF 10 64 Bit MS Access

  • January 14, 2013
  • 1 reply
  • 4920 views

Hi All,

Having trouble when I upgrade to CF 10.

We have Windows 2008 R2 64 Bit.

In CF 9 I followed the instructions on how to use MS Access in CF on 64 Bit and all worked well.

When I upgraded to CF 10 the Datasources would not work.

I then tried to recreate them and still no luck.

Can anyone help me with this problem?

At present it is not possible to upgrade the database, so I need to use MS Access.

Regards

Ken

    This topic has been closed for replies.
    Correct answer itisdesign

    Aaron,

    Just to confirm. Once I duplicated the ms access dsn's in the "cfusion" instance the ms access dsn's then worked in the "Internet" instance. All my other dsn's are SQL Server and they worked correctly.

    Ken


    Hi Ken,

    Together we've discovered 2 CF10 ODBC bugs: 3492574 and 3492580.  Turns out, the former did not affect you.  The latter is what you discovered while we were looking into the former.  I've just confirmed what you've found.  And yes, I also see that non-cfusion instances lack the 'db' directory.  Non-cfusion instances don't add the ODBC data source info into C:\ColdFusion10\cfusion\db\slserver54\cfg\swandm.ini.  The application.log and coldfusion-out.log reveal that the non-cfusion instances are looking for swandm.ini w/in the instance's directory instead of w/in the cfusion instance's directory.

    I've logged both bugs (logged the latter on your behalf to save you time).  Until the latter is fixed, I hope the workaround you found is acceptable.

    In case you are interested, here are the links to the tickets (both of which include the temporary workarounds and a link back to this thread):

    1) https://bugbase.adobe.com/index.cfm?event=bug&id=3492574

    2) https://bugbase.adobe.com/index.cfm?event=bug&id=3492580

    *Now* I hope you can start having fun w/ CF10 =D

    Hope that helps and thanks for your patience!,

    -Aaron Neff

    1 reply

    C
    carl type3
    Legend
    January 14, 2013

    http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess

    Ken, perhaps try reference for solution.

    HTH, Carl.

    K
    Ken R CaldwellAuthor
    Inspiring
    January 14, 2013

    Thanks for the reply Carl,

    But that is the instructions I followed.

    I even deleted all the existing DSN's from Windows and the Datasources from CF 10 and started again.

    But it still would not work.

    ken

    C
    carl type3
    Legend
    January 14, 2013

    I don’t use MS Access myself just recalled to blog post so thought it may help. Do other database type connections work eg CF10 Derby or MS SQL (if say you have MS SQL Express installed somewhere that CF10 can connect to)?

    Firefly Community Gallery
    Adobe Firefly

    Remix with Firefly Community Gallery

    Thousands of free creations to fall in love with and remix in Firefly.

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