none
ODBC Drivers odbcjt32.dll

    Question

  • I'm working on creating a legacy ODBC DSN to an Access 97 DB using the 32-bit c:\windows\syswow64\odbcad32.exe

    I've noticed that without loading SP1 for Windows 2008 x64, the odbc32jt.dll drivers are an older version from 2007, but once SP1 is loaded, the ODBC drivers change to a 06/2011 date.

    The problem is the 06/2011 odbcjt32.dll isn't compatible with my Access 97 DSN.  How can I revert back to the odbcjt32.dll from 2007 that was included with the default install of 2008 SRV?

    Thanks,

    --jp

    Wednesday, March 28, 2012 10:32 PM

Answers

  • Works now!  This solution didn't work on my last 2008 install, the pool would crash when making this change, but now the pool doesn't crash, the ODBC Driver uses the DSN and the DB can be accessed through an ASP script.

    Select the application pool for the web site. Select Advanced Settings.

    There under General Settings you will find "Enable 32-Bit Applications" Change this to True.

    Thanks!

    Thursday, March 29, 2012 5:59 PM
  • Update - This was actually my problem:

    http://www.mosmar.com.au/chris-blog/2011/3/15/taking-care-of-bitness-or-how-to-run-a-32-bit-app-with-owa-2.html

    Had to run the following DLL in 64bitness mode: kerbauth.dll, airfilter.dll, owaauth.dll

    Didn't really how much Exchange 2010 is integrated with IIS 7.5. 

    Thursday, March 29, 2012 11:06 PM

All replies

  • What's not compatable with it? Have you tried another or new access DB? If you could put an example up on skydrive I would do some testing with it.

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Thursday, March 29, 2012 2:31 AM
  • Hi,

    The problem is the 06/2011 odbcjt32.dll isn't compatible with my Access 97 DSN.

    Could you please let me know the error message you have received when accessing the Access 97 database after loading the SP1 for Windows server 2008 x64?

    I noticed one KB article for your reference:

    Title: Cannot open or convert an Access 97 or Access 2000 database in Access 2002, in Access 2003, or in Access 2007
    URL: http://support.microsoft.com/default.aspx?scid=kb;EN-US;310937

    I hope the information provided above is helpful to you.

    Regards,
    James


    James Xiong

    TechNet Community Support

    Thursday, March 29, 2012 9:31 AM
    Moderator
  • Maybe somebody could tell me which Windows 2008 Server update updates the file odbcjt32.dll ???
    Thursday, March 29, 2012 5:37 PM
  • Works now!  This solution didn't work on my last 2008 install, the pool would crash when making this change, but now the pool doesn't crash, the ODBC Driver uses the DSN and the DB can be accessed through an ASP script.

    Select the application pool for the web site. Select Advanced Settings.

    There under General Settings you will find "Enable 32-Bit Applications" Change this to True.

    Thanks!

    Thursday, March 29, 2012 5:59 PM
  • Update - This was actually my problem:

    http://www.mosmar.com.au/chris-blog/2011/3/15/taking-care-of-bitness-or-how-to-run-a-32-bit-app-with-owa-2.html

    Had to run the following DLL in 64bitness mode: kerbauth.dll, airfilter.dll, owaauth.dll

    Didn't really how much Exchange 2010 is integrated with IIS 7.5. 

    Thursday, March 29, 2012 11:06 PM
  • Wow, glad to know the issue got fixed. Cool!

    Regards,

    James


    James Xiong

    TechNet Community Support

    Friday, March 30, 2012 12:56 AM
    Moderator