| QODBC issue on Windows 2003 |
| Author |
Message |
|
|
| Posted : 2007-12-11 07:41:58 |
For the last 3 months I am working on a ASP.NET application to integrate with Quick Books. We have 3 licenses. One for my Development box (Windows XP), one for Test Server (Windows 2003 Server) and one for the Production Server (Windows 2003 Server).
The application is working perfectly on the XP box. It create Quick Books Invoices with multiple Invoice lines for diffrenet Customers. It updates the Customer Information in Quick Books from ASp.NET. Also using Coldfusion MX7, multiple web Services are created for Billing pupose and all working fine.
When I moved the files to Test Server (Windows 2003 Server), I was able to create the DSN and it is tested Successfully. None of the Quick Boks related pages working. It is not showing any errors. But never end the delay. It goes for hours and never shows any error or results. I read the FAQ and help topics and reinstalled both Quick Books and QODBC on the C root folder. No changes. I tried the QBCUST.asp on this machine. Nothing happeneed. Checked the "Enhanced Security Configuration for Internet Explorer". Also Addded the QBCustoerServiceData17 usergroup into PowerUser group on the server. Also played with qbXMLRP2eQODBCInteractive.exe. But no changes or results
The company is so much disappoined by this and they planned to use the new billing system by Jan 2008.
Please help me to fixx this. Please send me your suggestions. Please...
Thanks,
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-12-11 07:49:57 |
|
|
|
|
|
| Posted : 2007-12-11 13:39:30 |
| ADDED 'AUTHENTICATED USERS' AND 'INTERACTIVE' WITH FULL CONTROL TO EVERY FOLDER THAT CONTAINED ANY FILES WITH NAMES CONTAINING THE STRING 'QODBC' OR 'FLEX'. Restarted the Server. No good news. Same as before. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-12-11 15:39:10 |
|
|
|
|
|
| Posted : 2007-12-12 00:38:09 |
qbCust.asp is running fine on XP box. The same file on 2003 servershows as it working. It goes for ever. Never opens the connection on 2003 server. Please help..
Thanks a lot. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-12-12 07:32:34 |
| Sorry, qbcust.asp must show something? What's the error message? What errors are in the Windows Event Viewer? |
|
|
|
|
|
| Posted : 2007-12-13 04:35:39 |
This is the error in the event viewer
The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{6557F176-2761-4EC5-A0D1-24AB537279E7}
to the user NEWDEVSERVER\IUSR_NEWDEVSERVER SID (S-1-5-21-4153400692-548991583-2809804446-1090). This security permission can be modified using the Component Services administrative tool.
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-12-13 07:45:33 |
This problem occurs when the version of the Asp.dll file does not match the version of other Microsoft Internet Information Services (IIS) files. The Asp.dll file has a version number of 6.0.3790.1830, the Microsoft Windows Server 2003 Service Pack 1 (SP1) version number, instead of version number of 6.0.3790.0, the Microsoft Windows Server 2003 version number.
This problem may occur if one of the following conditions is true:
- You install IIS on the server after you install Windows Server 2003 SP1.
- You install Windows Server 2003 SP1 on the server, and then you remove it.
Note Other file versions may also not match.
RESOLUTION
To resolve this issue, you must reapply Windows Server 2003 SP1. |
|
|
|
