Connector Error

[stuartgmilton]

Hey guys,

So when I have a report based on a stored proc and another table, whenever I try and display data from both tables I get the following errors in this order.

"Failed to retrieve data from he database."
"Unknown Database Connection Error"

Can anyone shed any light on this situation?

 

[Turkbear]

Hi,
Not without more info:
What database ( same for both Proc and Table?)
What Connection Method?
Does a report that only uses the Proc or the Table work?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[stuartgmilton]

Hi sorry for the lack of info,

Its a sql server db.

If I report on the stored proc and the views seperately I get the expected data on the report.

I connect via OLE DB (ADO).

I can post the code if someone tells me the tag for it?

Stu