KerryLW's Q&A profile

• SQL Server Can the data viewers display Chinese characters?

  Is there a way to change the font that the data viewer uses, so that the Chinese characters don't appear as boxes The data viewer displays Chinese characters as boxes, something similar to [_], at least on a computer with the following regional settings. get-wmiobject CIM_OperatingSystem | ft OSLanguage, CodeSet, Locale OSLanguage CodeSet Locale ---------- ------- ------ 1033 1252 0409 The data itself is flowing correctly into the target database with a pipeline data_type of DT_WSTR. The ideograms can be seen by query utilities which supports a unicode font (e.g. Management Studio). Yes, follow Tools > Options > Env ...Show All

• Audio and Video Development Any method for MF PVP application fail gracefully if video driver is not PVP signed?

  I am working on an application that runs protected playback with Media Foundation. I've encountered a problem that with some graphics cards, an error dialog box pops up from another process saying " Bad Image: X is either not designed to run on Windows or it contains an error". After repeatedly pressing OK for the same dialog poping up many times, I can see the application hits a debug assertion saying that  ESP is not properly restored. I've read about the following previous thread in this forum and know that this symptom happens because video driver is unsigned and mfpmp.exe failed. "MF_ProtectedPlayback Sample doesn't work for Video on Vista Beta 2: Thread Start ...Show All

• Visual Studio Sandcastle, August CTP Questions

  Just installed Sandcastle today and I already have a question or two about it. First off, let me apologize for the blacked out ports of the image as this is for a product that has not been publicly announced yet. The first question: How do I get a title for the CHM file   If I pull up ADO210.chm, it has a title of "Microsoft ActiveX Data Objects 2.5 (ADO)" rather than "Help". Second question: What does that little warning gif in the document frame window mean   How do I replace it with real content, like the first page of the only namespace in the CHM file Update: Apparently the forum doesn't like rendering out <img> tags.  Okay, here's a link to the image then. Thanks! Rory I'm not sure abou ...Show All

• .NET Development datetime field sql server 2005 updates incorrectly

  I am using vb 2005 expess edition and sql sever 2005 The problem I have is the LastUpdated field which is a datetime field in the database does not update properly the code I am using is Dim cnSQL As SqlConnection Dim cmSQL As SqlCommand Dim strSQL As String cnSQL = New SqlConnection(ConnectionString) cnSQL.Open() strSQL = "update people set LastUpdated = " & DateTime.Now.Date & " where PersonId = 13" cmSQL = New SqlCommand(strSQL, cnSQL) cmSQL.ExecuteNonQuery() this executes with no errors but the database is updated with the same date each time 01/01/1900 00:00:00 I have tried all combinations of the datetime field values with no effect Can anyone h ...Show All

• SQL Server SQL Question

  Hi there, I have these tables: Students student_id (PK) student_name Courses course_id (PK) course_name StudentCourse student_id (PK) course_id (PK) If I want to select a student that has 'course1' and 'course2', how do I write this statement This didn't work: SELECT DISTINCT Students.* FROM Courses INNER JOIN (Students INNER JOIN StudentCourse ON Students.student_id = StudentCourse .student_id) ON Courses.course_id = StudentCourse .course_id WHERE Courses.course_name LIKE '%course1%' AND Courses.course_name LIKE '%course2%' The problem is 'AND'. it concate the two course_name(s) to be like this condition: WHERE Courses.course_name LIKE '%course1course2%' Any idea Thanks SELECT Students.stud ...Show All

• .NET Development Uploading .exe

  Hi all, During the making of a ftp up/downloading program I noticed that the up and downloading of .exe files is not discussed in any sample. Most sample's are about altering deleting or adding text. But what about .exe files, how are they uploaded Could anyone help me with this Thanks in advance, Dexter Hard to tell what you're problem might be, sounds like you're just asking for the wrong file. Here is some sample code, it worked well: FtpWebRequest req = (FtpWebRequest)WebRequest.Create("ftp://ftp.smartftp.com/smartftp/addons/loglevel.zip"); req.UseBinary = true; WebResponse resp = req.GetResponse(); Stream rs = resp.GetResponseStream(); FileStream fs = new FileS ...Show All

• Windows Forms Multi threading

  Hi All. I have a question that im hoping to get a little help/advice with. Im writing a forms application (just local - not web or anything) that calls out to a com dll for data processing. The processing may take anywhere from 1 minute to a couple of hours. So of course I would like to be able to display a progress bar - to the user. I tried muti-threading (background worker) the call to the dll - but that doesnt seem to work - either to any dll or at least a com one. So im wondering if anyone can give me some ideas on how to handle this. Can i use multi threading thats a little more sophisticated than the background worker, or can I make the dll - multi threaded (unsure how or even if this is possible). BTW - I am the ...Show All

• SQL Server Use Variable as Table Name

  I am trying to write a stored procedure that accepts a table name as an argument and then displays all of the columns of the table. My code does not work and I don't know why any ideas set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [selectTable] @tableName varchar ( 50 ) AS select * from @tableName ; I get this error: Msg 1087, Level 15, State 2, Procedure selectTable, Line 5 Must declare the table variable "@tableName". Please help. U need this :: (cant simply put a variable in from clause....gotta make a query string and execute it...dynamic sql) CREATE PROCEDURE [dbo] . [selectTable] ( @ ...Show All

• Visual C++ msvcr80.dll file not found

  When I was running a registry scan with Norton's Systemworks, there were several file associations for Net Framework that could not be made when attempting to access msvcr80.dll. The error message "file could not be found..." Norton's telling me that either the file was hidden in NTFS or was missing. And it says for me to reinstall it. So do I reinstall my operating system or just the dll file And where do I get that dll file Thanks in advance to anyone who can help with this! Bug in SystemWorks probably, check this thread ... ...Show All

• SQL Server Weird toolbar

  I have just installed my server with server2003 enterprise edition, everything is working fine. However, after I make it online for awhile, I found a weird thing on the tool bar just beside the clock. There are 2 hidden icons, when I move the pointer to these 2 icons, it shows the IP address of my server. Just wanna know if there is anything wrong with that. Thanks! tom I don’t know what this is about. Sorry. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# Need Help in developing MS WORD like application

  Dear All, I have seen applications that has tool bar, with different buttons which are same like MSWORD 2003 look like, and when click on one button suppose table button , a list popup which also same like MS WORD 2003, and there are increase and decrease indent buttons, center align, lift align or right align buttons, and its functionality is also same like MS WORD. I want to implement such functionality in my own application, but remember please don’t refer me to MS Visual Studio Tools for Office Development, show me some other way by which I could do so. Refering me to code for downloading office like application will be highly appretiated. thanks I want that there be  create ta ...Show All

• Visual Studio 2008 (Pre-release) DefaultStyleKeyProperty second time

  Adding a new wpf custom control to my project VS creates a template with the following statement in the constructor:. DefaultStyleKeyProperty.OverrideMetadata(GetType(MyControl), new FrameworkPropertyMetadata(GetType(MyControl))) When I added my code and run the control in an app all works fine. But when I try to create an instance of this control a second time I get the following error message: PropertyMetadata is already registered for type 'MyControl'. How can I detect whether the metadata has already been registered My current workaround is a try..catch wrapper around DefaultStyleKeyProperty.OverrideMetadata .. Did the automatically generated code placed the DefaultStyleKeyProperty.OverrideMet ...Show All

• Windows Forms MonthCalendar help.

  I am realy lost here. I am trying to create an MonthCalendar, with an If() sentence. E.g. When date 30/12-2006 is picked, then, lets say, textBox1 should say "Fish". But i just can not figure it out. I have tryed everything, and searched all develop pages i know. Help pleace. I can try to explain what i am trying to do. I need to be able to put in events by updating the program. So that, when clicked on the Bolded date, text about the event shows, in different textboxes etc. But i just cant get it working. I figure it has something to do with the DateTime(Year, Month, Day) But to tricker that, how I have tryed the DateSelected Event, but i could not get it working. Pleace have patience w ...Show All

• Visual Studio Express Editions Display a form

  Hi, I am having some trouble displaying a form, I have done it many times before but this time it is not working: here is my code: helpform frm = new helpform(); frm.Show(); and come up with the following errors: Error 1 The type or namespace name 'helpform' could not be found (are you missing a using directive or an assembly reference ) Error 2 The type or namespace name 'helpform' could not be found (are you missing a using directive or an assembly reference ) Any Help What is the name of your form If it is HelpForm, use this: Above public Form1() HelpForm helpForm = new HelpForm(); Then you use this: helpForm.ShowDialog(); If this doesn't work, make sure the event that it i ...Show All

• Software Development for Windows Vista Subscription service and persistence service

  I've implemented a custom subscription service that inherits from WorkflowSubscriptionService. I have a state machine workflow that's been published as a web service. In my workflow I have a CallExternalMethod activity that sends an e-mail message, and a HandleExternalMethod activity that listens for incoming e-mail. I'm using my subscription service to get the WorkflowInstanceId based on a message ID that I embed in the e-mail message. I've tested this and traced my workflow and everything works. When my workflow sends out the e-mail, it calls CreateSubscription on the subscription service. When the event is received, it calls DeleteSubscription. This would seem to be the correct behaviour. Then I added the SQL persistence service a ...Show All