EDN Admin
Well-known member
<span><span><span><span><span>
Hi Team,
Let me give you the background of my situation:
<span style="text-decoration:underline Platform:
Machine: Dell XPS 15z<br/>
OS: Win 7 SP1 64 Bit<br/>
Database: Access 2010 (32bit)<br/>
Dev Platform: Visual Studio 2012 Professional Edition
<span style="text-decoration:underline Aim/Result:
Developed a database solution where user can import/export data with lots of data manipulation and analysis.
<span style="text-decoration:underline Methodology Used:
Initial Data connection was made via "<span style="line-height:115%; font-family:Calibri,sans-serif; font-size:11pt C:UsersxxxxDocumentsVisual Studio 2012ProjectsDatabasedb.accdb" and then said "Yes" to copy the database file to project
to bin directory.
All the coding reference to db was made via "Data Directory" in path. Worked absolutaly fine on my machine.
Included Report viewer control for reports.
<span style="text-decoration:underline Deployment:
Not my area of expertise however, tried to publish the application with prerequests for
- Microsoft .NET Framework 4.5 (x86 and x64)<br/>
- Microsoft Report viewer 2012 Runtime<br/>
- Microsoft System CLR Types for SQL Server 2012 (x86)<br/>
- Microsoft System CLR Types for SQL Server 2012 (x64)
Initially decided to get user to download it however, then to allow offline installation included via Bootstraper.
Published via ClickOnce<br/>
Thank you so much for reading this far, I really appreciate it. Now the fun part
<span style="text-decoration:underline Problems/Consideration/Issues:
- When I tried to deploy it via ClickOnce, everything went smoothly for prerequisities, until it checked for trust status, and then thrown the below error " Cannot Continue. The Application is improperly formatted. Contact the application vendor
for assistance " with details as attached: I tried to crawl through the problem on net and can confirm that I havent got any cyclic reference within my project, it could be trust certificate issues was the last scenario, Any heads up would be
a massive favour.
<img alt="Cannot Continue. The Application is improperly formatted. Contact the application vendor for assistance" src="http://social.msdn.microsoft.com/Forums/getfile/174346
-Right to circumvent this issue, I decided to just copy bin Directory to deployment machine, which did successfully installed the prerequisities until above problem came up and started the Application. First login form loads perfectly. I thought Viola, which
only lasted a second as I tried to login, I got error message "Microsoft.ACE.OLEDB.12.0 Provider is not registered on the local machine error".
So thought lets install Access 2010 reditributable for x86, only to realise that machine is on x64 and so does Access 2020. So, now installed x64, and a restart, still no joy. WHAT SHALL I DO? Build for this project at
this time was for Any CPU profile. Do I have to create two seperate publish for x86 and x64 for my program? What would you guys say? From your past experience what could be the best way forward?
- I created another build based on x86 from Configuration manager to test another machine, which have had x64 OS however, x86 Access. Installed x86 Access Redistributable and worked like charm until I tried to change some data and it gave me error which
said the dataset cannot be edited (I havent got error screenshot as the machine is not here with me right now), when I looked at the detail I was gobsmacked, as connection string was still looking at the path I given for my data connection on my development
machine !!!! How can this be possible or am I the dumbest of all dumb in this world. Please guys enlighten me with your wisdom. How can this be possible. I thought using the "data directory" in my connection string, i am not hard coding my path.
But it looks like it has.
I am utterly grateful for reading my looong post and I really appreciate any word of wisdom.
Thank you
Kind regard
Sap
<br/>
<br/>
View the full article
Hi Team,
Let me give you the background of my situation:
<span style="text-decoration:underline Platform:
Machine: Dell XPS 15z<br/>
OS: Win 7 SP1 64 Bit<br/>
Database: Access 2010 (32bit)<br/>
Dev Platform: Visual Studio 2012 Professional Edition
<span style="text-decoration:underline Aim/Result:
Developed a database solution where user can import/export data with lots of data manipulation and analysis.
<span style="text-decoration:underline Methodology Used:
Initial Data connection was made via "<span style="line-height:115%; font-family:Calibri,sans-serif; font-size:11pt C:UsersxxxxDocumentsVisual Studio 2012ProjectsDatabasedb.accdb" and then said "Yes" to copy the database file to project
to bin directory.
All the coding reference to db was made via "Data Directory" in path. Worked absolutaly fine on my machine.
Included Report viewer control for reports.
<span style="text-decoration:underline Deployment:
Not my area of expertise however, tried to publish the application with prerequests for
- Microsoft .NET Framework 4.5 (x86 and x64)<br/>
- Microsoft Report viewer 2012 Runtime<br/>
- Microsoft System CLR Types for SQL Server 2012 (x86)<br/>
- Microsoft System CLR Types for SQL Server 2012 (x64)
Initially decided to get user to download it however, then to allow offline installation included via Bootstraper.
Published via ClickOnce<br/>
Thank you so much for reading this far, I really appreciate it. Now the fun part
<span style="text-decoration:underline Problems/Consideration/Issues:
- When I tried to deploy it via ClickOnce, everything went smoothly for prerequisities, until it checked for trust status, and then thrown the below error " Cannot Continue. The Application is improperly formatted. Contact the application vendor
for assistance " with details as attached: I tried to crawl through the problem on net and can confirm that I havent got any cyclic reference within my project, it could be trust certificate issues was the last scenario, Any heads up would be
a massive favour.
<img alt="Cannot Continue. The Application is improperly formatted. Contact the application vendor for assistance" src="http://social.msdn.microsoft.com/Forums/getfile/174346
-Right to circumvent this issue, I decided to just copy bin Directory to deployment machine, which did successfully installed the prerequisities until above problem came up and started the Application. First login form loads perfectly. I thought Viola, which
only lasted a second as I tried to login, I got error message "Microsoft.ACE.OLEDB.12.0 Provider is not registered on the local machine error".
So thought lets install Access 2010 reditributable for x86, only to realise that machine is on x64 and so does Access 2020. So, now installed x64, and a restart, still no joy. WHAT SHALL I DO? Build for this project at
this time was for Any CPU profile. Do I have to create two seperate publish for x86 and x64 for my program? What would you guys say? From your past experience what could be the best way forward?
- I created another build based on x86 from Configuration manager to test another machine, which have had x64 OS however, x86 Access. Installed x86 Access Redistributable and worked like charm until I tried to change some data and it gave me error which
said the dataset cannot be edited (I havent got error screenshot as the machine is not here with me right now), when I looked at the detail I was gobsmacked, as connection string was still looking at the path I given for my data connection on my development
machine !!!! How can this be possible or am I the dumbest of all dumb in this world. Please guys enlighten me with your wisdom. How can this be possible. I thought using the "data directory" in my connection string, i am not hard coding my path.
But it looks like it has.
I am utterly grateful for reading my looong post and I really appreciate any word of wisdom.
Thank you
Kind regard
Sap
<br/>
<br/>
View the full article