I almost pulled the hair out of my head trying to resolve this stupid error when working with SQL
Reporting Expresses Data source connection limitations;
Cannot create a connection to data source 'myDataset'
The solution to my problem was quite simple yet mystifying, the two connection strings below should be pointing to the same database
Does not work in Reporting Services Express: Server='MyDataBase\SQLEXPRESS';Database=Catalog;
Works in Reporting Services Express: Server=MyDataBase\SQLEXPRESS; Database=Catalog;
In case you miss the difference, I could not get the connection to work if I used inverted comma's around me arribute names.
Hope someone finds this helpfull
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment