Northwester's Q&A profile

• SQL Server Sql 2005: Encrypting "data in motion" between client and server

  Right-clicking "Protocols for MSSQLSERVER" under the Sql 2005 Server Configuration Manager I find the "Force Encryption" option. Right-clicking the SQL Native Client Configuration, Client Protocols, I find "Force Protocol Encryption" I believe these can be used together to force the connection between a client (running the SQLNC client) and a sql 2005 server to be encrypted. In other words, the data "in motion" can be encrypted. 1. Is my understanding correct 2. Do I need to use a certificate to make this work TIA, Barkingdog The SQL Server Data Access forum is probably your best option to answe ...Show All

• Software Development for Windows Vista Why do I need to specify a connectionstring for a SqlTrackingQuery?

  Hello, I was wondering why I needed to specify a connectionstring for a SqlTrackingQuery  Because when I created the Tracking Service in the "global.asax" I aready specified a connectionstring. Doesn't the SqlTrackingQuery know where the tracking database is located from the Tracking Service I think that : 1°you don't have to use the tracking service to make a SqlTrackingQuery 2°you can query another tracking database than the database your tracking service is currently running on. Hope this help Serge ...Show All

• Software Development for Windows Vista Web graph of sound file

  HI All, I am working on software based on self assessment learning tools. In this the user will heard a .wav file and record it in own wise. Now I have to compare these two file. How I can do it How can I make the web graph of these two file. This will not be a simple task. While it is possible to retrieve the audio data from the two files, doing the actual comparison is a non-trivial exercise. ...Show All

• SQL Server Unable to Install SP1

  Microsoft Update tells me it is unable to install SQL Server 2005 Service Pack 1 (several times). When I check the Update History, I see that Error Code: 0x2B18 is returned. However, I can't find out anything about this error code and it just tells me to retry installing the update. I also tried downloading an update from MS Downloads to attempt a manual installation, but that failed as well. I'm dealing with a newly migrated instance of Windows Small Business Server 2003 Premium R2 on a new HP ML350 G5 Server. Any helpful suggestions would be appreciated. Can you guys search through your hotfix error directory (search all files) for the text string "value 3" This appears shortly af ...Show All

• Visual Studio Tools for Office Populate pivot table with pre selected items.

  I have populate a pivot table using C#.net. I have used analysis cube as source of the pivot table. Now by pivottable.MDX property I got the mdx which indicates what items I have selected from the pivot table page fields. I saved the MDX and closed the excel. In my pivot table I have only page fields and one data field. Now I want to repopulate the same pivot table where only pre selected items are selected and others are unselected. I want to do this programmatically. I am using VSTO 2005. How can I do this I think your question could be better answered by the folks over in the Excel newsgroup. At this level you are working directly with the Excel PIA, and that is something that VSTO has little influenc ...Show All

• Windows Forms Webbrowser Document --- Iterating through all the Frames and the controls in it.

  All, I am having a Webbrowser component inside a WinForm. What I want to do is: Navigate to some of the specified page. If that page contains more than one frames, iterate through all the frames and for each frames iterate through all the Controls in it and display the control name and frame under which it comes. But, when I try to do this, I am getting an Access Denied error. Is this because Cross-Domain Data Access is prohibited If so, how I can solve my problem Dont we have any way to supress that Please help me in this regard. ------------------------------------------------------------------------------------------------------------------------------ Form1.WebBrowser.Navigate( "http:/indiatimes.com" ); HtmlWin ...Show All

• Visual Basic problem of controls array in Visual Basic 2005

  Hi: I wrote a project in vb6.   That project contains controls array and I want to upgrade this project to vb2005 but I have some problems. In vb6:       I have array of checkbox When the user check the checkbox   It's index = I as integer   then Create 3 elements in 3 arrays of combobox All this elements have the same index     When I want to determine any combobox by the index of checkbox I will write code like this:       For i = 0 To Check1.UBound         If Check1(i).Value = vbChecked Then              &nb ...Show All

• Audio and Video Development How to disable default key handler?

  I have following problem: My HD-DVD App contains some buttons. By default I can move between buttons use arrow keys. I want make own key handler for moving between buttons. I want to use own algorithm for move. I make following code: addEventListener("controller_key_down", keyHandler, true); function keyHandler(evt) { var disableDefaultKeyHandler = true; switch (evt.key) { case 38: // VK_UP // My Key Handler break; ... default: disableDefaultKeyHandler = false; break; } if(disableDefaultKeyHandler) { evt.stopPropagation(); evt.preventDefault(); } } But sometimes default key handler is called and focus moves to incorrect button. I think that my key handler(keyHandler function) so ...Show All

• SQL Server SQL Server 2005 SP1 Failure - 'dm_exec_query_resource_semaphores'

  Hi Sam, In my case, the components in sp1 were installed successfully except the database engine. And the following messages were captured from the setup log. Please advise me. Thank you in advances, Kasemchai ---------------------------------------------- Action start 15:24:23: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> MSI (s) (5C!10) [15:24:23:494]: Transforming table _sqlAction. MSI (s) (5C!10) [15:24:23:494]: Note: 1: 2262 2: _sqlAction 3: -2147287038 MSI (s) (5C!10) [15:24:23:494]: Transforming table _sqlAction. MSI (s) (5C!10) [15:24:23:494]: Transforming table _sqlAction. MSI (s) (5C!10) [15:24:23:494]: Note: 1: 2262 2: _sqlAction 3: -2147287038 MSI (s) (5C!1 ...Show All

• Visual Basic URGENT!!! - Problem with Windows Service

  hi, I have a windows service which connects to an Oracle database using "System.Data.OracleLcient" When i start the service i get the folling error. Description: Service cannot be started. System.DllNotFoundException: Unable to load DLL (oci.dll). at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection ...Show All

• Software Development for Windows Vista change delay timeoutduration

  Hello guys, I have a state machine workflow, and to create a timer, I used a delay inside an event driven. Is there anyway to change timeoutduration of this delay to a new value, while the instance of the workflow is running, so the timer expires at that new time. I couldn't find any code samples for that. Any help would be greatly appreciated. Please read the thread more carefully, Iris. The problem is in resetting the duration during the execution of the delay activity itself. I am looking into a similar situation (though with only one delay). One problem I have with the existing delay activity is that it is a delay with a Timespan, not a delay until a certain DateTime, which is more apt to ...Show All

• Visual Basic My.Settings Class

  How does one use the MySettings class to save the state of a check box before a program exits When the check box is changed, I save the state of the check box: My .Settings.Item( "Choice" ) = True My .Settings.Save() And then restart the program and call the check box state back when the FORM loads: Me .RadioButtonEnableCH.Checked = My .Settings.Item( "Choice" ) However, it does not recall the check box state correctly – it is always checked. What am I doing wrong Did you mean to say that: My .Settings.Item( "Choice" ) = Me.RadioButtonEnableCH.Checked Because right now, you are always saving TRUE, which means your check ...Show All

• Visual Studio Team System TF31002 unable to connect on 2 different client machines

  We are just starting to roll TFS out at our shop. However, we are experiencing the TF31002 error on 2 seperate client boxes. I have already tried the following with now success. Any suggestions I have seen problems similiar to this. This type of connectivity to the Team Foundation Server problem is usually resolved by clearing the client side Team Foundation Server cache. To clear the cache perform the following: 1. Close Visual Studio. 2. Delete the contents of the folder: %USERPROFILE%\Local Settings\Application Data\Microsoft\Team Foundation\1.0\Cache\ 3. Start Visual Studio. 4. Connect to the Team Foundation Server through the Tools menu Connect to Team Foundation Server option. T ...Show All

• SQL Server Should I use indexes?

  I have a very large table (about 200,000 records), but there are only 2 fields in the table only one populated with data. I need to update the 2nd field with the first field's data. UPDATE Table1 SET field2 = field1 This is taking a really long time to run about 3.5 minutes. Is this normal Can I create an index What can I do to shorten the run time Thanks, Ninel Adam, if you're interested, there's a case study here that may be interesting read. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx /Kenneth ...Show All

• Visual Studio Express Editions MsgBox with multiple lines

  even simple vbnewline and then if you wan the code to be on a new line just add & _ so it would be messagebox.show("hi" & vbnewline & "down here") but if you had messagebox.show("hi" & vbnewline & _ "down here") ' now you should be able to also have a new line in your code to get a better feel of how it will look ...Show All