Zac Boyles's Q&A profile

• SQL Server Install BOL (February 2007)

  I have BOL (May 2006) in my system, do I need to remove to install BOL (February 2007) Is the BOL cummulative No need to as the BOL update is cumulative, http://sqlserver-qa.net/blogs/sqltools/archive/2007/02/24/bol-a-lower-version-of-this-product-has-been-detected.aspx ...Show All

• SQL Server HOW to Retrieve an image from sql server and display it in ASP.net using "imagemap or image" ?

  Ok, the problem is that , i have a field called "Attach" in sql of type image, when selecting it , the field is getting data of type BYTE(). which am being unable to display them on an Image on the panel. using the following vb.net code: 'Dim sel2 As String 'Dim myCom As SqlCommand 'Dim conn As New SqlConnection 'Dim drr As SqlDataReader 'Dim image As System.Drawing.Image 'sel2 = "select * from attach where att_desc = '" & DropDownList1.SelectedItem().Text & "' and doc_code = " & w_doc_code & " and subcode = " & w_doc_subcode & " and doc_num= " & w_doc_num & " " 'conn.ConnectionString = ("server=developer01;u ...Show All

• SQL Server Custom Property for Remove Duplicates transform Input Row

  Im working through the MS example of "removeDuplicates". I cant seem to figure out how to add custom property for input column. I added the helper method: private static void AddIsKeyCustomPropertyToInput(IDTSInput90 input, object value) { IDTSCustomProperty90 isKey = input.CustomPropertyCollection.New(); isKey.Name = "IsKey"; isKey.Value = value; } I call it from: public override void ProvideComponentProperties() { //... AddIsKeyCustomPropertyToInput(input, false); //... } public override void ReinitializeMetaData() { IDTSInput90 input = ComponentMetaData.InputCollection[0]; if (input.CustomPropertyCollection.Count == 0) { AddIsKeyCustomPropertyToInput(input, ...Show All

• .NET Development Generating xml pages using c# in a web service.

  Hi, I can't seem to find anything on the web about this. I am currently working on a web service(server) where a client sents a request to the the web service and the web service responds in an xml format. The tricky bit is this response has to be in a certain format that is compattable with the client. The format is outlined below < xml version="1.0" encoding="ISO-8859-1" > < xml-stylesheet type="text/xsl" href="search/dsp_does_not_exist.xsl" > <wfmcase> <case_details> <caseid>9504356638</caseid> <archive_status/> </case_details> <error_status> <error>1</error> <error_type>Application</error_type> <er ...Show All

• SQL Server Activation proc failed

  Good day, I have send a msg successful,but the proc failed. I altered the proc to correct the problem in the proc. The msg are still in the queue. Is there a manual way to excute the proc again to process the msg in the q or do I wait for service broker to do it after a retry time (self recover) thank you in advance. Okay I followed the steps in the help: "Symptom: Activation Stored Procedures Do Not Run". And discovered that the proc I execute inside the RecieveProc fails. (the proc I exec inside the recieving proc is proc reference a external assmbly) Now my q is if a proc fails and the msg is allready retrieved from the queue, what happens to the msg where does it g ...Show All

• SQL Server Numeric Representation of Data

  In MS Access, for numeric fields, the decimal places shown can be defined as "Auto" meaning that the database will determine the number of decimal places to show based on the content of the field (i.e. 1.0, 0.75, 1.125). In SQL Server for the same field, it appears that decimal precision is hard coded resulting in a fixed representation (i.e. 1.000, 0.750, 1.125) Is there a way to make the decimal representation in SQL Server more like Access where trailing zeros are truncated See SQL Server 2005 Books Online topic: float and real (Transact-SQL) http://msdn2.microsoft.com/en-us/library/ms173773.aspx ...Show All

• .NET Development how to write decimal numbers to Serial Port?

  It seems the method "write" for COM Port has three different constructors. port.Write(string text); port.Write(byte [] buffer, offset, int count); port.Write(char [] buffer, offset, int count); And now I want to write the decimal number between "0" to "30" to the COM port. How should I convert the (int i = 0 ) to the correct format for writing The receiving port should get the decimal number "0"... I tried to use Convert.ToByte(i), however, there is no lenght for the "int count" part... Thank you! Hi, I have problem similar to Pockey's. But I'm sending a value greater than 127, 252 to be exact. I tried doing it your way, but I don't believe that the messag ...Show All

• Visual C++ finding the root path

  Hi, i am working in VC ++ 6.0. i have some problem in hardcoding the path saving the files. My application saves the log files on hard drive (exception handling). for the time being i have hardcoded the path (e.g : c:\programfiles\abc\log) i don't want to hardcode the exact path. i want that my application should save the log files automatically in a folder (application root folder). wherever user installs the application either it should be c:\program files\abc or d:\program files\abc, my log file should automatically pick the root path and save the files in log folder in that root path. Pls help me in doing this. In my opinion, first you should obtain the path of your execut ...Show All

• Visual FoxPro VFP and Outlook Automation

  I would like to implement the following scenerio but can not seem to put all the pieces together. I I have figured out from VFP how create and display a new email but after the user completes the email then clicks send in outlook I would also like to have the option to save this email in .msg format. I am thinking that I need some sort of unique id that I can use to locate the email and then use the saveas automation function the email with the saveas function. Any help would be greatly appreciated Stuart Stuart, Outllook items have storeID and unique EntryID properties (and GetItemFromID method). Below sample is for appointment item but would apply to other items as well: Local ...Show All

• Software Development for Windows Vista WWF Persistance Status

  I have a workflow which having a while loop inside that I have an activity called Handle External Event, which will receives inputs from some windows application. When ever inputs come I used start a workflow and load the workflow for current situations. I have situations like, some time I have to hold the current workflow instance (dehydration) and start new workflow instance. WF internally updates the workflow persistence details into Workflow – DB. When ever workflow executes, I have to store the input values into my application database. So I am calling a database call( call to Data access Layer) from my External activity. The problem I am facing is after updating my application database workflow is not at a ...Show All

• SQL Server Undo Changes in Table Help!!

  I accidentally executed this query Update Table Set Field = 1 Where Date < dt I need to undo this, is there i way to do so Havent touch sqlserver since the execution of that query. Hi Giber, If you are using 2005, you may be able to restore the pages that were affected, however the easiest solution may be to restore the database backup to either another server, or same server but under a different database name. You would then be able to revert to the unchanged/correct table be referring to the restored db backup. Have a look at http://msdn2.microsoft.com/en-gb/library/ms191253.aspx for an overview of backup options etc. Cheers, Rob ...Show All

• Visual Basic Visual Studio 2005 Pro - Academic Version

  I'm thinking about ordering VS Pro from school, but they can't give me details (it's not kept in stock)... does anyone have the academic version and does it require internet regsitration/activation Some people are saying yes, others are saying no. Thanks Any mention of off topic item was evidence and reasoning for this on-topic question. Express products on CDs do not require it - only downloads. I also have the VS standard version CD which do not. I've had these for about a year or so but only since last week I've finally abandoned VB6 Pro for Net.. but now I want to go 64bit Pro. ...Show All

• SQL Server Union problem

  I have follow query declare @z int select id from table1 union select id from table2 i want after union in @z save value 0, 1 or 2. 2 - when first and second select returns any results 1- when one of selects return any result, and another return nothing 0 when both selects returns nothing Can you help me. How i solve this problem Jordan, If you have no where predicate/filter, the entire table is scanned. Also, substring() is your only way to extract data from a blob column. There isn't much we can do there to improve perf. ...Show All

• Windows Forms TreeView show images with only a few nodes

  I have a TreeView with nodes and sub Nodes (only 2 levels). Is it possible for me to display images for the sub-nodes and not the parent nodes I thought of using a transparent image, but that still showed the space where the image needs to be. I think you'll need ownerdraw to do this. Draw the folder icons with Graphics.DrawImage() ...Show All

• Visual Studio Express Editions .dll help

  hello. I will explain my problem I have an application, in that is a webbrowser and I want it to switch to an url on a user specifiet time. but now. I want the code (which I already made) in a remote .dll file (or another one, if you can recommend one) with all the url's it should go to. Example: Select Case timername Case 0 WebBrowser1.Navigate( "URL" ) timername = 1 Case 1 WebBrowser1.Navigate( "URL" ) timername = 2 End Select Why do I want it in a remote So the application can update it when I have an update for the url's and not have to update the whole application. So how do I do that (I don't want it in the resources but in a folder on the hardisk (C)) Note: this application has a use! Umm... y ...Show All