Click here to Skip to main content
15,887,746 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how do i deploy an application to include sqlserver and microsoft report viewer, so that i can run the application succesfully on a system that visual studio is not installed ?
Posted
Updated 4-Dec-20 21:17pm

There is no problem to develop an application including sqlserver and microsoft report viewer.
You just have to add it's packages when you create your setup, if there is no internet where you are installing it.
If there it internet facility then you can create a setup freely and setup it easily to the other system. It downloads required packages from internet.

You can create any application in vb.net freely.
 
Share this answer
 
Comments
kabiru ajibosin 29-May-11 18:05pm    
i downloaded report view 4rm microsft website and installed it on my pc, i could not see view the report in an application i deployed,

please i want you to give me a step by step method of deployment of vb.net to include sqlserver and microsoft report viewer application or just recommend an ebook that contains my request.

i used wrox beginning vb ebook ,

i want to give my application to 100's of users, so i want it to be as easy as possible for them to install it, ie , report viewer and sqlserver shld be automatically installed as they install the my application. i use visual studio 2008

i will also be glad if u can give me your email so i can mail you directly, expectin your reply
Tarun Mangukiya 30-May-11 7:39am    
You can find complete description on microsoft site. Link :
http://msdn.microsoft.com/en-us/library/ms251671%28v=vs.80%29.aspx

Thanks
Tarun Mangukiya 30-May-11 7:44am    
Is there a report viewer tool in the tool panel. if not then choose it and add it to your form. the from file>New>New File you can create a report for your project. And set the data path to your report viewer.

Then try to run your project I think you can see the report as you have created. Tell me what happens.

Thanks
Tarun Mangukiya 30-May-11 7:45am    
Is there a report viewer tool in the tool panel. if not then choose it and add it to your form. the from file>New>New File you can create a report for your project. And set the data path to your report viewer.

Then try to run your project I think you can see the report as you have created. Tell me what happens.

You can get some help from here: http://msdn.microsoft.com/en-us/library/ms251671%28v=vs.80%29.aspx

Thanks
kabiru ajibosin 31-May-11 16:29pm    
thank tarun,

i know how to use Report viewer very well

it works perfectly when am testing my project in visual studio environment

but when i deploy my appication and run it on my pc, and i try to view reports from the deployed application, it generates Error like this


[See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Program Files (x86)\Microsoft\Staffs Setup\Okeolola.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Microsoft.ReportViewer.WinForms
Assembly Version: 9.0.0.0
Win32 Version: 9.0.21022.227
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/9.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll
----------------------------------------
Microsoft.ReportViewer.Common
Assembly Version: 9.0.0.0
Win32 Version: 9.0.21022.227
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.ReportViewer.Common/9.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.Common.dll]
if i click continue, it shows an empty report


so that is why am asking hw to include sqlserver and reportviewer in my deployment of my project. so that it can work succesfuly on my PC and any other PC that visual studio is not installed.
please help me out
There are quite a few articles here on CP that can help you with deployment[^].

Here[^] is one in particular that discusses the ClickOnce method that karwavivek suggested. Or you can research a visual studio setup project articles[^].

Hope this helps.
 
Share this answer
 
You dont have to install Visual studio on clients computer. All you need is .NET framework on target machine.

For SQLExpress, If you are using Clickonce to publish your application, you can try this link [^] that shown how to customize SQLserver express edition with clickonce deployment.
 
Share this answer
 
anyone can help? My RDLC report is not working at client pc while set reference assembly, but my local pc is working, which I need to install on the client PC in order to make it work?

P/S: If RDLC no reference, it works on the client PC
 
Share this answer
 
Comments
CHill60 7-Dec-20 5:44am    
If you have a question then use the red "Ask a Question" link at the top of this page. Do not post questions or comments as solutions to other members posts

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900