Hi all,
I am continuing my evaluation for using QODBC from our web servers. I have set up QODBC to connect to our QuickBooks Enterprise server using Remote Connector. From the PC server running IIS, I have successfully used the VB Demo application to confirm that the connection is working.
However my attempts to open a QODBC connection from a web page have failed. The symptom is that there is no response from the server when trying to call an ASP page or an ASP.NET page. I have run Microsoft's Debug Diagnostics and it is complaining about a server-side application trying to display a message box. I *have* confirmed that the settings for the Optimizer and Driver status panels are unchecked.
I have two test scripts trying to access the QODBC connection. One is an ASP page using VBScript and ADODB. The other is a Crystal Reports web application created using VS2005. Note that I have verified the Crystal deployment by swapping out the QODBC report file for one that uses an Access database to verify that Crystal is operating correctly.
Below is some additional information from Debug Diagnostics including a call-trace for the thread trying to open a message box. (Note the references to fqqb32 and that it does not show the text for the message box.)
Any assistance in resolving this issue is greatly appreciated!
_Mike
| Entry point |
msvcr80!_threadstartex |
| Create time |
6/4/2007 10:20:43 AM |
| Time spent in user mode |
0 Days 00:00:00.078 |
| Time spent in kernel mode |
0 Days 00:00:00.468 |
This thread is displaying a message box. The call to display the message box originated from user32!NtUserWaitMessage+c.
The text of the message being displayed is:
| Function | Source |
| ntdll!KiFastSystemCallRet |
|
| user32!NtUserWaitMessage+c |
|
| user32!InternalDialogBox+d0 |
|
| user32!SoftModalMessageBox+94b |
|
| user32!MessageBoxWorker+2ba |
|
| user32!MessageBoxTimeoutW+7a |
|
| user32!MessageBoxTimeoutA+9c |
|
| user32!MessageBoxExA+1b |
|
| user32!MessageBoxA+45 |
|
| fqqb32!SQLGetFunctions+94ed |
|
| fqqb32!FQKillEditQDSN+1d32 |
|
| fqqb32!QBCodeCheck+4810 |
|
| fqqb32!FQKillEditQDSN+91de |
|
| ntdll!ZwSetInformationProcess+c |
|
| kernel32!SetErrorMode+37 |
|
| kernel32!lstrcpynA+62 |
|
| 
