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 : ASP test page failingSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v6 Forum

 New Topic 
 
 Post Reply 
[1]  
 ASP test page failing 
 Author   Message 
  Mark 
  
 Group: Members 
 Posts: 8 
 Joined: 2007-01-04 
 Profile
 Posted : 2007-01-04 10:56:28
I want a PHP app to talk to quickbooks on a different server.

I have seen the page: http://www.qodbc.com.au/QODBCwebserver.asp?Region=OZ

and I thought I followed each step very well.

But when I run the "QuickBooks Customer List" ASP test page I get this output:

QODBC Customer List Demo Page
Preparing to Create Connection Object
ADO Connection Created
ADO Recordset Created

Provider error '80004005'

Unspecified error

/qbphp/test.asp, line 30

 

Please help, this is a urgent fixed required! It seems that the ASP code cannot open the DSN connection: "QuickBooks Data" which DOES exists.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-01-04 20:14:11

QODBC needs to talk to QuickBooks on the server with the web page. This is done by setting up the QODBC DCOMs or the Remote Connector. But last, but not least, unattended mode (auto-login mode) must work.

See: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? 

 

  Top 
  Mark 
  
 Group: Members 
 Posts: 8 
 Joined: 2007-01-04 
 Profile
 Posted : 2007-01-08 09:18:48
Thanks for the reply, I see, but I was wrong in my original post, the QB and the QBODBC are on the same PC. Do I still need to set up DCOM or the Remote Connector? 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-01-08 10:25:05
Yes, anything that runs through a Windows Service requires the QODBC DCOMs or the Remote Connector to be configured. QODBC on it's own can be called by desktop applications, but not services. 

  Top 
  Mark 
  
 Group: Members 
 Posts: 8 
 Joined: 2007-01-04 
 Profile
 Posted : 2007-01-08 10:54:23
Ok thanks for that. Now I think I have a working setup environment, but now I need to use PHP to connect to QB.

Do I use the odbc_connect method to connect to QB? Can you point me to some samples please? 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-01-08 14:52:13
Try looking at our sample: DisplaySQL.PHP  

  Top 
  Mark 
  
 Group: Members 
 Posts: 8 
 Joined: 2007-01-04 
 Profile
 Posted : 2007-01-08 14:54:37
thanks for that, it gets me on my way 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to