Ion101's Q&A profile

• SQL Server Cannot configure SQL Server Express 2005 for remote connections

  Hello. I have SQLEXPRESS 2005 installed on my laptop running Windows XP Home Edition with SP2. I have an application that can connect to the local instance with no problem. The other day, I tried to configure SQLEXPRESS 2005 for a remote connection from my desktop. To date, I have been unable to figure out how to do this. I have followed the instructions posted at various locations on the internet, but to no avail. While I can configure SQLEXPRESS 2005 to allow TCP/IP connections, I have been unable to restart the server. Here is the pertinent snippet from the error log: <time> Server A self-generated certificate was successfully loaded for encryption. <time> Server Error: 26024, Severity: 16, State: 1. 2006-08-14 21:02:27.18 ...Show All

• .NET Development Is there a .NEt method equivalent to the VBA function EVAL?

  In VBA the EVAL function evaluates its parameter (a statement in string form) and returns the result. ANSWER = EVAL("IIF A > 6, B * 5,B * 6") I need this capability in .NET. Is there a method in the .NET framework that will let me evaluate a statement presented as a string and obtain the result Thanks No, unfortunately there is no eval-like function in VB.NET. It is possible but you will have to compile a new assembly during runtime. You might want to have a look at Evaluating Mathematical Expressions by Compiling C# Code at Runtime . ...Show All

• SQL Server ssis in sql server express edition

  hi, can anybody tel me how i can install (any component to be instakked) ssis in sql server 2005 express edition it's lok like this edition doesn't support ssis! is' it true Thanks Sandipan Hi, Is there any way we can run an SSIS package from SQL Server Express (with any extra components installed) . My application needs this scenario, the SSIS package running from the client machine and pull data from the server. Please help me understand how can i do that. Thanks. Vigya ...Show All

• Visual Basic JScript to VB

  im converting a website from no asp.net abiltys to asp.net 2.0. origanaly the site used jscript to do interactivity now i want to use VB. some of the code i dont understand so i cant convert it. any help would be great. the code is (its very long): var document_gregorian_year = "1998" , //Curent english year document_gregorian_month = new Array( "January" , "Febuary" , "March" , "April" , "May" , "June" , "July" , "August" , "September" , "October" , "November" , "December" ), //English months document_gregorian_month_index = 0 //Curent english month document_gregorian_wday ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Spare 360 power supply to help with XNA development

  I have to move my xbox from the tv room to my computer room for doing XNA development - probably the same story for many of you here. So I figured I would just buy a second set of cables so it was easier to move - I can find the video cables all over but there appears to be no way to get a second power supply. There's a couple on ebay but they want $120 with shipping which seems a little much. So what is the magic search voodoo to find a spare one at a reasonable price. $90.... thats insane... is it made of gold No, but copper is getting pretty expensive . Btw: If you have a laptop, you could use remote desktop connection to connect to the desktop machine that actually does build and deploy to the Xbox. You'd sit in the ...Show All

• SharePoint Products and Technologies debugging workflows

  Hi I followed the instructions here to create a custom workflow using infopath forms. I got it compiled and installed fine. http://weblog.vb-tech.com/nick/archive/2006/09/04/1753.aspx I was able to create a workflow for a document library based on my code, but when I run it from an item in a doc library it died with a status "failed on start" So I loaded up VS2005 project on my dev MOSS07 server and attached to the w3wp process that was executing workflow code. I see symbols loaded up for various components. But none of my breakpoints show up, saying the "symbols cannot be loaded". The symbol file is created along with my DLL. The installer puts my DLL into the GAC. How does with work with symbol files ...Show All

• Silverlight (formerly WPF/E) WPF/E (TextBlock) is not rendering Unicode correctly

  I have downloaded the WPF/E CTP & SDK, I played with them and have noticed that WPF/E does not fully support Unicode, as I use a TextBlock to test the display of Arabic text, WPF/E was rendering the text incorrectly as if it is rendering the text from left to right while it should render the text from right to left. This same behavior is true for Hebrew too which is also a right-to-left language. am I missing somthing Until FlowDirection is implemented, Can you mirror your text <TextBlock > <TextBlock.RenderTransform> <TransformGroup> <ScaleTransform ScaleX="-1" ScaleY="1"/> <TranslateTransform X="100" Y=" ...Show All

• Visual Studio crystal report in vb.net problem when converting project from .net 2003 to .net 2005

  I developed an application using vb.net 2003, which contains crystal report, in the code, i gave the parameter values, so that when "report" button is clicked, the report automatically displays itself with given parameter values. however, i opened this application within vb.net 2005, and converted it into a .net 2005 project, after all this, when i run the applicaiton, and click on "report" button, it started asking values for all the parameters, why plz help here is the code: ( blue-colored area is most likely causing the problem, i checked the outputs of sqlcommands, all fine, seems that somehow the sqlcommands output values are not passed on to the report's parameters) Private Sub btnPrint_Click(ByVal sender As System.Object, B ...Show All

• SQL Server Update Query

  Assume a table with a single column.. which has 1,2,3,4,5 as values. On executing this batch file, all the rows should get updated as 0,1,2,3,4. But its updated as 2,3,4,5,6. DECLARE @var int set @var=0 UPDATE table_name SET column_name=@var , @var=@var + 1 What would be the logic behind this simple query.. According to me, expressions are calculated in prior. It looks like the variable expressions are evaluated first in Update statements. The typical use of variables in an update are to capture old values. Furthermore, they are mostly used when there is only one row being changed. There is no guarantee on the order in which the rows are processed in an Update statement. ...Show All

• Visual Basic Icons in custom-made dialog boxes

  I have just created a custom-made dialog box using the Add Windows Form command under the Project menu of Visual Studio 2005. Now I've run into a bit of a problem: Remember those icons (information, question, warning, error) in those dialog boxes you're always seeing I want to know how I can implement those in my custom-made dialog box I would appreciate a response as soon as possible. Thank you. I would have to take screenshots of the dialog boxes themselves, copy and paste the associated icons, and then save the icons into picture files. How, then, would I implement the ImageList control to display the correct icon in the correct condition (i.e., error, warning, etc.) ...Show All

• SQL Server Using SSIS packages to process SQL Server 2000 OLAP Objects

  Can a SSIS server, i.e. staging server be used to create packages that update SQL Server 2000 Analysis services objects on another server running SQL server 2000 OLAP   It appears that the OLAP connection manager ion SSIS supports only connections (and thus updates) to 2005 OLAP objects.  I work for a company that has a huge investment in a 3rd party DW that uses Analysis Services 2000.  the DW tool vendor will not support an upgrade to SSAS 2005.  We wish to extend the DW from other data sources.  My thought was to use a staging server with SSIS, used solely as the ETL tool for all new development (thus no more DTS development), and to update the sql server 2000 operational data st ...Show All

• Visual C# Capturing the up/down arrow key in a child form

  Hi, Recently, I was trying to capture the UP arrow key from my window forms application. I was able to capture the key in the parent form but once i open a child form, I would not be able to capture all the arrow keys but the rest of the keys like 'a', 'b','+' and etc are ok. I have searched the web but did not find any solution. Does anyone know how to overcome this problem Thank you. Soh Hi Er.... in private void Child_KeyPress( object sender, KeyPressEventArgs e) { switch (e.KeyCode) { case Keys.Up: case Keys.Down: case Keys.Left: case Keys.Right: // do stuff here; break; } } the KeyPressEventArgs e does not has a method keycode, it on ...Show All

• SQL Server Changing Cube source in a EXCEL pivot table

  Hi I have developed a cube on a "test" server - using Excel 2003 as teh front end. All is well with the cube an dI now want to point Excel to the "production" server. I have modified the .oqy file to point to teh new server but Excel does not seem to use this - unless I start over and import data. is there anyway of pointing to a different server (teh database/cube names are the same - I did an Archive and Restore to move teh database over) thanks Steve Another technique, which was mentioned on the public SQL OLAP Newsgroup, is to save the pivot table as an XML file. Then you can find and edit the connection string (search for the server/DB/cube names), and re-open and save ...Show All

• Software Development for Windows Vista Cannot access a disposed object.Object name: 'WorkflowRuntime'. - Error in Workflow with Xaml activation

  Hi all, I have a problem when I am starting instance of WorkflowRuntime. Public Sub IntiateRegisterPatientWorkflow( ByVal instanceId As String , ByVal requestXml As String ) Dim workflowRuntime As WorkflowRuntime = CType (HttpContext.Current.Cache(WorkflowRuntimeCacheKey), WorkflowRuntime) If workflowRuntime Is Nothing Then workflowRuntime = New WorkflowRuntime HttpContext.Current.Cache(WorkflowRuntimeCacheKey) = workflowRuntime workflowRuntime.StartRuntime() End If Dim objRegistrationInputParameters As Dictionary( Of String , Object ) = New Dictionary( Of String , Object ) Me ._wfRegistrationRequest = requestXml Me ._wfInstanceID = instanceId Dim ...Show All

• Visual Studio Sandcastle: No 'protected' icons

  Hi, instead of the 'protected' icons of types, fields, properties and methods, the 'public' icons are shown in the documentation. I'm using Sandcastle September CTP (Technical Refresh) and Help File Builder 1.3.1.1 netsrac Thanks Eric and Nestrac. Let me check this and will get back with an answer. Anand.. ...Show All