JohnBurns007's Q&A profile

• Architecture Calling Biztalk Rules Engine Remotely

  I want to know if we can call the BRE from custom code (.NET API) remotely Lets say, The BRE is installed on Biztalk server. And I have an Asp.NET Web Application on a different IIS Server. Can I invoke the BRE from this ASP.NET web application If service is located on web server, Biztalk Framework should be installed on webserver to refer Microsoft.RuleEngine.dll. ...Show All

• SQL Server ADOX problem...?

  I need to rename tables in code VB2005 (access database). On the forum I found post about ADOX and this code to rename the tables: Private Sub RenameTables(ByVal sTextToRemove As String) Dim i As Integer Dim dbRename As Database Dim Connect As New PrivDBEngine dbRename = Connect.OpenDatabase(tbDBPath.Text) dbRename.CreateTableDef() For i = 0 To dbRename.TableDefs.Count - 1 If dbRename.TableDefs(i).Name.Length >= sTextToRemove.Length - 1 Then If dbRename.TableDefs(i).Name.Substring(0, 9) = sTextToRemove Then dbRename.TableDefs(i).Name = dbRename.TableDefs(i).Name.Substring(9) End If End If Next i dbRename.Clos ...Show All

• Windows Forms TableAdapter and Commandtext... Help please.

  Dear, I have a Typed DataSet in which the instructions exist INSERT, UPDATE and DELETE for my table using a TableAdapter. I would like to know like me access the instructions existent DML in this TableAdapter, as for instance: string temp = ((SqlDataAdapter)ProductsTableAdapter). InsertCommand.CommandText; How do I make that Thanks! Alessandro. Tks! I will try to simplify. Like me I do access the object SqlDataAdapter through TableAdapter Example: ((SqlDataAdapter)ProductsTableAdapter). InsertCommand is that possible Alessandro. ...Show All

• Visual C# Compiler Issue?

  In chapter 20.6.5 of the language spec it states that the following statement:- F (G < A, B >> 7); should be interpreted as a call to F with 2 arguments. ie 1st argument is G < A, 2nd argument is B >> 7 However when you compile such a statement you get the error error CS0019: Operator '>' cannot be applied to operands of type 'method group' and 'int' which implies the compiler is treating the call to F as 1 argument ie G<A,B> > 7 Below is a silly example proving the point:- public class DoATest<A> where A : class { class B { }; public void SomeTest() { // Line as in 20.6.5 of language spec // error CS0019: Operator '>' cannot be applied to operands of type 'method group' // and 'int' // ...Show All

• SQL Server Encryption Varbinary Length

  Using the new encryption included in SQL Server 2005, what is a good way to determine what length I should use for the column   For example, I am encrypting a column, its maxlength is about 30 characters, but when encrypted, the encrypted value extends from between 50 and no more than 68 characters- So if I had a column with a max of 500 or so characters, how could I know what varbinary length I should set it to if I were to encrypt it, without actually finding the highest value I could possibly fit into the field Is it good practice to just make it a varbinary(max) field -rob Raul, thanks for the solution on encrypting large amount of data. We have tried your approach on some BLOBs (e.g. ...Show All

• SQL Server Connection Issues To Report Services

  Hello all, I just installed the SQL 2k5 standard suite of services on a w2k3 enterprise edition server. All went well except for the connection to the reporting server. I get the error below. "No connection could be made because the target machine actively refused it" I can't seem to find any information on this error and have no clue where to even start. I've done 10+ installations of this software on various machines and have not encountered this error on any of them. I have uninstalled, then reinstalled the reporting services and still no solution. All connection attempts are being made on the actual server, not from a desktop. sp1 for sql 2k5 is also installed, if that helps. Windows Firewall is off. What w ...Show All

• Visual Studio Express Editions geting numeric data in and out of text boxes

  Hello, Summary: How do I set up text boxes so that when I enter numeric text in one box (named X_Test_Input) , it will raise events that the other box (named X_Accel_Raw_Value) will collect/consume and display the data in that second box. Overview: This is my first attempt Windows programming. My goal is to collect six numbers from an embedded device over Ethernet (five to ten times a second) and display them on my computer so as to have them available for further processing. In dividing this into small steps, I first want to be able to get values from somewhere and display that data. Only after I get the basic windows display part of this working will I attempt to get the data from the embedded device. In my ...Show All

• SQL Server Changing SQL 2005 Password Policy not working

  I have modified the Security Settings>Account Policies>Password Policy on my PC as follows: Minimum password length: 10 characters Password must meet complexity requirements: Enabled However, when creating a login within SQL Server 2005, which does not adhere to the amended policy, this does not seem to be taken into account: CREATE LOGIN testlogin WITH PASSWORD = 'a' , DEFAULT_DATABASE = [master] , DEFAULT_LANGUAGE = [us_english] , CHECK_EXPIRATION = ON , CHECK_POLICY = ON have tried restarting the SQL Server and rebooting the PC, but this does not solve the problem. Which server operating system are you running on There are different rules for this setting ba ...Show All

• Visual Studio Express Editions Finding memory leaks

  I know that VC++ Express Edition has a memory management when running an application in debug mode. There is a part on the debugging output that says "Detected memory leaks!" so, I guess, my application has memory leaks. The problem is that the next lines aren't any helpful, I don't really understeand what they mean. I've seen, not sure where, searching about debugging functions in VC++, a struct that has the members Line and File, between some others. I'm pretty sure that they was referred to the file and line where an object is created. I think that there is some way to know on what line and what file the undeleted object was created. I just don't know how. Check this thread ... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Engines that are compatibility with the XNA Framework?

  Hi there, I got some questions about the compatibility of the XNA Framework with 3d or game Engines. By now where are a Team of 7 Student of the Games Academy producing our game with the trinigy Vision Engine and the Standard Visual Studio 05. -> www.project-barcode.com My main questions is if its possible to combine the trinigy vision engine and the XNA Framework Our Programmers got experiece with c# are are not used to create games on it. Whats the overall state of campatibility with engines and the XNA Framework Thanks a lot, Greez. I'm not familiar with that engine, but if you consulted the MDX -> XNA migration guide, you should be able to port most, if not all, of the engine over ...Show All

• Visual C++ Visual Studio 2005 relative paths

  Hello folks I know this is a litlle bit unusual question, but I just installed visual studio 2005 and my converted solutions from 2003 are fine. But when I create a new project using 2005, my additional include directories are messed up. I cannot use relative paths anymore and instead of showing relative paths from my project, it shows the Visual Studio path, i.e : .\1033\..... Btw, the relative paths created in the converted solutions are ok. Anyone had the same problem Thanks in advance Thanks arashikage, It would be great to log the issue at http://connect.microsoft.com/Main/content/content.aspx ContentID=2220 once you encounter it.Thank in advance for taking the time to report it. Also, please ...Show All

• Gadgets "Access is Deined" error on IE7, but works fine on IE6

  My gadget needs to contact two URLs to retrieve XML content (not SOAP, just URLs that return XML). The first one is internal URL (not accessible from public) and I used {proxy:"none"} when creating network request; the second URL is public and I used {proxy:"generic"}. The gadgets is uploaded onlto galleryd.live-int.com, During test, everything seems fine when I use IE6 on an internal PC (of course with the trusted site and cross-domain settings changed). However, when I switch to an IE7 (on Vista) internal machine, even after changing the settings, it kept giving "Access is denied" error. I also tried adding the regedit trick found on the old forum, but it didn't help: [HKEY_CURRENT_USER\Software\M ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Cannot Display Graphics

  When I tried the tutorial for 3D graphics, but whenever I run it, it tells me that "Both a valid vertex shader and pixel shader (or valid effect) must be set on the device before draw operations may be performed." Can anyone tell me what's going wrong Also, with the 2D graphics tutorial, when I run the program it tells me that the following method is "Invalid:" spritebatchA = new SpriteBatch(graphics.GraphicsDevice); Can anyone help me I'm very confused. You might want to look at the info here . ...Show All

• Windows Forms How to Test Whether Window/Form Open - Restart of Thread

  I started this thread a few days ago, but never resolved the issue, so I'd like to try it again. We are preparing to upgrade an app from Access to C#/SQL Server. We want to allow the users to have more than one window, or form, open at a time for selected forms. For example, it's pretty common that they have both the supplier and parts screen open at the same time refering back and forth. For this reason a dialog form does not work. So the idea is to open the window the first time it is called from the main menu. If it is aleady open behind another window or is minimized, I'd like to bring it to the front. Here is the abbreviated code controlling opening and closing the window. It works the first time the mileage window is opened ...Show All

• SQL Server Report Manager Error

  I have seen this issue in other posts, but I've never seen a way to fix it. When I try to access the Report Manager, I get the following: Server Error in '/Reports' Application. OK, I see my version of this file in: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin Do you see "your" copy here (the log says it's trying to find it there -- ): URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.2/Reporting Services/ReportManager/bin/ReportingServicesWebServer.DLL Also, what users have permissions to get into this folder ...Show All