You need to set a Reconnect Delay to 5 seconds (in the QODBC Setup Advanced tab). This will make QODBC wait after it disconnects before it trys to connect again allowing QuickBooks time to unload properly before the calling application returns to reopen the connection to the next company file (or the same company file).

Hi, thank you for your answer but it's still not working. I also set up the delay in 20 but still doesn't work.

The message I'm getting is: QB Session Failed. Error Calling OpenQBConnection Returned Error: 151 - Server Error: External exception E06D7363

well, I have created like 20 DSN, one for each Quickbooks company. I set the company file path for each company (i.e.: F:\DATA\QUICKBOOKS\3FTMED\3 Feet Media, LLC.QBW  this is for one of the companies). In the Remote conector tab I chose: Connect to / n Software's Biz Integrator for Quickbooks Remote conector. I set up the Remote Conector URL, the user name and password. In the Advance Tab I set the reconect Delay to 20. The in the /n software IBiz Integrator for Quickbooks - Remote Conector Software, in the Connection Tab, I set the same port used for setting the DSN. The in the Security Tab I check the box Require Authentication and I used the same user name and password than the one I used for the DSN. Then I start the service. After I open a quickbooks company (one by one) and click test Connection to Quickbooks button in my DSN. It asked me for giving the access to the appliaction so I did. When it was done I close quickbooks and my DSN.

After that I opened my ODBC and Tested one of my companies. I chose one DSN and clicked the button Test Conection to Quickbooks. The first time it works fine. I got a message telling me "Test Connection to Quickbooks Successful". I closed that message and I wait a few seconds. Then I tried to test the conection again (using the same company DSN) and this time I got an error message that said: "QB Session Failed. Error Calling OpenQBConnection Returned Error: 151 - Server Error: External exception E06D7363". I closed that message and I tried one more time and now I got the successful message. After that if I try again I got the error message and so on.

I also tested my DSN using the VB application and I got the same situation. The first time it's fine, second time I got the error, third time is fine and go on.

So, this is basically what is happening. I'm not trying to open more than 1 company at the time. I hope this could be helpful for you in order to guess what 's going on.

Thank you for you help.

Forgive me but you haven't explained why are you using the Remote Connector in the first place? Most QuickBooks Enterprise users simply connect directly to QuickBooks on their workstation?

Using VB Demo, what happens when you connect, then disconnect, then try to reconnect five minutes later?

Hello,

Well, I'm using Remote Desktop because at the beggining we were using QUickbooks Pro 2005 and then we migrated to the Enterprise Edition last January. I kept using the Remote Desktop because it was working fine.

Let me explain you how I'm using the Remote Desktop. I'vre created a vb.net application that connect to quickbooks and retrieve some data, from one quickbooks table, that I need in order to do some work. I have to call all the companies but I do it one by one, since I know quickbooks can open only 1 company at the time. Everything was working fine until the beggining of this month.

I've been trying to delete the connection and create it again for only 3 companies. I modified my vb.net application for working only with those 3 companies. After running the application, 2 of the 3 companies worked fine but I got an error message when the application tried to open the third company: QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks.

Does this mean that I need to install or upgrade something else in order to make it work?

Hi Tom,

I understand what you mean but we only have USA versions. One it's quickbooks 2005 and the other Quickbooks Enterprise Solutions 7.0. The weird thing is that it connects fine sometimes but fails others. It's randomly.

Please help me. I need to solve this problem as soon as possible.

Hi Tom,

Yes all the companies have been comverted to the new format (Enterprise 7.0). Also just for testting I'm working only with 3 companies. If I try with the vb sample (that comes with the QODBC) I get the error you mentioned but ramdonly, sometimes the connection works but others fails.