QODBC, WCF Service with Windows Service. |
Author |
Message |
|
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. |
|
|
|
Tom |
|
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. |
|
|
|
|
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.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-09-28 08:02:53 |
|
|
|
|
Posted : 2007-09-29 04:49:37 |
|
|
|
|
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.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-09-30 08:57:16 |
|
|
|
|
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.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-03 06:39:37 |
|
|
|
|
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.
|
|
|
|