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 : Error Calling OpenQBConnection Returned Error 151Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Installation Support Forum

 New Topic 
 
 Post Reply 
[1]  
 Error Calling OpenQBConnection Returned Error 151 
 Author   Message 
  Fledd 
  
 Group: Members 
 Posts: 9 
 Joined: 2007-01-21 
 Profile
 Posted : 2007-01-21 13:05:29

Just upgraded from the demo version to the read only version and I found out I have to use the IBiz connection rather than the DCOM with SQL Server.

Anyway, trying to test the connection I get the connection error 151 after I put the same user name and password  in three times.

What am I doing wrong.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-01-21 21:49:27

The Username and password has to be a QuickBooks username and password for the company file you are using. Suggest you use VB Demo to test the connection using Admin as the username. See: I do not want to install QuickBooks on every machine. How do I setup QODBC Remote? for more on using the iBiz Remote Connector.

You will also need to setup unattended mode access as per: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? 

 

  Top 
  Fledd 
  
 Group: Members 
 Posts: 9 
 Joined: 2007-01-21 
 Profile
 Posted : 2007-01-23 14:44:43
Yes, the user name and password are the same as QB, but I still am getting the same error. I look in the trace files and it is showing that authorization is required. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-01-23 20:31:09
Use VB Demo (not SQL Server) to establish a connection to the company file directly with QODBC first (without the remote connector). QuickBooks must be running and the company file open. You then setup unattended mode and then the remote connector if you can connect to the company file without QuickBooks running. It may be easier to uncheck the "Require Authentication" box in the iBiz Security folder. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to