Mark Freeman's Q&A profile

• Microsoft ISV Community Center Forums User-defined Excel Input Thoughts?

  Well all, I've got a problem with an excel macro.  I have two seperate data sets that are recorded into basic worksheets on excel. However, I need the text in the first row of cells changed to a user defined name, and I need a description or units for that name in the cell below it. It would be helpful if the user didn't have to change this data in the code itself each time different data is recorded. For ex: Have a list where the user inputs what they want to change in an excel worksheet, then take that to change the text in another worksheet. Maybe a ActiveX control in a seperate worksheet would wor ...Show All

• Visual Studio Team System No effect of "define _CRT_SECURE_NO_DEPRECATE 1"

  For the moment I want to suppress all the deprecated insecure functions during static code analysis.  I've added this line in two separate files that get included in all source files: #define _CRT_SECURE_NO_DEPRECATE 1 to no effect -- the output still contains warning of these functions.  A colleague has resorted to #pragma to supress these warnings.  I'm curious as to why this doesn't work as documented in the help. Thanks. Sample warning: foo.cpp foo.cpp(18035) : warning C4996: '_wfopen' was declared deprecated c:\program files\microsoft visual studio 8\vc\include\wchar.h(827) : see declaration of '_wfopen' Message: ' ...Show All

• Visual C# probs with space in textbox ?

  hi i am making and app to open patch then save a file also it has an iso compressor external program that i would like to use. everything works fine until i have a space in the filename or folder path ie when passing the parametrs to the exe in a cmd window you would type say test -a -b input.iso output.iso my code is ProcessStartInfo startInfo = new ProcessStartInfo ( "C:/whatever.exe" ); startInfo.Arguments = "-w -l "   + textBox2.Text + " " + textBox3.Text; Process .Start(startInfo); textbox2 is the input file textbox3 is the output file everything works fine if the text box values are say c:\test\test.iso b ...Show All

• SQL Server Custom Log Provider - Notification Services

  Hi... I am trying to do custom log provider that will post events to Notification Services...The idea is that if I could post the "SSIS events" to Notification Services, with a Custom Delivery Channel in NS, I would be able to do NS Subscriptions with real time monitoring of SSIS packages.. I have tried to use the sample custom log provider code in MSDN. The problem is after I added the custom log provider dll to the C:\Program Files\Microsoft SQL Server\90\DTS\LogProviders folder and install to global assembly using gacutil... The custom log provider is not showing up in the Provider Type under Configure SSIS logs... ...Show All

• Windows Forms searching access dbs...

  Hi, I'm using an Access DB to store some info... With my app I can add, delete and edit records in that db, but how can I search for a record  My db uses an ID as a primary key, how can I search the db giving another field (name, for instance) Oh, and another thing: is it possible to do this without using a DataSet Thanks ...Show All

• Windows Forms Intellisence drop down box..comments yes..

  What i did is a CLASS file with all my functions and methods in to it, but i was looking a way to add comments or a brief descriptions just like VB.NET do when you create a instance to a object and using is method or properties. you know if you have 3 times a method with the same name inside a class but with diffirent paramete ...Show All

• Windows Forms Webbrowser control with Flash Website problem - PLEASE HELP

  Hello, I've got a VS.NET 2005 (VB.NET) Winform App that has a webbrowser control on it. I can open a web site just fine with it and can even open websites that utilize flash just fine. The problem is this:  After clicking around for a VERY brief time inside of a flash file within the webbrowser control, the mouse clicks don't seem to work inside the flash movie.  They work for a little while, but very soon after, quit working.  Mouseover events in the flash file seem uneffected.  To remedy this, I must click outside of the flash movie (still inside the webbrowser control) then clicking withing the flash movie contin ...Show All

• SQL Server Installation of SQL Express from my MSI

  I've written an application that needs to also deploy SQL Express.  In the MSI for my application, I want to install SQL Express.  The problem is that when I call sqlexpr.exe, I eventually get an error that it can't install because another instance of MSI is currently running (my instance).  I've seen posts on doing silent installs of SQL Express by extracting the setup package and calling setup.exe directly with a modified settings file, but this still does not solve my problem that it will start up a new instance of MsiExec.exe.  I think that I need to do a nested install of the SQL Express MSI from my MSI.  I've f ...Show All

• Visual Studio 2008 (Pre-release) ws protocols used in duplex contracts

  Hi Which is the ws-* protocol used to offer the duplex contracts in the wsdualhttpBinding Thanks in advance Javier Really all the WSDualHttpBinding is is a pair of one-way messages, the first from the client to the server and the second is from the server to the client. This can also be done using the NetTcpBinding as well due to its inherently duplex nature. It support all the WS specs as the other bindings do (WS-Security etc). Thanks, Scott ...Show All

• Visual Studio Blank MSDN Explorer

  I have installed a RC version of VS Team Suite along with full MSDN installation. After completing installation, I'v got " Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.MSDNQTR.v80.en' is invalid " error when I have tried to access it by doing "Start" -> "All Programs" -> "Microsoft Developer Network" -> "MSDN Library for Visual Studio 2005" When I accessed it from VS 2005, it only have SQL help available. I have tried to reinstall it several time but no luck. Any help would be appreciated. Eric I have the same problem, except tha ...Show All

• .NET Development whats xml?

  and how can i use it or how can i understand at which points or programs i can use xml Its a way to store data. For example to save it somewhere or to pass it arround. XML has structure tags and content. The content is surrounded by the tags. Tags can build a hirarchie. Lets see this very simple XML called Friends.Xml that I create now: <Friends> <Person> <Name>Peter</Name> <Age>29</Age> </Person> <Person> <Name>Slomczyk</Name> <Age>34</Age> </Person> </Friends> Do you see that there is a root eleme ...Show All

• .NET Development EncryptedXml.DecryptDocument - Unable to retrieve the decryption key

  I have tried a sample program which does the following: 1. Use Makecert.exe to create a certificate on Machine1 a. makecert -r -pe -n "CN=XML_ENC_TEST_CERT" -b 01/01/2005 -e 01/01/2010 -sky exchange -ss my 2. Run a winform client on Machine1 which encrypts the contents of an xml file (stored on the Machine1) which uses the above certificate. 3. Export the above certificate using mmc and store the .cer file on an another box Machine2 4. Copy the encrypted file to the other box Machine2 5. Use the same client (there is another option to decrypt in the same client app) to decrypt t ...Show All

• SQL Server dbms_utility.get_time equivalent in sql server

  Hi, I need to convert the following oracle syntax to sql server: timevar number; timevar := dbms_utility.get_time; This prints : 50989467 I aware of the function getDate() or current_timestamp but they display only the dates and if I convert them to float then the results are not same. Any pointers will be appreciated. Srik As far as I know, there is nothing directly equivalent to dbms_utility.get_timedbms_utility.getime  in T-SQL.  You will need to synthesize it using the technique shown in the prior post or you will need to cast the datetime bits using an expression like this: select cast(c ...Show All

• .NET Development Typed DataSet and WriteXml question about Namespace

  Ok, I have a typed DataSet that was generated from an xsd schema using xsd.exe. The xsd schema is owned by a standards organization, so I can't modify it. The generated code sets the Namespace property of the DataSet (e.g. http://www.std.org/xml/name-space ). This controls the scope of elements read from an XML file when calling ReadXml and the file is read correctly with appropriate rows populated. Now, if I turn around and call WriteXml the typed DataSet creates a root element based on the DataSetName property, which is Ok. However, I get the namespace attribute on this element. (e.g. <MyDataSet xmlns:xsi=" http://www.w3c ...Show All

• Visual Studio Express Editions Northwind and Pubs databases

  Am trying to find where to get a copy of the Northwind / Pubs SQL databases.  Have found the scripts, but can't seem to make them work properly.  Have been able to find a copy of the access version, but am wanting to get into SQL. Any help You can use the osql utility to install them OSql -SServerName -E -iinstnwnd.sql OSql -SServerName -E -iinstpubs.sql http://msdn.microsoft.com/library/default.asp url=/library/en-us/tsqlref/ts_north_2ch1.asp ...Show All