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 : QODBC, WCF Service with Windows Service.Search Forum

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

 New Topic 
 
 Post Reply 
[1]  
 QODBC, WCF Service with Windows Service. 
 Author   Message 
  Ushima 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-09-27 
 Profile
 Posted : 2007-09-27 08:21:32

I'm developing a test application with a WCF service that uses the QODBC to connect to QuickBooks Enterprise Solutions - Professional Services Edition 7.0, the WCF service should be hosted by a Windows Service, but when I run the client, the Windows Service doesn't communicate with the WCF Service, it just communicates with the client.

I tried hosting the WCF Service in a console application and it works perfectly, the client communicates with the host and the host with the WCF Service and finally this last connect to QuickBooks. Even the configuration file of the console host is the same than the Windows Service.

I wish to know if someone can help me to find  the problem.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-27 09:04:35
The use of Windows Services requires the QODBC Server Edition and the QODBC DCOMs to be configured. 

  Top 
  Ushima 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-09-27 
 Profile
 Posted : 2007-09-28 03:52:32

I'm using the Evaluation QODBC Server Edition Version 8.00.00.234. I think it could be better from me to be more specific.

The application works like this:

The Client is used to add Customers to QuickBooks, the WCF Service is hosted by a Windows Service where the WCF Service connects to QuickBooks using the QODBC and then add the Customer. I checked the communication between the Windows Service and the WCF Service and it works but the WCF Service doesn't connect to QuickBooks. If I change the host of the WCF Service with a Console Application, the WCF Service connects to QuickBooks successfully and adds the requiered Costumer.

I tried using the DCOM or the Remote Connector but they didn't work.

I thank you for your response, I'll hope that you can help me again.

 

 

 

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

I guess you are missing the fact that you still need to configure the QODBC DCOMs.

See:   How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server? 
          QODBC and Windows Service 

 

  Top 
  Ushima 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-09-27 
 Profile
 Posted : 2007-09-29 04:49:37

I configured the DCOMs like the post: How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server? says, but it doesn't work either, the QODBC doesn't connecto to QuickBooks using a WCF Service a Windows Service.

I'll keep triyng and thanks a lot for your time and help.

 

  Top 
  Ushima 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-09-27 
 Profile
 Posted : 2007-09-29 08:15:02

Hi, it's me again. I found in the Web Site of QODBC from Australia, that I must grant read and write access to the ASPNET, INTERACTIVE and IUSR_MACHINENAME Accounts in the C:\Program Files\QODBC Driver for QuickBooks directory and I did it, now I'm getting a Exception that says: ERROR [00000][QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. In the messages from Review QODBC Messages comfirms that my application is a Service. I'm not sure if what I said before is the real problem, but when I run the application before I grant the access, it just not connect to QuickBooks. How can I solve this problem.

Before hand, I thank you for your help.

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-30 08:57:16
I am the guy from Australia, please review How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? to get an overview on how things need to be setup. 

  Top 
  Ushima 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-09-27 
 Profile
 Posted : 2007-10-01 23:22:10

Hi Tom, it's me again, I have to tell you that all the configuration of the DCOMs are correctly, the application is setup in Auto Login all that says in the How can I see QuickBooks data in a Internet Explorer Browser using Windows XP?, even the examples like testDCOM.asp and qbcust.asp works, the only thing is the Error: ActiveX component can't create object. on the testDCOM.asp. Anyway I get the same Exception on my application, it can't begin a session in QuickBooks.

I have to thank you for your Just in Time answers.

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-03 06:39:37
If qbcust.asp is working, check your connection string in your application. See: How do I build a connection string with all the available QODBC parameters? for more on this. 

  Top 
  Ushima 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-09-27 
 Profile
 Posted : 2007-10-05 02:19:21

Tom, thanks for your help.

Finally I could solve the problem. Now all is working fine.

Again, thank you so much.

 

 

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to