Why is ADO.NET not showing in Set Datasource Location?

[Former Member]

I am using Crystal Reports 2013 Support Pack 7, CR Developer.

Under "Set Datasource Locations", I cannot get ADO.NET to appear. This is a requirement for the reports I will be creating.

I have tried a few solutions from online forums.

These didn’t work: adding a custom config file to the directory, uninstalling 2.0 .NET Framework, modifying CR Designer to include ADO.NET, uninstalling and reinstalling Crystal Reports.

I have all the latest .NET frameworks included and optional with Visual Studio Community 2017. I don't know what else to do. Please let me know if you require more information.

[daniel_paulsen · Accepted solution]

Hi John,

Is it possible you did not select ADO.NET when installing? You can check by going to Programs and Features on you computer and select uninstall/modify.
Select modify and see what shows for ADO.NET

Dan

[Former Member · Accepted solution]

ADO.NET(XML) was selected while installing, modifying, and reinstalling.

[daniel_paulsen · Accepted solution]

That is odd then.

Search your hard drive for the following file: crdb_adoplus.dll

What are all of the directory locations that it exists and what are the version numbers ( ie: 14.x.y.z)?

Dan

[Former Member · Accepted solution]

1 file: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86

It is File version 14.0.2007.1853

Product version: 14.1.7.1853

[daniel_paulsen · Accepted solution]

that's the correct location and version number for CR2013 SP07.

I'm not sure why it would not show up in the Designer. Is the resource file there as well (crdb_adoplus_res_en.dll)? I believe that is where the text "ADO .NET" comes from in the database window.

Try running ProcessMonitor from Microsoft and see if there is any failure opening the crdb_adoplus.dll.

[former_member11696]

Hi John,

I've never seen that before, it's always there.

Maybe this google search is the answer:

https://stackoverflow.com/questions/21073975/there-is-no-ado-net-entity-data-model-in-visual-studio

Don