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
|
|
Missing Records |
Author |
Message |
Ian |
|
Group | : Members |
Posts | : 19 |
Joined | : 2006-05-03 |
|
Profile |
|
Posted : 2006-07-07 00:47:04 |
For the last year performing the following query:
SELECT ListID, FullName, IsActive, SubLevel FROM OPENQUERY(egroup_QB,'SELECT ListID, FullName, IsActive, SubLevel FROM Customer')
has returned about 300 records. It now returns 15 and earlier it wasn't returning any. I have reloaded all data using the QODBC setup screen. The VB Demo works fine. The above happens in SQL Server 2005.
Please help.
Ian |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-07 08:42:43 |
When calling QODBC from SQL Server Linked Tables the OPENQUERY is executed in multi-treaded mode and may corrupt the optimized .opt file. You need to reset the QODBC optimizer or switch it off. See: How do I switch OFF or RESET the QODBC optimizer? for more information. |
|
|
|
Ian |
|
Group | : Members |
Posts | : 19 |
Joined | : 2006-05-03 |
|
Profile |
|
Posted : 2006-07-07 12:12:51 |
I turned off the optimizer, delete the opt file and turned it back on. I re-submitted my customer query and at last glance it had been running for 2 hours, 45 minutes with no results. |
|
|
|
|