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. We are not accessing the data from or for any IIS application. Just the SQl Server 2000 Query Analyzer and stored procs in the future.
Any suggestion of what we're doing wrong would be appreciated. |