Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Remote connector problemSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Frequently Asked Questions

 New Topic 
 
 Post Reply 
[1]  
 Remote connector problem 
 Author   Message 
  Acsys 
  
 Group: Members 
 Posts: 14 
 Joined: 2006-06-28 
 Profile
 Posted : 2006-08-18 22:26:13

I am having a problem with the remote connector. I have a machine running the remote connector and a quickbooks instance from off of a server. I have another server with our intranet on it and some code that uses a dsn connection to connect to the remote connector. Sometimes the dbConn.Open works and sometimes it just hangs on that line. i know it is on that line because i have put a repsonse.write and response.flush before and after it. Since it does work sometimes, i'm beginning to wonder if it's the order in which i boot up the remote connector and the QuickBooks file. Do they need some kind of time delay or is there something involved in the whole start up process that i'm missing? I can't leave the Quickbooks file always open because sometimes it needs to be in single user mode on someone else's computer.

Please advise. Thanks in advance.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-08-19 11:19:35

Normally you just authorize the IBiz Remote Connector to login to QuickBooks automatically. To do this you must start QuickBooks as the Administrator. Go to the "Edit-Preferences" menu item in QuickBooks. Then select the "Integrated Applications" icon from the left side.

Then highlight one application (usually FLEXquarters QODBC but in this case it will be the IBiz Connector or something similar as I'm going off my memory here) and press the "Properties" button and click on the Company tab. Check the "Allow this application to access this company file".

And check the "Allow this application to login automatically" and select a user from the "Login As" drop down. You will need to repeat this for all the applications on the list that you use.

You should also check the "Show Reminders List when opening a Company file" preference is unchecked.

You also need to configure the Reconnect Timeout setting in the QODBC Setup Advanced tab.

  • Reconnect Delay: Is an amount of time to wait after a disconnect when using the remote connector. This allows QuickBooks to fully unload it if it is being loaded in the background on the Host Remote Connector, before you connect again.

 However a lot of these settings can be controlled in your QODBC connection string, for example:

strConnect = "ODBC;DSN=QuickBooks Data;DFQ=C:\QUICKBOOKS\baselineNov17th.QBW;" & _
    "OpenMode=M;SERVER=QODBC;IBizRemoteConnect=Yes;" & _
    "IBizRemoteURL=http://localhost:2080;IBizRemotePWD=reporting;" & _
    "IBizRemoteConnTimeOut=1000;"

See: How do I build a connection string with all the available QODBC parameters? for more.

 

  Top 
  Acsys 
  
 Group: Members 
 Posts: 14 
 Joined: 2006-06-28 
 Profile
 Posted : 2006-08-22 02:00:42

ok, so I made sure all my settings were the same as you described below.  Remember, this was working just the other week, and now I can't seem to get it to work at all and I haven't changed any settings and the secretary says she hasn't changed anything either.  I tried to log directrly from the dsn to the quickbooks file open locally to see if the first time use prompt would come up, but it didn't.  I then clicked the test connection button and it said it connected successfully.  This allows me to believe the dsn is fine and it just has to do with something with the remote connector.  I then logged into our client machine and the remote connector starts up on log in (we added it to the windows startup).  I didn't see quickbooks open up, so i opened it in multi-user mode.  I then went to my computer and ran the asp code to open a connection to the remote connector and it just hung for about a half hour until i closed the browser.  My connection string is this:


  Set dbQuickBooks = Server.CreateObject("ADODB.Connection")
  dbQuickBooks.Open "DSN=QuickBooks Time;DFQ=Z:\Acsys\AccountingData\Acsys 2006.QBW;OpenMode=M;SERVER=QODBC;IBizRemoteConnect=Yes;
  IBizRemoteURL=http://client.office.com:2080;IBizRemotePWD=password;IBizRemoteConnTimeOut=200;"

Any help or direction would be appreciated.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-08-22 08:47:09

I suggest you test re-connecting through the IBiz Remote Connector using QODBC locally on the computer with QuickBooks first and them move on to the remote computer. The IBiz Remote Connector is used on the computer running QuickBooks, not the remote computer. The remote computer uses QODBC itself with a DSN or connection with IBizRemoteConnect=Yes.

In the IBiz Integrator Setup make sure the "Start Server on Application Start" is checked and the IBiz connector is in the system tray on the computer running QuickBooks.

 

  Top 
  Acsys 
  
 Group: Members 
 Posts: 14 
 Joined: 2006-06-28 
 Profile
 Posted : 2006-08-22 23:13:40

Well, unfortunately I have tried all of your suggestions already.  My setup is on the secretary's computer, I have an instance of QuickBooks running and the remote connector on with the status of connected as stated in the logging tab.  I have already checked the "Start Server On Application Start" so when my computer boots up, it automatically starts the iBiz Integrator and that starts whatever it is that it does.  I don't think it makes a difference if I run the browser on my machine or locally on the secretary's machine which has the asp code to connect to the remote connector, but I tried it anyways and it still just hangs.  I know I have the setup all correct because I have got this to work dozens of times.  The problem I use to face was that it never worked the first time I tried it, so I would shut down my browser and clear my temporary files, maybe even edit the code by putting a response.write and a response.end and then try it to make sure I had a non-cached page.  Usually, the second time around it would work fine.  This led me to believe that maybe I had the order messed up or something.  But now when I try it, no matter what, I can't get the connection to even open.

Any other ideas?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-08-23 09:02:55
Use VB Demo to connect locally on the secretary's computer through the IBiz Remote Connector and then on the remote computer. Check the message logs in the QODBC setup screen for the actually error message detail. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to