ODBC connection failing

Posted on 2011-10-06
Last Modified: 2012-05-12
We are running ACT 2010; MS ACCESS 2007 on Win 7 PC's.  ACCESS has been programed using ACCESS and Visual Basic to link to data from ACT.  ACT is resident database; ACCESS is the reporting tool for Data.

ACT/ACCESS marriage worked perfectly on a Win 2003 server environment.  We recently upgraded PDC to Win 2008.  All converted perfectly but ACT/ACCESS.  Took some time to get SQL happy.  ACT is now working OK (although much slower than previously).  ACCESS is issue.  We cannot get ACCESS to stay connected to the ODBC.  Connection is inconsistent from user to user / desktop to desktop.  Error msg:  cannot connect to ODBC.  Sometimes you get error - other times you don't.  If you click OK (once or numerous time) you may evenutally connect.  Sometimes you can connect to the application ok, but when you navigate to a different section of the application, the connection fails.

IT have given up and say it is NOT server related.  The ACCESS programmer cannot find anyting correct or wrong with the coding.

All are frustrated and at a loss.  Help
Question by:max-a-million
    LVL 51

    Expert Comment

    Try recreating the ODBC connection using the 32-bit tool found here:  C:\Windows\SysWOW64\odbcad32.exe

    I suspect it's a 64-bit to 32-bit app issue.


    Author Comment

    Thank you for responding.  I'll try this this morning and get back to you. This issue has some very GOOD IT pros totally stumped.
    LVL 30

    Expert Comment

    by:Mike Lazarus
    If that didn't help:
    1. What full version of server OS - SP1, R2, x32 or x64?
    2. What version of SQL - 2005Ex (as shipped) or x64 or 2008?
    3. What ver/build of ACT! (from Help About)? If not 12.1, apply SP1. If 12.1, but not hotfix 5, apply hotfix5... note ALL systems sharing database (LAN or Sync) must be on same build

    Also, is that the full error?
    Any error in event log (client or server)?

    Any reason you're using ODBC? OLEDB is usually easier
    LVL 30

    Expert Comment

    by:Mike Lazarus

    Accepted Solution

    Thank you for your comments.  As it turns out, the problem was identified and resolved as follows.
    IT had already considered the 32/64 bit conflict.  Appreciate your response.

                    This problem occurs because the TCP Chimney Offload feature is enabled on the server. The TCP Chimney Offload feature is enabled by the Windows Server 2003 Scalable Networking Pack.
    Typically, this problem occurs when the network adapter uses the Broadcom 5708 chipset. For example, the following network adapters use the Broadcom 5708 chipset:
    •      Broadcom NetXtreme II
    •      Hewlett-Packard NC373i Multifunction Gigabit Server Adapter

    Author Closing Comment

    I was the one who solved the issue.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
    When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
    Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
    Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now