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
|
|
Cannot connect with IIS/PHP |
Author |
Message |
|
Posted : 2006-09-02 00:17:19 |
I am having some problems connecting with PHP under IIS. I have configured QODBC using the DCOM servers options. The TestDCOM.php from the QODBC website shows success when running, but the DisplaySQL.php script doesn't work. I get the following error message:
Warning: odbc_connect(): SQL error: [QODBC] QB Open Connection Failed. Errored trying to Create IBiz QuickBooks Integration Object, SQL state S0000 in SQLConnect in D:\terraman\website\test\DisplaySQL.php on line 22
Everything works from the VB Demo. We are using QB Pro 2006, Windows Server 2003 SP1, PHP 4.4.4. I've configured all of the permissions and rebooted the server as described in the DCOM configured. I have QB running from the Console under the admin account from the server's console. Everything is being run from the same server. This server already had PHP and IIS configured for a production application we wrote and maintain. I am using the default DSN, QuickBooks Data. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-02 09:40:09 |
The error is pointing to the IBiz Remote Connector. You either run QODBC using the DCOMs or you use the Remote Connector. Not both! The only other reason I can think of why you get the error is that you may be trying to use the QuickBooks Online Edition? Check your settings in the QODBC Setup screen or the connection string you are using. It can't have references to the IBiz connector like this:
strConnect = "ODBC;DSN=QuickBooks Data;DFQ=C:\QUICKBOOKS\baselineNov17th.QBW;" & _ "OpenMode=M;SERVER=QODBC;IBizRemoteConnect=Yes;" & _ "IBizRemoteURL=http://localhost:2080;IBizRemotePWD=reporting;" & _ "IBizRemoteConnTimeOut=1000;"
if you are using DCOMs.
See: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? for more. |
|
|
|
|