ADO.NET (XML) Datasource Missing

After I installed SQL 2005 Express I lost the ADO.NET (XML) datasource option, I am using Crystal Reports v9. Does anyone know how I can get it back? I have tried unistalling SQL 2005 Express, Crystal Reports, and Visual Studio(2003), and then reistalling Crystal Reports and Visual Studio.
Thanks

[309 byte] By [ShawnSonger] at [2008-1-7]
# 1
I found out this is caused by the .NET Framework 2.0. Once that was unistalled the ADO.NET (XML) Datasource was restored in Crystal Reports 9.
ShawnSonger at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 2
I too have this problem (and can fix it by un-installing .Net 2.0). Does anyone have a better way of fixing this though? I work on both 1.1 and 2.0 so it's a bit of a pain to have to keep un-installing version 2.0.

As a side point, 2.0 also seems to break the typed dataset designer in VS2003.

Does anyone know of a work-around (or is there a patch from Microsoft/Crystal available)?

Thanks,
Simon.
*NOTE: I'm still using the last Beta of 2.0 so does anyone know if the problem is fixed in the final version?

simonl1980 at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 3
I was using the released version of .NET 2.0 and was getting these problems.
ShawnSonger at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 4

I have installed only the release version of the .NET 2.0 framework and cannot access the ADO.NET datasource either in Crystal Reports 9. I need to have the .NET 2.0 framework installed as I am working with SQL 2005. Anythoughts on how to get the datasource back or if there is a fix available?

MarioSpanicciati at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 5
The only fix I found was uninstalling the 2.0 framework. I never found any other information on the Microsoft or Crystal Reports websites about this. I would guess that CR is not going to come out with a fix since they say CR9 will not work with VS 2005.
ShawnSonger at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 6
YYYEEESSSS!!!!!!!!!!!!!!

This has driven me mad for long enough, so today I devoted a bit of time to fixing it... the solution is easy - don't know why I didn't think to try it before!

All you need to do is add a crw32.exe.config file to the Crystal 9 program directory with the following contents...

<configuration>
<startup>
<requiredRuntime version="v1.1.4322" />
<supportedRuntime version="v1.1.4322" />
</startup>
</configuration>

Note, that it will also work if you force it to use version 1.0. Once this file is added, you can create ADO.Net (Xml) reports without installing/uninstalling .Net v2.0!

Let me know if this works for you too - suddenly my day seems so much better!!

Simon.
PS - thanks to sysinternals/lutz roeder for their lovely tools that helped trace this problem!

simonl1980 at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 7
Simon,

Thanks so much. That worked perfectly.

Mario

MarioSpanicciati at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 8

Hello

I have been struggling with this problem all morning and I have just noted your suggestion about creating the crw32.exe.config file.

This is probably me being stupid, but not sure whether I've done the right thing as it's still not bringing up ado.net.

I went into notepad, copied the text :

<configuration>
<startup>
<requiredRuntime version="v1.1.4322" />
<supportedRuntime version="v1.1.4322" />
</startup>
</configuration

Then, saved it as crw32.exe.config in the directly c:\program files\crystal decisions\crystal reports 9.

Is there anything else I need to do?

Not sure whether this is realted, but I'm also getting an error that it can't load crdb_adoplus.dll file when I try to refresh report data.

Any help would be appreciated!

Thanks.

EmmaTaylor01 at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...

Visual Studio

Site Classified