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
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?
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!
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.