Friday, October 19, 2007

Got it all

Bit late to post this I guess but I actually got 3.1 in my second session!!! :)

So I went for the high dose, which was pretty crappy but I managed quite well, eventually got an immune back after about a month and now after about 2 and a half months even have some fluff on my head again.

So where am I now, well the doctor is positive. I have to wait until 3 months after the chemo before I go for a PET Scan again. Apparently something happens so the PET scans aren't that accurate if you do it too soon after the Treatment.

Anyway, so waiting till about mid November and then I'll finally be done with it!

All prayers and crossed fingers will be appreciated :)

Cannot create a connection to data source 'myDataset'

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 is 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, you are apparently not allowed inverted commas around your attribute names.

Hope someone finds this helpfull

Installing SQL Reporting Services Express

Installing SQL Reporting services Express on Windows 2003 Server "trick"

I dont know why this works but if you are having
  • Security problems with Reporting Services on Windows Server 2003.
  • Trouble logging into reporting services from .NET Report Viewer
The solution is the following:
  1. Open the windows registry
  2. Locate the key HKEY_LOCAL_MACHINES\SYSTEM\CurrentControlSet\Control\LSA
  3. Add a DWork to Value and named DisableloopbackCheck and set its value to 1
  4. Close the Registry and restart the server.
Unfortunately this does not resolve the problem Cannot create a connection to data source 'myDataset'. but at least now you'll be able to log into your report server and report manager and manage your reports.

Wednesday, October 10, 2007