Suddenly QODBC with Remote Connector is asking for password |
Author |
Message |
|
Posted : 2007-03-29 01:41:58 |
Absolutely nothing has changed. The remote connector is set up just like in your documentation on the Security tab with the Require Authentication checkbox checked and the username and password entered there. On the QODBC setup the box is checked to Connect to /n Software's IBiz Integrator for QB...; the username (but not the password) is entered there - the password has never been stored here. and the checkbox for Ask for password for if invalid is checked. When QODBC runs and is attempting to connecting it is suddenly now, out of the blue, popping up the little user name and password box - as soon as I enter the password - the same one it's always been and the same one that's on the remote connector - it goes ahead and connects. Ideas, suggestions? Why would this just start suddenly? And I really am not leaving this out when I say NOTHING has changed. no upgrades, no installs, no nothing. Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-29 08:16:30 |
Simply add your password to your QODBC setup screen Remote Connector tab. Also check the connection string used by your application.
|
|
|
|
|
Posted : 2007-03-30 00:30:42 |
Ok, last night I added the password to the QODBC setup screen with the same results. I checked the connection string this morning and nothing has changed - it is still correct. It is pointing to the correct data - we don't specify a user name/password in the connection string - i mean it hasn't changed since this application has been created. I don't know what else to look for. What else could cause this problem? Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-30 09:05:10 |
Use VB Demo to run through the DSN used by your application. Make sure VB Demo can use the connection first, then look at your connection string. BTW: The password is the password for the company file, not something made up between the QODBC Remote Connector and the iBiz Remote Connector. |
|
|
|
|
Posted : 2007-03-31 00:37:10 |
VB Demo worked - and I have already looked at the connection string. I added those notes yesterday - it uses the same connection as the VB Demo. And I know the password in the QODBC setup screen for the Remote Connector is for the company file - that's what I put in there. So, what else in the history of this product has caused the IBiz integrator to not cooperate and connect without someone manually entering the password - and then it connects just fine - when everything is set up correctly?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-31 07:53:24 |
Well, if the account is already in use in QuickBooks, then the remote login will fail. If you are calling the remote connector frequently, you may 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).
This is a complete example using the QODBC Remote Connector in the connection string:
DRIVER={QODBC Driver for QuickBooks};OptimizerDBFolder=C:\Program Files\QODBC Driver for QuickBooks\Optimizer;IBizRemotePWD=123456;IBizRemoteConnect=Yes;IBizRemoteURL=http://192.168.1.10:2080; IBizRemoteConnTimeOut=120;IBizRemotePromptForPWD=No;IBizRemoteForce2002_2003=Yes; OpenMode=M;DFQ=C:\QBOOKS\DW.QBW;OLE DB Service=-2 |
|
|
|