all groups > sql server reporting services > august 2004 >
You're in the

sql server reporting services

group:

Can't access OLEDB datasource


Can't access OLEDB datasource Dan
8/3/2004 3:21:04 PM
sql server reporting services:
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

Re: Can't access OLEDB datasource Lukasz Pawlowski [MSFT]
8/3/2004 5:27:59 PM
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.



[quoted text, click to view]

Re: Can't access OLEDB datasource dan
8/3/2004 8:20:12 PM
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

[quoted text, click to view]
Re: Can't access OLEDB datasource Lukasz Pawlowski [MSFT]
8/4/2004 11:09:34 AM
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.


[quoted text, click to view]

Re: Can't access OLEDB datasource Dan
8/4/2004 6:34:52 PM
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]
AddThis Social Bookmark Button