OpenAccess.targets paths incorrect

I've been testing OpenAccess, and my test website built fine inside of Visual Studio for me. I wanted to try building the app outside of Visual Studio (nant calling msbuild) so we could run builds on our build server, and I ran into some issues.

I was initially receiving the "No Enhancend Assembly has been found" error, and found this link:
http://www.telerik.com/help/openaccess-orm/openaccess-msbuild-integration.html

That page led me to add the following line into my ORM library project file:
<Import Project="$(MSBuildExtensionsPath)\Telerik\OpenAccess.targets" />

This gave me the following error:
The imported project "C:\Program Files\MSBuild\Telerik\OpenAccess.targets" was not found.

It turns out the the actual path to the targets file on my machine is "C:\Program Files\MSBuild\OpenAccess.targets". Ok, well that was easy enough to change. I took out the "Telerik" from the path.

Then I got the following error:
The "OpenAccessProperties" task could not be loaded from the assembly c:\Program Files\Telerik\OpenAccess\venhance.exe. Could not load file or assembly 'file:///c:\Program Files\Telerik\OpenAccess\venhance.exe' or one of its dependencies. The system cannot find the file specified. Confirm that the <UsingTask> declaration is correct, and that the assembly and all its dependencies are available.

Now it's looking at the target file, but it looks like some of the paths inside are incorrect as well. My OpenAccess directory is "C:\Program Files\Telerik\OpenAccess ORM" (ORM at the end) and there are no exe files in that root directory at all.

I changed lines 29-30 from
<OpenAccessPath Condition="'$(OpenAccessPath)'==''"
                         >c:\Program Files\Telerik\OpenAccess</OpenAccessPath>

to
<OpenAccessPath Condition="'$(OpenAccessPath)'==''"
                         >c:\Program Files\Telerik\OpenAccess ORM</OpenAccessPath>






And lines 35-36 from
<VEnhanceAssembly Condition="'$(VEnhanceAssembly)'==''"
                         >$(OpenAccessPath)\venhance.exe</VEnhanceAssembly>

to
<VEnhanceAssembly Condition="'$(VEnhanceAssembly)'==''"
                         >$(OpenAccessPath)\sdk\venhance.exe</VEnhanceAssembly>

Ran the build again, similar error as before, only now with vschema.exe.

Same thing. I changed the following lines (37-38) from
<VSchemaAssembly Condition="'$(VSchemaAssembly)'==''"
                         >$(OpenAccessPath)\vschema.exe</VSchemaAssembly>

to
<VSchemaAssembly Condition="'$(VSchemaAssembly)'==''"
                         >$(OpenAccessPath)\bin\vschema.exe</VSchemaAssembly>


After these changes, the build succeeded and I was able to view the site.

(I also had to set the OpenAccess_UseMSBuild property to true on the project)

I'm not sure whether I missed some step and am supposed to do this some other way or what. I couldn't find any other info about this.








I have the following versions of OpenAccess installed (copied from the versions dialog in VS2008):

Telerik.OpenAccess.SDK.AddIn:   2009.1.311.1    3/11/2009 2:20:10 AM    C:/Program Files/Telerik/OpenAccess ORM/sdk/Telerik.OpenAccess.SDK.AddIn.dll
Telerik.OpenAccess:   2009.1.311.1    4/14/2009 3:35:51 PM    C:/WINDOWS/assembly/GAC_MSIL/Telerik.OpenAccess/2009.1.311.1__7ce17eeaf1d59342/Telerik.OpenAccess.dll
Telerik.OpenAccess.SDK.Design:   2009.1.311.1    3/11/2009 2:19:24 AM    C:/Program Files/Telerik/OpenAccess ORM/sdk/Telerik.OpenAccess.SDK.Design.DLL
Telerik.OpenAccess.SDK:    2009.1.311.1    3/11/2009 2:19:12 AM    C:/Program Files/Telerik/OpenAccess ORM/sdk/Telerik.OpenAccess.SDK.DLL
Telerik.OpenAccess.Runtime:    2009.1.311.1    4/14/2009 3:35:51 PM    C:/WINDOWS/assembly/GAC_MSIL/Telerik.OpenAccess.Runtime/2009.1.311.1__7ce17eeaf1d59342/Telerik.OpenAccess.Runtime.dll
VEnhance:    2009.1.311.1    3/11/2009 2:19:30 AM    C:/Program Files/Telerik/OpenAccess ORM/sdk/VEnhance.EXE

Hi Andy,
Yes you managed it right, but form my point it looks like either we have outdated article that you used or some steps are missing. Could you suggest what exactly to improve inside the MSBuild integration topic?

Sincerely yours,
Dimitar Kapitanov
the Telerik team

There were really two main issues:

1. The path for the OpenAccess.targets file in the article was incorrect. For whatever reason, the version I'm running and the article don't match up there.
2. The paths inside the OpenAccess.targets file are incorrect. These should match up to the paths where OpenAccess is actually installed. I did a default install, so there shouldn't have been any weirdness with that.

I forgot to mention this before, but other paths in the file looked to be incorrect as well. There are paths that look like "$(OpenAccessPath)\sdk\dotnet20\venhance.exe", which is an invalid path. (there is no dotnet20 directory)

It also looks like we may not have the latest version. Could this be an issue as well?

Hello Andy,
Yes it could but I thought you have the latest. Can you check and verify this?

Sincerely yours,
Dimitar Kapitanov
the Telerik team

I don't have the license hooked up to this account, but it looks like there was a service pack released in April or something? I doubt I will have time to check into it today, but I can take a look at it early next week perhaps.

Hello Andy,
Thanks for your cooperation.

All the best,
Dimitar Kapitanov
the Telerik team