Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1313
  • Last Modified:

Connection problems to Quickbooks via SDK in VBA

I am trying to connect to Quickbooks from an Access database using the Quickbooks SDK. I have my code sample below. The problem is that even though I have the open connection set up to be multiuser mode, somehow that property gets lost. Also, sometimes the computer that runs the commands becomes the host computer instead of the server remaining the host.

This problem does not happen every day. It does not seem to matter if the person using the SDK code is the only one in the system when the status changes. Sometimes it seems like something happens during the night (like during a backup or something).  We have gone a couple weeks where everyone logs in just fine in multiuser mode, the one day the problem comes back for a few days, then goes away again.

We recover from this by having everyone log out of quickbooks, then have the server manager search for the quickbooks database. Once we "find" the database again, it seems to reset the settings.
Is there something wrong in my code or in the server settings that would be causing this?

        SessionManager.OpenConnection2 "", appName, ctLocalQBD
        DTCompanyFile = DLookup("Default_Company", "Configuration_Table")
        SessionManager.BeginSession DTCompanyFile, omMultiUser

Open in new window

0
jadixon
Asked:
jadixon
  • 3
  • 2
1 Solution
 
jadixonAuthor Commented:

        SessionManager.OpenConnection2 "", appName, ctLocalQBD
        DTCompanyFile = DLookup("Default_Company", "Configuration_Table")
        SessionManager.BeginSession DTCompanyFile, omMultiUser

Open in new window

0
 
Jeffrey CoachmanCommented:
Have you tried just contacting Quickbooks?
0
 
jadixonAuthor Commented:
After doing a bit of research it seemed to be a networking-type issue. So I went into the users etc\hosts file and added an entry for the server where the quickbooks resides. Since I have done that there does not seem to be an issue anymore. It has been several weeks since we had the lockout error. I am keeping my fingers crossed that this is really the cure!
0
 
Jeffrey CoachmanCommented:
OK

Keep me posted.

;-)

Jeff
0
 
jadixonAuthor Commented:
The ETC Hosts fix so far has worked. I will now close this out (until the problem happens again).
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now