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
|
|
OpenQuery not return rows |
Author |
Message |
|
Posted : 2007-08-31 07:24:13 |
OPENQUERY LINKED SQL SERVER RETURN NOTHING
SELECT * FROM OPENQUERY(QODBC, 'SELECT Name, CompanyName FROM Customer')
(0 row(s) affected)
why? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-08-31 08:11:35 |
Most likely you are using VB Demo and/or Management Studio at the same time. The QODBC optimizer is single user only so you need to setup a different optimizer file for the SQL Server to use than the other desktops applications. To do this step up a seperate System DSN (see: How do I create or configure a QODBC DSN? ) and specify a fixed location of the optimizer database folder for SQL Server to use instead of the default UserProfile method.
Please read the thread found at: Does QODBC work with MS SQL Server 2005 Linked Tables? for more information.
A workaround would be:
SELECT * FROM OPENQUERY(QODBC, 'SELECT FullName FROM Customer VERIFY where FullName = ''x''') |
|
|
|
|