drewdb's Q&A profile

• SQL Server dependency_Onchange is getting invoked in an infinite loop

  created the datawatcher application mentioned in the site http://msdn2.microsoft.com/en-us/library/a52dhwx7.aspx Replaced the connectionstring to connect to our database instead of adventureworks database. Replaced the query with a "select * from mytable" in getsql method. enabled the sevice broker for the database using alter database mydatabase set enable_broker command. Now when the datawatcher application is executed dependency_Onchange is getting invoked in an infinite loop on clicking getdata button. Where as the application works perfectly for adventureworks database. The example is 'poorly' written. The SqlNotificationEventArgs argument passed to the OnChange cal ...Show All

• Visual Studio Tools for Office Cannot Launch office Word 2007

  Hi all, I have installed Office 2007 Beta but for safety sake i have kept the previous version Office 2003 also. I chose to keep the previous version of Office 2003 instead of upgrading. To my surprise, when i open a doc file, it is getting launched in winword 2003 rather than in Winword 2007 Beta. I tried to automate Ofiice Word 2007 beta. but WinWord 2003 is getting launched instead. Any ideas Will this issue get fixed in the coming releases of Office 2007 Rosh K. Mathews. Hi Rosh I'm sorry, but this forum is for discussing questions concerning the VSTO technology. It's not for general questions about Office 2007. For that, I recommend the newsgroups in this interface http://www ...Show All

• Software Development for Windows Vista how to restart workflow runtime after IIS restart

  My question is for workflow exposed as web service through webserviceinputactivty/webserviceoutputactivity. My impression is that workflow runtime is only started after the first web service call. My test workflow has 3 activities: webserviceinput, webserviceoutput, delay. SqlPersistence service is enabled. The workflow is activitied through a web call. When executing the delay activity, it's persisted to the database. Then I shut down the web server (ASP .NET development server). When the web server restarted, the timer already expired but the workflow was not resumed. Only after I made another call to the web service, the timer fired. I did an experiment in a winform application. When the application starts next time, the timer fir ...Show All

• Visual Basic Controlling the serial port from VB2005

  I made a VB2005 app which is *supposed* to open the serial port and receive data from it (the serial port is controlled by a SerialPort control named com0new). However, it fails with an exception: "UnauthorizedAccessException Access to the port 'COM1' is denied." COM1 is the only serial port my computer has, and I know it is unused when I run the program. The following is the function generating the exception: Function ReceiveSerialData() As String         ' Receive strings from a serial port.         Dim returnStr As String = ""         Using com0new As IO.Ports.SerialPort = _           ...Show All

• Windows Forms Connection String

  I'd like my app. to connect to the DB in the folder that will be in the user's computer when I install it. I don't want to have to change my connection string path everytime I install my app. on a new computer. Using ADO.NET, how do I make my app. to connect to the DB everytime it's run regardless of the app.'s location eg: Dim csWBoard As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Projects\Whiteboard\WhiteboardDB.mdb" Will the above code work If not, what will I would sugget to store connection string in a configuration path of the application. In this case you could configure your application as you wish without hardcoding. It will allow you to move database into ...Show All

• Visual Basic a really wierd situation

  hey guys. i have a really wierd problem. This are the codes i used to implement a login system. Dim sqlconnection As New SqlCeConnection("Data source = \My Documents\busInfoSys.sdf") Dim reader As SqlCeDataReader Dim cmd As New SqlCeCommand("SELECT passWord FROM driverRelation where driverId = '" & TextBox1.Text & "'", sqlconnection) sqlconnection.Open() reader = cmd.ExecuteReader While reader.Read() If TextBox2.Text = reader.Item("passWord") Then MessageBox.Show("Welcome to the Bus Information System!" & vbCrLf & "Drive Safely!") Dim frm As New MenuPage frm.Show() ElseIf TextBox2.Text = "&quo ...Show All

• Visual C# System.Net.Mail

  Hi .. this is RK, Please help me out..... I'm facing problem with System.Net.Mail... I'm getting always "Failure sending mail." message. (In my system there is no anti virus s/w installed) here is the code i'm using... protected void Button1_Click( object sender, EventArgs e) { try { System.Net.Mail. MailMessage mail = new System.Net.Mail. MailMessage (); System.Net. NetworkCredential cred = new System.Net. NetworkCredential (); mail.To.Add( "ramakrishna.burugapalli@softima.com" ); mail.Subject = "subject" ; //Este mail es el que aparecera para mostrar mail.From = new System.Net.Mail. MailAddress ( "ramakrishna.burugapalli@softima.com" ...Show All

• Visual Studio 2008 (Pre-release) Converting Message between soap versions

  Hello, is there a simple way to convert a received Soap11 formatted Message object to Soap12 Looking at the Message.CreateMessage overloads its not clear to me if the MessageVersion I provide has to match what I read in (say, using XmlDictionaryReader), or if it just sets the message version of the created message. Any examples of using this would be great. There's no direct way, but you can use the Message overload that takes a XmlReader (or XmlDictionaryReader) with the body information: Message ConvertMessages( MessageVersion originalVersion, Message originalMessage, MessageVersion newVersion) { Message result = Message .CreateMessage(newVersion, originalMessage.Headers.Action, originalMe ...Show All

• Visual C++ converting tool from vc++ to c#.net

  Hi Guys I had a code which is in VC++ Language.I want that code in the c# Language.Are there any tools which will directly convert VC++ code into c#.net. Thanks in Advance. C++ and C# are just too far apart for a clean conversion, and the libraries they are based on are completely different. I wouldn't even be asking this question. I'd rather look into interoperating with existing C++, and this is an area that is very well supported by Microsoft. Search this newsgroup for issues concerning wrapping your C++ with C++/CLI so you can call it from C# applications. Brian ...Show All

• Windows Forms Simple ComboBox / ListBox property question

  Hi, I can't seem to find anywhere in the help menu how to create a drop-down menu that doesn't allow typing input. To be very clear, I want the user to choose either A, B, C, or D. I do want a drop-down menu (like a standard ComboBox). I don't want the user to be allowed to type anything (like a standard ListBox). Is there a property I'm missing or something Thanks! Mike Change the DropDownStyle property from "DropDown" to "DropDownList". The user won't be able to type in any value and can only choose from your list of items.   msopnet wrote: Hi, I can't seem to find anywhere in the help menu how to create a drop-down menu that doesn't allow typing input. To be very c ...Show All

• SQL Server ANN: VistaDB 3 as world's first managed SQL database engine for .NET and Compact Framework

  VistaDB 3 CTP has been released as the world's first fully managed SQL database engine for Microsoft .NET, Compact Framework, Windows Vista and Mono. Unlike the new SQL Everywhere, .NET developers can use VistaDB 3.0 to build 100% managed WinForms and ASP.NET database applications that run on desktops, mobile devices and web servers. VistaDB's small 600KB assembly includes a built-in ADO.NET Provider, which means that it can be embedded into any .NET application. VistaDB 3.0 also makes mobile development and deployment easy since the same VistaDB 3.0 assembly will run on all mobile devices. Read more: http://www.vistadb.net/Press_060801_VistaDB3_CTP_Released.asp ref=200608forum ...Show All

• Software Development for Windows Vista [BUG] Vista doesn't start application called "install" w/o being elevated.

  Hi, I just encountered this really strange behaviour, which is definitely a bug in Vista. Consider the following situation. You're logged in as an administrator account. Start a CLI shell of your choice, start it normally, so that it's running non-elevated. Now consider a console application called install.exe. It's neither a GUI application, nor is it an installer application in the Windows sense. It's just called install.exe. In my case it's part of GNU coreutils and it's called install because it's usual task is to install software on the system. However, it's perfectly valid to call install as normal user and use it to install stuff into a subdirectory on which you have permissions. This is what happens when running under Cygwin (proce ...Show All

• Visual C# Resume the computation after an exception

  Is it possible to 'fix'in the catch block whatever caused an exception and return to the offending statement in the try block, and try it again After raising an exception, I'd like to try to resume the computation after fixing whatever went wrong. You can use Goto for example, be aware that you must implement some extra logic to only try it 5 times for example so you won't have a invinitive loop: STARTPOINT: try { // Do something } catch { GOTO STARTPOINT; } ...Show All

• SQL Server MS Office Integration & SSIS

  Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS Thanks Shafiq shafiqm wrote: Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS Thanks Shafiq The only way is to use the Office Primary Interop Assemblies (PIM) and do this programatically from a script task. -Jamie ...Show All

• .NET Development ASP .NET Authorization - Easy, Right? Hmmm.. not!

  OK... this should be really simple, right I have a simple web app and I am adding in a check in the web.config file to check to see if the user belongs to a specific NT group... It works fine if I hard code in my own NT ID, but when checking for the NT group, it just gives access denied everytime. Here is what I am doing, this example works fine, web app comes up.... < authorization > < allow users="kroach" /> < deny users ="*" /> </ authorization > However, if I try to check for an NT group instead, it does not work: < authorization > < allow roles ="Domain Users" /> < deny users ="*" /> </ author ...Show All