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
|
|
Can't query through QODBC after an update - IIS Crashes |
Author |
Message |
|
Posted : 2008-08-26 04:18:38 |
Here's my update sql -
UPDATE Customer Set CompanyName = 'John F. Griffin MD', FirstName = 'John', LastName = 'Griffin', BillAddressAddr1 = '512 Irving St', BillAddressAddr2 = 'Suite 3', BillAddressCity = 'Syracuse', BillAddressPostalCode = '90210', BillAddressState = 'NY', Phone = '315-425-4444', fax = '' where FullName like '11882%'
The update works. But after I update, I can't run a simple select afterwards. I am using the DCOM servers with PHP.
Here's one of the following selects
Select refnumber, duedate, invoicelinerate, invoicelinedesc, invoicelineamount, balanceremaining from invoiceline where customerreffullname like '11882%' and ispaid = 0
Is it something with connection pools? I create a new connection for each sql command and close the connection after each.
I can go around my website querying with selects as many times as I want. But never after the update. If I try to query with a select statement after and update IIS Crashes.
Any Ideas? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-26 08:27:49 |
To start with, connection pooling must be disabled:
The second thing, it's better to leave the connection open and close it when you terminate the PHP script.
The last thing is don't use like as it requires QODBC to do full table scans. Use where FullName = 'Tom' instead. |
|
|
|
|
Posted : 2008-08-29 02:16:22 |
Turned out that my update statement had fields out of order. The update fields
Update invoice set column1 = "datafor1" , column2 = "datafor2" have to be in this proper order as listed in the references. I had columns out of order. It would update, but then crash the driver.
Usually with databases you don't need to constrain to a proper order, but with quickbooks you have to. Keith - Mednet Technologies |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-29 08:10:46 |
Correct, you should always use:
sp_columns tablename
to see what is the order and typing of columns. |
|
|
|
|