Jacco Mintjes's Q&A profile

• Visual Studio Team System Branching across projects

  I'm looking for current thoughts regarding branching across team projects and support where you have common components that live in separate team projects. To keep this "simple" let's assume the following: Common Library projects - each contain a number of projects that are intendeded to be used by multiple "Products" CommonProjectA CommonProjectB "Products" - These are the end products, and each use either A/B or A&B - Each can release together or at different times ProductA ProductB ProductC - "C" agregates and depends on Product A & B of a consistent release Each Product A , B and C each have their own solution file that includes the relavent projects from CommonProject ...Show All

• SQL Server Scheduled subscriptions don't work (but Event-driven ones do) for NS Newsletter sample

  Hello, I am using the Newsletter sample bundled with Notification Services (using SQL 2005 SP1) When I create Scheduled subscriptions using the 'SubscriptionManagementWeb' app that ships with the sample, then copy an Events.xml file to the watch folder, I never get an alert (i.e. I set the time to now + 5 minutes, wait, never receive). When I create an Event-driven subscription, on the other hand, and copy an Events.xml file to the watch folder, I do successfully get a notification. I also created my own separate NS application, and it has the same problem as the sample. Event-driven subscriptions work, but Scheduled ones do not. Any ideas TIA, Alex Hi I don't know if you have ch ...Show All

• Visual Basic Deleting all the records from an access database.

  I have an access database that i need to empty before i import new records to it. I have tried filling the a dataset with the old data i need to get rid of and doing a table clear then a update but the change doesn't make to the database. I also tried to do a delete row but how do i get that to work for all the records in the database I have been look around all day and havent been able to find anything that works. I need some guidence please here is what i currently have Dim psrdCurrent As System.IO.StreamReader Dim pintCount As Integer Dim pstrLine As String Dim pstrFields() As String Dim tblEobData As New DataTable Dim pintrecords As Integer 'Need to clear database before putting in new records pintreco ...Show All

• SQL Server fill factor value

  I do have table like this (    uniqueid int  ,scandate datetime ,courseno varchar(10) ) this table has two indexes: primary key clustered index on uniqueid, scandate non-clustered index on courseno asc, uniqueid asc, courseno asc this table can have 10 million records. there are no updates to this table. only data is inserted and selected from this table. when i created these indexes the default fill factor value is 0. should i change the fill factor. Thanks   sandeep, see BOL http://msdn2.microsoft.com/en-us/library/ms177459.aspx Quick answer is probably OK, but read the article to determine if something in your environment (disk space limitation ...Show All

• SQL Server SQLXMLBulkLoad and MSOLAP provider

  Hi All, I tried to connect Foodmart 2000 in AS 2000 by SQLXMLBulkload using MSOLAP.2: Dim objBL Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0") objBL.ConnectionString = "provider=MSOLAP.2;data source=localhost;database=Foodmart 2000;integrated security=SSPI" objBL.ErrorLogFile = "d:\Users\Bulkxml\error.log" objBL.CheckConstraints=true objBL.XMLFragment = True objBL.SchemaGen = True objBL.SGDropTables = True objBL.Execute "SampleSchema.xml", "SampleXMLData.xml" Set objBL = Nothing and get the error message: Line 12 Error: Invalid connection string Code: 8004e21 Source: Microsoft XML Bulkload for SQL Server. Using another examples (ADOMD i ADOMD.NET) result in succeeded connection. Can anyone ...Show All

• Smart Device Development Picturebox resize scrollbars

  Hi. if I have an image showing in a picturebox, of course depending on the image size itself, if the image is larger than the screen, I have told it to resize the picturebox to the size of the image. This is all cool, and shows me the vertical and horizontal scroll bars. problem is, I am unable to scroll through the picturebox. How can I scroll through the picture box so I can view the image When in doubt, never fear, Anthony Wong is here! I believe Anthony has provided a great solution, many thanks to him! http://blogs.msdn.com/anthonywong/archive/2005/05/12/416907.aspx keep up the great work! :-) ...Show All

• Visual Basic radio button help

  hi folks can you help me please.... I have a radio button on my form which plays a tune when clicked my.computer.audio.play ("c:\windows\media\song1.wav", _ radio button.text= song1........ this button can play any song...if the song is renamed song1..... but what I want to do is let the user change the radio button .text to the name of the choosen song...and save it..... so that when the form loads the radio button displays the name of the song instead of song1.... ps....I am stupid so I may need some code thank you so much cheyenne This will allow the user to select a wave file to play and set just the name of the wave file to the radiobutton text: Private Sub Button1 ...Show All

• SQL Server Strange discovery - maybe bug??

  Try this: CREATE PROC tep_test @id int, @verbose varchar(1), @id2 int AS SET NOCOUNT ON SELECT Verbose = '['+@verbose+']' SET NOCOUNT OFF GO EXEC tep_test 1,Y,2 GO DROP PROC tep_test Why does the EXEC not generate a syntax error "Y is not a char" It runs fine under SQL 2000 and 2005. I think it is a bug, my coworkers think it is a feature. Any comments Yeah, I remember calling many procedures like this with no quotes as far back as I can remember. The most typical example where I might do this would be with system procedures: sp_help tablename I would never do it in production code, but I know that I do this often with system object because it is a real pain when I started using schema ...Show All

• Visual Studio Express Editions VS2005 Express Edition - Commercial Use

  I have downloaded Visual Studio Express Edition from a forum and have not registered yet. I would like to use it for commercial purposes. Can I use it Would like to know are there any legal obligations. Thanks in advance cheers aby ----------------- Thanks Brendan, I have already gone through the FAQ's but for conformation I just posted. Anyways It was really great to hear from you. Thanks once again. Regards Aby ...Show All

• Visual Studio Team System TFS Builds and work items

  Is there any way to get TFS to create a seperate work item for each build error and or warning I hate having to trrack back the bug to the build report then magically I close one work item and all the errors in that build are fixed I would like to be more granular. That blog looks very interesting and my solve my problems but, perhaps my TFS isn't working right When I do a TFS build and the build has errors or warnings I get one single work item, all that is contained in that work item is some basic information about the build and a link to the build log which lists the errors. What I want is a work item or bug item to be generated for each error and or warning that occurs during ...Show All

• Visual Studio Express Editions Saving JPEG to Data File

  Hi All-- I'm stumped again. I'm writing a program and I need to save jpeg data IN my data file. I want to have a self-contained data file that contains the image data for two jpegs and some other bits of information. My original idea was to use an XML file to save my data. I can't seem to figure out how to save the raw jpeg file data to a file. I can save the pixel color info to a file, but it's pure uncompressed data. The nice thing about the jpeg file is that it's compressed. An uncompressed BMP might be 10MB while a compressed JPEG might only be 100K. I want to save the jpeg data to my data file because I want to keep my data file size as small as possible. Is it possible to save the raw (compressed) jpeg data to a different ...Show All

• Windows Forms Counterfeiting

  hi i am very annoyed that i am told by my computer that i may be a victim of software counterfeiting and that i have copied windows... which i havent. i have had my laptop for 2 years and now when i turn it on same as usual it says i have been a victim of system counterfeiting. it says this in the bottom right hand corner in a blue star which, when i put the mouse ontop of it it says 'you may be a victim of software counterfeiting'. i would like to know what this means and how i can cure it thanks matt912 There are plenty of internet articles about this. Try here: http://www.microsoft.com/resources/howtotell/en/counterfeit.mspx ...Show All

• SQL Server HTTP EndPoint with RAW XML output

  Hi there, At a project we used to use SQLXML 3.0 with SQL 2000. We're now upgrading to SQL 2005 and want to use HTTP EndPoints to migrate from SQLXML. I'm looking at T-SQL to create a new HTTP EndPoint, using "FOR SOAP { WebMethod" to create the endpoint. Reading the manual, I'm looking at FORMAT=NONE to surpress everyhting SOAP. We want RAW xml here, no SOAP. But the WSDL schema doesn't return any method now. Any idea what to do next Thanks Well, what I actually want is this... We now use SQLXML 3.0 on SQL-Server 2000 and output this in an HTTP stream of plain XML to our client applications. I'd like to know if we can use sql-server endpoints to get the same result. In other words, ...Show All

• Visual Studio KB 926601 for Visual Studio 2005 SP1 is Not Available

  Anyone know why KB 926601 is not available http://support.microsoft.com/kb/926601 FYI: This is the KB containing info on VS2005 SP1 and the reference is listed under VS2005 menu: Help > About Microsoft Visual Studio under Installed products select: Microsoft Visual Studio Edition - ENU Service Pack 1 (KB926601) and under product details: This service pack is for Microsoft Visual Studio 2005 Edition - ENU. If you later install a more recent service pack, this service pack will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/926601 _________________________________ I was looking for info on Web Application Project (WAP) project template that I read was included with SP1. I could not find a WAP ...Show All

• SQL Server Unable to create a function by using symmetric encryption

  Msg: Invalid use of side-effecting or time-dependent operator in 'OPEN SYMMETRIC KEY' within a function. "open symmetric keys" is not allowed in a function if I want to encrypt a string in a function by sql2005's internal functions ,how can I do As the error message indicates, OPEN SYMMETRIC KEY is an operation with a side effect (i.e. it affects the current session’s key ring) and user defined functions (UDFs) cannot have such operations in the body. You can create a UDF using EncryptByKey in it and call OPEN SYMMETRIC KEY before calling the UDF. -Raul Garcia SDE/T SQL Server Engine ...Show All