|
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
|
|
| Problems logging into remote connection |
| Author |
Message |
|
|
| Posted : 2007-01-11 08:44:29 |
Follow the instructions in the relevant FAQI got a remote server running, with the following authentication config:
I made a client DSN as follows:
The passwords on the two screens shown above DO match and the IP address for the remote IS correct.
When I try to make a Microsoft Query on the client, using the remote DSN, it keeps throwing up a login screen. Even after I put in the password, it returns me to the login screen twice then ditches me out of Query. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-01-11 10:47:07 |
| The Username and password is for the QuickBooks login (normally admin), not for the iBiz Remote Connector. Are you sure Distr Mgmt is a QuickBooks login account that have been authorized to use QODBC? |
|
|
|
|
|
| Posted : 2007-02-02 10:38:32 |
Distr Mgmt IS a QB user. I believe that it is fully-capable of use in a remote connection query because, before I even tried to make the remote connector, I used that profile succesfully in a query run directly on the host, as follows:
- I made a DSN on the host and created a query which used it
- I have only one integrated application named Flexquarters ODBC (though I do have other integrated apps, including ExpensAble).
- I can run the local query any time, successfully
Distr Mgmt has limited privileges- I do NOT want to run my query under admin, because admin has access to salary data. But I remember that when first made the LOCAL query a QB FAQ said to set it up on admin INITIALLY, and convert it to unattended access later. So I had the admin logged in when the query first ran, until it was set up in Integrated Applications, then changed it in IA to run unattended (under Distr Mgmt). So I tried changing alll of the REMOTE connection users and passwords shown in my post to admin. But, even though I was logged into QB as admin, I got the same result as described in my post- three successive attempts to login as admin, then connection failure.
VB demo run on the REMOTE experiences the same problem, but told be something that the "test Connection" button the ODBC setup (unfortunately) did not- an error code (151).
A search on that error turned up a year-old post with the same issue (Error Calling OpenQBConnection Returned Error 151) issue. Following the advice given there, I double-checked that when VB Demo is run on the HOST (with no iBiz Remote Connector started) , it works fine (even when QB isn't open).
So I started the Remote Connector, without authentication (as suggested in the other post), and turned my attention to the REMOTE again. I ran VB Demo using the DSN which points to the remote server and had no user/pwd listed. I got three login attempts (I used admin) and failed.
I then stopped the remote service, set it for authentication (admin) and started it again. Back on the remote, I tested the connection again with and without QB running- again three strikes and out. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-02-02 11:59:49 |
You also have to let QuickBooks know which QuickBooks user account you want to allow the use of QODBC.
|
|
|
|
|
|
| Posted : 2007-02-03 01:44:25 |
Per your advice on the other post, I have already used VB Demo (not SQL Server) to establish a connection to the company file directly with QODBC first (without the remote connector). It worked (using Distr Mgmt), because the unattended login account HAD already been set for that user.
That said, my most recent attempts had temporarily set aside the idea of using the Distr Mgmt user in favor of admin, but I used that user in the Host remote connector and on the remote while failing to change IA to use admin as the unattended login. So I just changed IA to use the admin profile too. Still- three login attempts and I was out.
I am to the point where I need someone on the phone, walking through the steps with me. I run a software company, so I know you need to charge for DATA ACCESS issues, but I can't even get a remote cconnection working Our intended use for QODBC is to identify invoice items for our various software apps, and initiate a key-generation and order fulfillment process. So I figured I'd need to BUY this trial version eventually, in order to have the WRITE capabilities. But I don't want to buy without successfully establishing a remote connection for use on machines not having QB! |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-02-03 10:41:54 |
The easiest method is on the host (where QuickBooks is running) is to get a connection working using QODBC and then switch on the Remote Connector in QODBC, run the iBiz Connection (so it's running in the System Tray) and connect using VB Demo.
Once that's working on the host, copy the QODBC and host company path to the remote computers. See: I do not want to install QuickBooks on every machine. How do I setup QODBC Remote? |
|
|
|
|
|
| Posted : 2007-02-06 10:00:18 |
I followed your directions, with no success. See my steps below.
This is getting ridiculous- please contact me for a phone number you can call to get this thing working. I'll even let you watch what I'm doing thru VNC.
STEP 1- GET THE CONNECTION WORKING DIRECTLY ON THE HOST
On the host, I opened QB and deleted the flexquarters entry in Integrated Applications (just to force it to be re-created)
Leaving QB open, I opened VB Demo and connected to QB successfully, after setting the admin user up for unattended acccess
Then I connected successfully with VB Demo. No password was requested.
I then closed QB and ran VB Demo again. It connected fine in unattended mode.
I started the remote connector in IBiz, with authentication required
I connected successfully using VB Demo (no password was required)
---success---
STEP 2- TRY TO GET REMOTE CONNECTION WORKING ON THE REMOTE, WITH AUTHENTICATION REQUIRED
-- I'm not sure what you mean by "copy the QODBC and host company path to the remote computers", but I configured the connection on the remote as per your FAQ, using http://IPAddressOfHostFromIPConfigCommand:2080. On the Remote Connector tab, I had the admin user, but no password
VB Demo was then UNABLE to connect, after three login attempts (error 151 server error 602)
---failure---
STEP 3- TRY TO GET REMOTE CONNECTION WORKING ON THE REMOTE, WITH AUTHENTICATION NOT REQUIRED
I then unchecked the "Require Authentication" box in the iBiz Security tab on the host
I then tried VB Demo on the remote, unsuccessfully
On the remote, I removed the user from the Remote Connector tab
VB Demo was STILL unable to connect after three attempts (manually filingl in the admin user and password)
---failure--- |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-02-06 10:19:33 |
The company path on the REMOTE needs to be the same as on the HOST. You must tell the REMOTE connection what company file you are wanting to connect to on the HOST computer running QuickBooks.
Please "Review QODBC Messages" for the actual error or problem QODBC is having with your setup.
|
|
|
|
|