|
How to pack MSDE with the .Net setup and set a sequence that MSDE is installed first and then the application.Although bootstrapper helps in installing MDAC and .Net framework on the target machine if they are not found, how can we set a sequence in bootstrapper to install MSDE.
|
|
|
|
|
Short answer:
1. Install the bootstrapper on your development machine
2. Create a setup project for your app
3. Use the bootstrapper to mask your setup project.
Long(er) answer:
1. you do not have to setup any sequence. The MSDE bootstrapper has the sequence built in already
(Install .Net, Install MSDE, Install your app). You cannot change that sequence. That is all the bootstrapper does.
2.There are some configuration options but they relate to whether you want to use a strong password on the sa account (of MSDE) and/or hard coded paths for the databases. Also some settings for what to dislay in prompts and such...
3. The bootstrapper doc is typical MS (sparse and cryptic) but the bootstraper is so simple that the MS documentation is all you need.
|
|
|
|
|
I'm trying to use bootstarpper for deploying msde but to no sucess.tell me in how to use it
|
|
|
|
|
|
i m using the same toolkit sample the problem is at step 3 of MSDE Bootstrapper it says the location does not contain any valid MSDE files which i have populated with sql database file and if u can tell me what to put for four value in the combo box.
|
|
|
|
|
If you are referring to the window that reads
"MSDE 2000 bootstrap loader configurator (Page 3 of 6)", you need to choose a location for EACH of the values in the combo box.
None of those values is the location of YOUR database. Your database should
be packaged with your application's intallation files and the restoring of it
done either manually or programatically by your application. The bootstrapper does NOT do restoring of databases.
The value that should go in the "MSDE Files" option is the location where the MSDE installation files are (the files you'd run if you wanted to install MSDE manually). Nothing to do with your database.
The value should be drive:\whereveryouinstalledthedeploymentkit\template\cd\msde\
As far as your database files are concerned, they should be added to your apps setup package as just another file(s). Then the person who installs the app restores the database manually, OR you write some code in your app that checks for the db and restores it if not there.
Hope this helps.
|
|
|
|
|
Using mapi32.dll with vb.net to compose and show a new mail message with attachments works with Outlook Express but not Outlook 2000. I can bring up a message in Outlook 2000 ONLY if it doesn't have attachments. The error returned while trying to attach files is "Unspecified Error"! Anybody knows what's up?
|
|
|
|
|
Cannot access attachments
http://support.microsoft.com/?kbid=318515
|
|
|
|
|
The files I'm trying to attach are jpg picture files. They are not in the level 1 (unsafe) category. I turned off the security for attachments and it didn't make any difference.
|
|
|
|
|
I have a tabcontrol which I have added a MonthCalendar1 to Tabpage1.
Is it possible to display this MonthCalendar1 on another Tabpage?
If so how would I go about doing this? Or would I just add another MonthCalendar to this Tabpage?
Cheers in Advance
Procrastifixation (adj)- the time taken to fix a software bug.
|
|
|
|
|
Hi There
I'm badly stuck trying to get what seems to be a very simple crystal report to display in the report viewer. I am using the .NET 2003 version of CR (which I have been told that is basically version 9.0) and SQL Server 2000.
I have been through multiple articles/tutorials regarding this issue but all seem to be based on creating design time SqlDataAdapter, SqlDataConnection, DataSet objects. However, I require these objects (or at least the adapter) to be created at runtime as the query that the report can be based on is dynamically built by the user.
So just to get a handle on what is going on I thought I would try a very simple single table query before messing around with the actual multi-table inner-outer join nightmare that I really need. That was three days ago...
I have created a dataset by dragging the single table "tbl_Students" onto the dataset design form. I can't see anything else I have to do here. I also created the crystal report using the report expert and simply added all the fields of the table to this report.
Here is the rest of my code:
Dim adConn As New SqlConnection("Initial Catalog = DBName;Data Source=Server;Integrated Security=SSPI")
Dim adCmd As New SqlCommand("SELECT * FROM tbl_Course", adConn)
Dim adAdapter As New SqlDataAdapter(adCmd)
Dim dSet As New CrsInfo
adAdapter.Fill(dSet)
Dim stuRep As New Students
stuRep.SetDataSource(dSet)
cvwMain.ReportSource = stuRep
I continually get Crystal Report Windows Forms Viewer Error that simply says Query Engine Error with a path to some temp_GUID.rpt file in my user profile. If I do the design time drag and drop with a connection object, adapter object and a dataset object all works well, but this is not what I need. Any help will be much appreciated.
Thanks.
Mountie
|
|
|
|
|
In my cut and paste frenzy, I forgot to change all kinds of things in the code. I'm going to retry and post my results in a minute or two...
|
|
|
|
|
Okay - success!!
Despite my code posting not making any sense let me assure you that that was just a cut and paste error. However the problem really was that when I called the .Fill method of the DataAdapter I didn't specify which table to use for the field mappings. If you don't, the report comes out blank! Hmmmm, what about when I do the real multi-table query? I'm assuming I have to use the field mapping editor with the DataSet - yes?
Thanks everyone for letting me vent and solve my own problem (I hope)...
|
|
|
|
|
Okay, now that I have mastered my single table report, I thought I would plunge into the multi-table report.
But I do have a couple of questions regarding the DataSet design. Do I just drag the tables onto the designer form and that's it? Do I have to worry about the relationships between the tables? Also, I do not require all the fields from all the tables. Can I eliminate some of the fields so the dataset fields more closely match the query? Does it matter one way or the other?
Thus far I just dragged the tables onto the designer and didn't do anything else and surprise surprise my report runs but it is blank. So, besides the above, is there anything else I need to worry about to get this report to run?
Again, any help is much appreciated
Thanks.
|
|
|
|
|
How do I show and hide controls. In particular I need to show and hide a picturebox, label and command button.
Thanks,
Tim
|
|
|
|
|
Use the visible property
Well.. later
|
|
|
|
|
Found the answer... Need to set the Visible property.
Thanks,
Tim
|
|
|
|
|
I need to write a program that every morning at 5am its start a verification on a table in the SQL Server, is Windows Services a good way or is there another way around ? Thank you very much for your time.
Well.. later
MCP
|
|
|
|
|
Sebastien_Lachance wrote:
I need to write a program that every morning at 5am
You can use Windows' Task Scheduler service to do this (see How To Use the AT Command to Schedule Tasks[^]).
is Windows Services a good way or is there another way around ?
I'd say creating a service is a good idea if you want to run something unattended and without desktop interaction. However keep in mind that if you create a service on your own you'll also be responsible for the scheduler logic. You'll have to decide which solution is most suitable for your requirements.
Best regards
Dennis
|
|
|
|
|
hummm i think right now the best choice i have is to create a small program, and will try to make it run with the Task Scheduler. Thank you
Well.. later
|
|
|
|
|
Hey,
I am using a PDF printer.
I am setting the "HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows" Device key to my PDF printer to set it as the default printer so that it is automatically selected when a application prints.
But some applications succesfully recognise the newly set key as the new default printer and others do not, and only see the previous default printer.
Is there another value that i need to check or set for all applications to use the newly set default printer?
Thanks for your help
Chris
|
|
|
|
|
I'm using code I found on Internet (www.TheScarms.com) to populate/update Excel data from VB.net project. When debugging I'm getting the following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in PRCoverSheet.exe
Additional information: Invalid index.
The code of the part that gives the error is:
'Open the XLS file and activate the worksheet to populate:
Dim strWorkSheetName As String = "MyData"
Dim sbExcelData As System.Text.StringBuilder
Dim aWorkbook As Excel.Workbook
Dim aWorkSheet As Excel.WorksheetClass
aWorkbook = myExcel.Workbooks.Open(strExcelFile)
aWorkSheet = CType(aWorkbook.Sheets(strWorkSheetName), Excel.Worksheet)
' CType(myExcel, Excel._Application).Quit()
aWorkSheet.Activate()
The debugger highlights the following statement:
aWorkSheet = CType(aWorkbook.Sheets(strWorkSheetName), Excel.Worksheet)
What could it possibly be and how can i fix it?
Thank you all in advance
Alika
|
|
|
|
|
Is it possible to change printer settings through a VB .NET program? Ex Number of copies, duplex, custom paper type, etc
If you have some suggestions or examples that would be great, if not I will have to make do with an answer if it is possible or not.
Thanks
Mark
|
|
|
|
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconPrintSupport.asp
Try this link, it may be not what you wanted but im pretty sure y'oull find a response there.
Well.. later
|
|
|
|
|
Hey,
I was wondering when the 'X' is clicked in the top of the application window to exit the application what is the event that fires? As i need to set values back to defaults etc.
Any help would be appreciated
chris
|
|
|
|