Thanks
Here is the example: SELECT * FROM NSXLINK...KNA1
NSXLINK is an OLEDB compliant linked server kna1 is the
table. If you select edit you get the error.
If however you submit the following query
SELECT * FROM OPENQUERY(NSXLINK,'SELECT * FROM NSXLINK')
it works. The same problem will appear if you use the
OLEDB provider directly, without the linked server
If you want I can get the error from the program that is
generated
thanks again
dan
[quoted text, click to view] >-----Original Message-----
>Unfortunately, the graphical query editor is a component
of Visual Studio
>which we reuse. If you send me your query, I can file
a bug on their side.
>
>-Lukasz
>
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>
>"dan" <anonymous@discussions.microsoft.com> wrote in
message
>news:befe01c479d1$f409b860$a501280a@phx.gbl...
>> Thank you for the response, I can type in a query in
the
>> generic designed, however if I select edit which is
>> supposed to launch the graphic tool, it crashes. This
is
>> the same behavior whether I use the oledb interface or
>> try to access the same table via a linked-server
>>
>> Regards
>>
>>>-----Original Message-----
>>>Are you using the generic query designer, or are you
>> using the graphical
>>>query desinger?
>>>
>>>-Lukasz
>>>
>>>
>>>--
>>>This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>>>
>>>
>>>
>>>"Dan" <anonymous@discussions.microsoft.com> wrote in
>> message
>>>news:b92401c479a8$2a760220$a601280a@phx.gbl...
>>>> The following problem is occuring when I try to
access
>> a
>>>> table either via an oledb connection or via a linked
>>>> server
>>>>
>>>> I can enter the query in the rs/text box and run it
>>>> sucessfully. If I either goto edit the query via the
>>>> query tool or select the data option. Visual Studio
>>>> crashes.
>>>>
>>>> This scenario reproduces the error
>>>> select * from link...table, however
>>>> this scenario works
>>>> select * from openquery(link,'select * from table')
>>>>
>>>> I have downloaded sp1 for reporting services
>>>>
>>>> thanks
>>>>
>>>> Dan
>>>
>>>
>>>.
>>>
>
>
>.