Andre's's Q&A profile

• SQL Server Old FSO snippet of code

  Hi everyone, Does anyone has ever written VbScript .Net stuff which do anything like that I've got a dtsx package and I'd need covering along folder looking for subfolders and so on objFSO = CreateObject( "Scripting.FileSystemObject" ) objFolder = objFSO.GetFolder( "c:\test" ) colSubfolders = objFolder.Subfolders For Each objsubfolder In colSubfolders ... ... Thanks in advance and best regards, The .NET Version of this would be. Dim Directories As String() = System.IO.Directory .GetDirectories("C:\test") Dim I As Int32 For i = 0 To Directories.Length - 1 Dim TmpInfo As New System.IO.DirectoryInfo (Directories(i)) TmpInfo.Delete(... Next Links embedde ...Show All

• Visual Studio 2008 (Pre-release) All I want for Christmas is a XAML translater

  I keep finding myself asking questions in this forum about how to express some piece of XAML in code, or how to implement some piece of code in XAML. Are there any tools out there to assist with this How accessible and human readable is the code generated by the XAML compiler You can build an object tree in c# and serialize (limited, see doc) it out to xaml. You can deserialize the xaml back to the object tree but cannot recover the c# code to create that object tree. see XamlWriter ...Show All

• Visual Studio Express Editions the problem of error LNK2019

  Hi Is there any one hwo can tell me how to fix this problem Thanks 4-2.obj : error LNK2019: unresolved external symbol "public: __thiscall ParametersConstant::ParametersConstant(double)" ( 0ParametersConstant@@QAE@N@Z ) referenced in function _main Somewhere in _main a function named ParametersConstant::ParametersConstant(double) is called, the compiler found the function declaration in a header file, but could not find the definition in a source file, this means you probably need to link with a library which contains the compiled source for this function, or add the source to your project. Unfortunately i dont know where this function comes from so cannot suggest where the body of ...Show All

• SQL Server The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid

  Hello, I am getting the following warning in the Application Event Log: The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid. The warning is logged by the SQLBrowser service. This is happening on Windows 2003 server with SQL Server Express 2005. On the same machine SQL Server 2000 is installed. I am currently unable to connect from remote clients to the instance of SQL Express and I believe it has to do with this warning (I've tried all the usual remote connection troubleshooting without success - enabled protocols, SQL Browser Service running, there is no firewall on the server, I disabled firewall on the client when trying to connect). Does anyone know how to resolve this iss ...Show All

• Visual Basic How do I rename a file in VBA

  Hi I have an excel sheet that contains data. as per the data form one perticular cell. i need to rename a wave and a word file. Is this possible in VBA. Thanks Riya I think this will do what your looking for Public Sub RenameFiles() Dim bTest As Boolean Dim iCtr As Integer Dim OldFile As String Dim NewFile As String bTest = True iCtr = 3 Do While bTest = True If Worksheets(1).Range("A" & iCtr).Value > 0 Then OldFile = _ "C:\TestFiles\" & Worksheets(1).Range("A" & iCtr).Value & ".wav" NewFile = _ "C:\TestFiles\" & Worksheets(1).Range("D" & iCtr).Value & ".wav" Name OldFile As NewFile Old ...Show All

• SQL Server We have a new white paper on Connectivity!

  Dear Forum Members, We've been working on a white paper targeting SSIS connectivity which we hope will help answer some of the key questions in the following areas : What are the SSIS components and their support level for ADO.NET, ODBC, and OleDB How to deal with 64-bit connectors what is supported, what is not Special sections on popular data sources such as SAP, Oracle, DB2, Flat File, XML. A comprehensive list of data sources and available connectors from Microsoft and other 3rd parties. You'll also find answers to why some of the things are the way they are today. Note that this white paper is currently under official editing and publishing in Microsoft. It'll be a while before it goes public off ...Show All

• Visual Studio Express Editions Need Help writing a program for cosine

  I am in a computer course where we have to calculate an angle in radians and somehow use a factorial, taylor series. Were supposed to use a while or do while loop. heres what our debug should look like Enter number .23 Enter the number of significant digits 5 The cosine of 0.23 is 0.97367 Thanks for any help, Ben    See this if you want to do it the long way.>> Sin equation is in there, i think you could add 90 degrees or pi / 2 radians then use the sin equation.>> http://en.wikipedia.org/wiki/Taylor_series  Use  Math.Pi as it is built in or 22 / 7 or 355 / 113. Good luck. ____________________________________________________   Here you go. >> A ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Making Properties editable in the Properties Window

  Hello everyone, I created a new GameComponent which has a XNA.Framework.Rectangle as a property. I added one of these objects to my Game instance, but can't edit the Rectangle property (it is grayed out). How can I write a property (or class) in a way that would make it editable in the Property Window One solution I found was to make a number of Int properties that redirect to be member variables of the Rectangle. This is a bit clunky, though. I would like to be able to expand and edit the Rectangle property instead. It is not specifically Rectangle that I am interested in, as I would also like to make classes that I have created be able to be edited as properties as well. Does anyone know how I can do this Are there any tutorials out the ...Show All

• Smart Device Development Start VB Program unfocused

  I'm trying to write a VB program for a Pocket PC. When I run the program, I do not want any type of FORM to come up. Or Even better would for it to go into the Tray just to show it is running. Does anyone know of existing code i can look at to get this to work If I can just get the program to run without opening the Form1 window that would get me moving, and I could worry about making the Tray Icon stuff later. Thanks, You can hide the form from Activated event: Me.Hide ...Show All

• Visual Studio Tools for Office Outlook: MAPI fields versus User Properties

  Hi, I want to improve an outlook addin which is using mapi fields (a lot) and this is generating abnormal behaviors in outlook, so now I'm in doubt to quit all use of mapi fields fo User Properties but I need some recomendatios or comments about using "mapi fields vs user properties" (or viceversa). Thanks, Mauricio. ok, I post one method of many which I'm using: Public Shared Sub CampoOculto_Agregar(ByRef Item As Outlook.MailItem, ByVal Campo As String, ByVal valor As String) Dim lmsg As MAPI.Message Dim lsTest As String If IsDate(Left(Item.BillingInformation, 10)) Then SetCampoOm(Item.BillingInformation, Campo, valor) Else Dim larValor As Array = Array.CreateInstance(GetType(St ...Show All

• SQL Server @louis :: SQL - Cascading Delete, or Delete Trigger, maintaining Referential Integrity - PLEASE HELP ME!!!

  I am having great difficulty with cascading deletes, delete triggers and referential integrity. The database is in First Normal Form. I have some tables that are child tables with two foreign keyes to two different parent tables, for example: Table A / \ Table B Table C \ / Table D So if I try to turn on cascading deletes for A/B, A/C, B/D and C/D relationships, I get an error that I cannot have cascading delete because it would create multiple cascade paths. I do understand why this is happening. If I delete a row in Table A, I want it to delete child rows in Table B and table C, and then child rows in table D as well. But if I delete a row in Table ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Ray intersection with an octtree scene manager?

  I'm developing an Octtree Scene Manager for XNA Game Studio Express, which is almost ready to release once I have a codeplex project for it. I have a question for the people on this forum about a feature. Should I add Ray or LineSegment intersection testing (which I think would be must faster than some other methods) or should that be left to some other collision testing components An octree (in this case a "loose" octree) is very fast at finding ray intersections with areas (cube), but I'm trying to decide if it is the responsiblity of an octree to do this or should it just worry about display issues. What do you think For a spatial subdivision structure to be useful, then the users of that structure need t ...Show All

• Visual Basic Project-Properties-Settings Question

  My application connects to sql express with a connection string. Question is, in the settings connectionstring, There are 2 choices. 1. Use Windows Authentication. 2. Use SQL Server Authentication. If I use #2 (Use SQL Server Authentication), and enter a Username and Password....Does that mean that the login must always use the same Username and Password ...Are they hardcoded...Can I use a variable ..If so, how I'm not sure what item in list I should add the connection string to. I went to Properties-Data-(ApplicationSetting)-(PropertyBinding)..looked at list ...Show All

• Visual C++ Can't optimize my project

  I want to optimize my project's size, so I selected the Minimize size (/01) option, but I can't compile it: cl : Command line error D8016 : '/O1' and '/RTC1' command-line options are incompatible What can I do The /RTC1 compiler option means "Enable run-time error check features". It seems that this option cannot be specified together with "Minimize size". Therefore you have to disable it. It can be found at Project Properties --> C/C++ --> Code Generation --> Basic Runtime Check . Change this value to "Default". I hope it helps. It seems that you are trying to optimize your program based on "Debug" compiler configuration. In my opinion it is better first to ...Show All

• SQL Server Processing failures result in hangs - "Canceling process operation. Please wait."

  Whenever I process a cube and it fails (usually because of referential integrity issues and me forgetting to ignore errors), I'll click "stop", but the dialog will hang with the canceling notice. The only way I've discovered to get around this is to restart the SSAS server, but it just feels like I may be corrupting data or something by doing this. Is this a known issue Are there better ways of working around this Also, what are the best ways to debug the RI issues that typically cause cube processing to fail They way to solve this problem, in short terms, is to add dummy dimension members like "Not applicable" i each dimension have use this member as a fact dimension key when the d ...Show All