GlennSmith's Q&A profile

• SQL Server Random access in a result set

  I use an SQL task to produce a result set which I store in a package variable. It works fine to access the result set in a script task by first casting it to a ADODB.Recordset, and then enumerating it and accessing the rows in the given order. But is there a simple and clean way to randomly access the result set  In other words to repeatedly select a random row from it One thought I had was to conver ...Show All

• SQL Server Executing a SSIS Package from an ASP.NET page.

  I am using the following code to try and execute a package from a asp.net page.  The server has both SQL, SSIS, IIS and ASP.NET on it.  The package runs fine from the SQL Management Studio.  The Execute result from the web page is 'Failure'.  My questions are: 1.  How do I catch errors to see exactly what is failing and why 2.  Is there a better way to execute a package using SSIS from asp.net Thanks, Nathan Su ...Show All

• Visual Basic Processing Serial Data

  I need the reduce the processing time in a uMicrocontroller to allow faster sampling times. This has creates a problem in the data collection routine in VB. The old system collected the analog data a converted it to a decimal format before sending it to the serial port. This data is collected and saved using Hyperterminal. The VB program would, when run, would open this file and process the decimal data by graphing it. What I need ...Show All

• Visual Studio Tools for Office Microsoft Office System Projects

  I want to use Visual Studio Tools for the Microsoft Office System Solution   I have Office 2003 Professional installed "complete" (Using Add/remove Programs, I double checked and the ".NET Programmability Support" under Word and Excel is installed).   I have Visual Studio 2003 installed.   My issue is that I do not have "Microsoft Office System Projects" as an option when creating a new Project. ...Show All

• Visual Basic Pass any command line Argument?

  Hello sir, How, can i pass any command line arguments (Through Run Command) pass when my VB application execute and that's values are receive when form activate. Kindly Help me Thanks. To pass command line arguments to another app, you should look into the Process class, which does pretty much anything there is to do with Windows processes. Simple example: Dim p As New Process p.StartInfo.FileName = "C:\WINDOWS\NOTEPAD.EXE" ...Show All

• Windows Forms Drag & Drop

  Hello, i have a user contol called container_control. The three other controls kalk_container, preis_container, ... inherit from container_control. In a Panel i have overwritten the OnDragDrop Event. Within this Event i want to change the Location of the Controls  ...Show All

• Visual Studio Express Editions DotNetNuke install problem or too many starter kit installs

  The DotNetNuke Starter Kit 4.0.2 does not show up in the "My Templates" of the "New Web Site" window of VWD (An icon titled "DotNetNuke Web App..." per the documentation). I am wondering if there is a limit to the number of "New Web Site" templates that can be added and show up in the "My Templates". I have installed previously eight (8) starter kits and ASP.NET Site templates. With the " ...Show All

• Windows Forms Error when modifying clickonce manifest

  Hi! Help is needed. I'm trying to create a ClickOnce deployment with VS2005 b2. I have to add a few additional dll-files. I use MageUI to add the files and re-sign the manifest files. However, this failes all the time. This is what I do: 1. Use "Publish solution" from VS2005 (this initial deployment works as expected) 2. Open [program].exe.manifest and add one managed dll'file 3. Click Save 4. Select the same certificate that VS generates f ...Show All

• .NET Development Oracle 10g connectivity with ASP.Net

  Hi, I have a wierd problem. I have in my development enviornment, a Windows 2003 Machine installed with Oracle 10g (both DB and Client on the same machine). The same machine is being used as web server. On this I have a ASP.Net Application which connects to an Oracle DB and this application works fine. I had to deploy the same sceanrio for my client. At the client, the testing enviornment has a Windows 2003 OS insatlled with Oracle 10g (b ...Show All

• Visual Studio Express Editions Need help understanding new array usage in Visual Studio 2005

  Hello all, I’ve recently started working in Visual Studio 2005 Express Edition (VS05EE) and I’m trying to get my brain wrapped around this new way, new for me, of creating Arrays. For one thing I have notice that Index property is gone, so I am having trouble figuring out how I am supposed to tell VS05EE that what I am trying to do is create an Array. Let me tell you what I trying to do, and see if anyone can help me out with so ...Show All

• SQL Server Uninstalling a SQL instance programmatically

  Hi, Currently we deploy SQL Server Express as a part of our installation, and we create our own instance by setting up appropriate parameters. ie. SQLEXPR.EXE /qb ADDLOCAL=ALL INSTANCENAME="MyInstance" Can anyone please give some advice as to how we would uninstall this instance when the user uninstalls our application. The following link explains how to do it via the Add/Remove Programs: http://msdn2.microsoft.com/en-us/library/ms143412.aspx A ...Show All

• .NET Development find my external ip address not internal

  hi, anybody know how to find the external (real) ip address using vb.net/c# thanks t Hi, I'm not sure what you ment as external ip. However, You can use Request.UserHostAddress or Request.HostName for this of the HTTPRequest class. Regards, ...Show All

• Windows Live Developer Forums Sample Timeouts

  The sample is timing out for me when I run a simple search.  Any ideas   I've tried passing proxy server info and adding a custom GetWebRequest with no keepalives. System.Net.WebException: The operation has timed-out at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)at System.Web.Services.Protocols.SoapHttpClie ...Show All

• SQL Server problem with non additiv measures

  hi, excuse my bad english. i'have problem with percent measure in reporting service. the measure GoodPct  is calculated members and equal to: nb good product / nb all products produced. I want to display this measures as follow -(-)------------------------------semestre1-------------------------|-------------------------------semestre2-------------------------| (-)month1| month 2 |month 3 |month4| month 5 |mont ...Show All

• Visual Studio Express Editions Poor quality printouts when printing controls (labels, textbox etc.)

  My app. prints my form which has labels, textboxes and panels on it. What I have noticed though is that the quality of the text on the printout is quite poor and I can't seem to do anything to clean it up.The panels don't seem too bad. I use an LCD monitor and I'm using ClearType in the Windows Dispay Properties, and I did notice that changing this option does have an effect on the printouts, although the prints remain poor whatever I do. ...Show All