PHP not connecting or loading |
Author |
Message |
|
Posted : 2008-01-19 12:00:52 |
When I try to run DisplaySQL.php the browser just loads and never stops loading... and never times out. There is no error thrown or anything, it just doesn't load.
This isn't just for DisplaySQL but for another php script I wrote.
The VB Demo 32 can connect fine and I can run queries through that.
I should mention that I renamed the DSN to QODBC. I also changed the connection line in DisplaySQL and my script to reflect this change.
I also configured the DCOM components as described.
Running, Windows server 2003 with Quickbooks Enterprise 2007
Thanks in advance |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-19 14:02:33 |
What type of security have you setup on the server? There can be all sort of permissions issues with IIS using AUTHENTICATED USERS. Sometimes the *shotgun* approach of giving everything that has the words QODBC in it is the only way....
See the last post in: Permissions Issue with IIS using AUTHENTICATED USERS |
|
|
|
|
Posted : 2008-01-22 10:14:31 |
I took the shotgun approach and gave full permissions to all folders that had QODBC in them, also gave full permission to the DCOM components.
It's still doing the same thing.
What's odd is that when the DisplaySQL.php script is run the server's system speaker beeps, however there are no error popup's or event viewer entries that indicate any problem.
Other php systems I have in place still work fine, I'm guessing the beep comes from trying to access QB with the driver.
I've tried having QB both open and closed while trying to access it and still nothing. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-22 10:47:25 |
When using Windows 2003 Server you also need to check your "Enhanced Security Configuration for Internet Explorer" settings.
The Enhanced Security Configuration for Internet Explorer typically sets the IE security settings to "high", so QuickBooks throws a warning BEEP every time it starts, even for the SYSTEM service, which hangs QODBC while waiting for input. |
|
|
|
|
Posted : 2008-01-22 10:55:00 |
the Enhanced Security Configuration is uninstalled.
I've tried from both a laptop browser and the server browser with the same result, endless loading.
any other ideas? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-22 11:43:19 |
|
|
|