We are trying to set-up a link server in SQL Server 2000 to QBES 8.0
We have read through many of the posted articles and have tried most solutions.
We can run the query SELECT * FROM OPENQUERY(QODBC, 'SELECT * FROM HOST unoptimized') It returns a row.
If we take the unoptimized off, it returns no rows.
We're logged onto the server as administrator
We have run the optimizer ReloadAllData several times. With the %UserProfile%\QODBC Driver for... path , c:\QODBC Driver for ..., D:\QODBC Driver for ... with the same results. We've Deleted the .OPT file and rebuilt from scratch. We have made every folder on c: and d: read/write (full control) temporarily for every user to get this to work, with no success.
It can't be this hard to get the linked server working.< |