No Data with SQL Query |
Author |
Message |
|
Posted : 2009-02-06 07:27:12 |
No data results with these queries inside vbdemo or SQL (web):
SELECT * FROM ItemNonInventory optimized SELECT * FROM ItemNonInventory unoptimized SELECT * FROM ItemNonInventory NOSYNC SELECT * FROM ItemNonInventory
There are hundreds of products in this table - should bring back something.
Also, why is NOSYNC tremedendously fast? Can this be used on all and any queries? Why is this not defaulted as the way process to run queries?
How can I get some data back? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-06 15:15:06 |
|
|
|
|
Posted : 2009-02-07 03:10:45 |
This software is so unpredictable and VERY frustrating.
The ODBC was connecting fine yesterday, now its not.
Nothing has changed, and now Im getting this error AGAIN...
[Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] QB Open Connection Failed. Error = 80040402, Exception in OpenConnection: No connection could be made because the target machine actively refused it
How do you close a connection with coldfusion (not vbscript, dos commands, basic commands, c++ commands)? Is there a way to send a close connection request thru coldfusion? |
|
|
|
|
Posted : 2009-02-07 03:20:16 |
OK I am connected again....
I did the changes to the optimizer screen...run a query - and no results!!
SELECT ListID,FullName FROM ItemNonInventory
What now? |
|
|
|
|
Posted : 2009-02-07 03:57:02 |
BTW - im using odbc v9 and enteprise v9 with R6 patch.
When trying to use unoptimized after the table name it gives an error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] Error
SELECT ListID,Name,FullName FROM ItemNonInventory unoptimized WHERE Name = '51054' ORDER BY ListID |
|
|
|
|
Posted : 2009-02-07 04:30:20 |
Also, no records coming back in VBDemo as well...
I had results coming back before we upgraded - v7 would pull data back using the unoptimized after teh table name - now with Enterprise9 i can query table columns and tables, but no records. |
|
|
|
|
Posted : 2009-02-07 07:23:29 |
Im now getting this error when running a query:
SQL |
SELECT ListID FROM ItemNonInventory WHERE Name = '51054' ORDER BY ListID |
[Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] Error
I can query tables and column names just fine thru coldfusion. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-07 09:59:16 |
Please reboot your computer as you have QODBC connections stuck in memory.
See also: Does QODBC work with Coldfusion?
Note: You need to have the full product version of QODBC v9 and have purchased a QODBC v9 Server Edition CDKey Code. You can't use the FREE QODBC Enterprise Edition with Coldfusion. |
|
|
|