Click to See Complete Forum and Search --> : Setup & deployment project in Visual Studio 2005 !


jeshra279
October 21st, 2009, 11:26 AM
I have designed a VB.NET application with SQL server 2005 Database and Crystalreport in Visual Studio 2005.

To install my project on client machine, I have created the setup project in Visual Studio 2005.I am using sql server 2005 express edition as .mdf database file in my project. After installation of the setup project on my client machine, my SQL database file ".mdf" was absent, due to which my application is not able to connect to the database.
My client machine doesnt have sql server installed. Do I need to install separately or there is any option while creating setup project to include sql server files? What are the system/software requirements on my client machine required for my application to install/run.
Can someone Pls help me on this?

HanneSThEGreaT
October 21st, 2009, 11:43 AM
You simply need to add the MDF file(s) to your installer :

http://www.startvbdotnet.com/extras/deploy.aspx

jeshra279
October 21st, 2009, 02:28 PM
Hi,
I have added that .mdf file, but my client m/c doesnt have sql server 2005, so this mdf file is not read by the application installed. I think i have to install sql 2005 on my client machine and configure the path in project.
Please suggest on this?

dglienna
October 21st, 2009, 07:44 PM
SQL Express is free, and works

jeshra279
October 21st, 2009, 11:10 PM
I didnt get what i have to do?
Do i need to install SQL on my client m/c?
also, My application uses crystalreport control, so do i need to install crystal report separately on my client machine?

HanneSThEGreaT
October 22nd, 2009, 12:47 AM
Ok, then with your logic, what is the purpose of installing your app then, if you say you still need to install SQL Express ¿ :confused:

You don't have to. You may have to go to ODBC Datasources, and configure it there. To answer your question about Crystal Report, When you create a setup program, that should be detected in any case.

dglienna
October 22nd, 2009, 11:01 PM
Crystal Reports are different. You need to include certain files, or else the reports won't run. Contact them, here: http://www.sap.com/solutions/sapbusinessobjects/sme/reporting-dashboarding/reporting/visualstudio/index.epx