ron nash's Q&A profile

• SQL Server 2 similar queries - different results! Why?

  SSAS2005. Tell me please, why this query SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS , { [Product].[Product Categories].[All Products] } ON ROWS FROM [Adventure Works] WHERE ( [Product].[Category].&[ 1 ] ) returns: $29,358,677.22 but SELECT { { [Product].[Category].&[ 1 ] } * { [Measures].[Internet Sales Amount] } } ON COLUMNS , NON EMPTY { [Product].[Product Categories].[All Products] } ON ROWS FROM [Adventure Works] returns different result: $28,318,144.65 If I replace [Product].[Category].&[ 1 ] on [Product].[Product Key ].&[BK-M18B- 40 ] then results are identical! $25,919.52 Thanks. This indeed looks like a problem. I would encourag ...Show All

• SQL Server Execution of DTS package after Scheduling.

  Hi All, I have a problem in getting the info about the execution of a DTS Package. I have a SQL-2000 Client installation on my Desktop to connect to SQL-2000 Server Database system to do all of my work. i had a DTS package stored in my SQL Server2000 Local Packages.  Now i have to schedule the DTS Package from my Desktop. And the DTS package is processing some files from a shared network folder. when i used to run the DTS package manually from my desktop my desktop login have access to that shared folder so there is no problem to run the package. suppose i scheduled the DTS to execute on daily basis at 10:00 AM. Now my doubt is wher the DTS will be executed after scheduling, which starts DTS execut ...Show All

• Visual Basic VB.Net (or C#) for machine control

  Hello Experts:      For some quick background - I've done lots of PLC programming (equipment design) and am probably an intermediate vb programmer. I have been dabbling a bit with the idea of using vb.net for machine control as it would provide many advantages in terms of software reusability, flexability, etc.       The challenges are two fold. The first is the abiltiy to interract with physical I/O and the other is the real-time aspect of control.       With respect to the first issue, OPC and Modbus TCP/IP seem to be the best options. I have read pros/cons of each but am still not certain which is the best choice in terms of performance and ease of use. Any t ...Show All

• Visual Studio Crystal Report with images - Export 2 PDF

  I'm using VS 2005 & the included version of CR, I'm exporting some small (by enterprise standards) reports to PDF (via small ADO.NET data sets), and for the most part all works well. However, I've noticed that once or twice a week CR runs into some kind of problem which often ends up causing the aspnet_wp.exe process to recycle. When this happens the .aspx pages are fine (although slower to produce than normal), but I cannot generate any PDFs via CR. One interesting symptom is that the ASPNET account's Temp folder starts filling up with temporary CR files at this time, with names like temp_a29f6342-1e64-4dfa-bcfd-33ad9fab2bf1.rpt. Some files are 16 KB, others are 680KB, always these 2 sizes (my actual PDFs are around 50 - 70 KB). Th ...Show All

• Visual FoxPro Errors running FoxPro Stored procedures in .NET windows app

  Hi I want to run a stored procedure in user selected database which basically creates two new tables to be persisted in the same database. I am able to call this stored procedure but I keep getting the same error "One or more errors occurred during processing of command." There are no details of what the error is specifically about. I am able to run the same stored procedure using Microsoft Visual FoxPro 9.0 software. My Connection string is "provider='VFPOLEDB.1';data source='strPathName.dbc';password='';user id='';Mode=ReadWrite". Any ideas or suggestions are appreciated. Try If VFP7Connection Is Nothing Then VFP7Connection = New OleDbConnection(VFP7ConnectionDefinition) If VFP7Connection.State = ConnectionSt ...Show All

• Visual Studio COM Integration Error with Word

  I am having problems with a program that generates MS Word documents. When I click the button that generates the document, it throws an error that roughly says that (I don't have the program running right now, so it is not exact) there is a problem converting a Microsoft.Office.Interop.Word.Application object to a Microsoft.Office.Interop.Word._Application interface. Any ideas First, ensure that you are using the official Primary Interop Assemblies (PIAs) from Microsoft (download and install them) for Office 2003 or Office XP (2002) and not just Interop assemblies generated by VS. Second, read some articles about PIAs at: http://www.mztools.com/resources_office_addins.htm such as "Office XP Primary Interop Assemblies ...Show All

• Windows Forms Creating a color chooser

  How to create control like the one in MS Office,from which the user choose a color Or how to fill a combobox with different colors for combox you can use set combox drawmode to OwnerDrawFixed than add code at draw item event private void comboBox1_DrawItem( object sender, DrawItemEventArgs e) { Rectangle r= e.Bounds; Font f=e.Font; string s = this .comboBox1.Items[e.Index].ToString(); Graphics g = e.Graphics; g.FillRectangle( new SolidBrush ( Color .FromName(s)), r); } ...Show All

• Visual Studio 2008 (Pre-release) Install Issue Orcas RC1

  I have the following installed .NET Framework 3.0 (RC1) Microsoft Windows Software Development Kit (SDK) for RC1 Visual Studio 2005 But the Orcas RC1 tells me that i'm missing .NET 3.0 Runtime Files which are Installed..So i'm at a loss here,any help will be appreciated...Thxs OS: Windows XP Pro with Media Center 2005 I was using the June Build of Orcas and EID...I got all the Downloads from the links you provided above,I Un Installed Everything that had to do with the previous version...But when i went to install the RC1 it would tell me that the .NEt 3.0 Runtime RC1 was missing,Even thou i had the Sept Build of EID up and running and using the Application... So i ended up Formatt ...Show All

• Commerce Server Calculate Tax based on Product Information

  I have come across a situation that presents me with 2 problems. 1. In the state we work, some items are not taxable (Clothing, for example) while other tiems are (Household, for example). We need to be able to identify which category (not necessarily Catalog Category) the items in the LineItem belong to. At first my thoughts were to add a custom property in the Catalog Manager (IsTaxable) and i would be able to find this property inside the pipeline. Form there on it would be fairly easy to accomplish. 2. I can live with the solution above, if i could find a way to get access to the product information, which i cant. Anyone has any ideas on how to get this data OrderForm.LineItems does not provide access to actual Product Info; ...Show All

• SQL Server Force columns to appear in matrix.

  I have created the report below in SSRS to show the total by month for the calendar year. As of my January running it runs great as there is data for all 12 months of the year and the matrix is created with the required 12 columns. 01 02 03 03 4 05 06 07 08 09 10 11 12 Total AA 17.5 22 17.5 75 30 162 BB 15 15 15 15 15 15 15 15 15 15 15 15 15 195 CC 15 15 15 15 15 337 15 233.3 15 325.5 117 15 15 1147.8 DD 315 290 1231 1231 1231 269 953 384.8 706.8 1798.8 ...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 ADO Control

  hi I have seen programs that bind a DataGrid to an ADO Data Control. But i want to know, how to display the fields in Edit Controls. Is there some way to bind the Edit control to the DataSource(ADO Control). Hi shivShiva we can bind data to label or textbox, follow is an example bind table to textbox, and you click the button the recorder would be move thorouh table using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication1 { public partial class Form3 : Form { public Form3() { InitializeComponent(); ...Show All

• .NET Development Tcp Socket | pending the data or not to be

  me have new question about Tcp Socket Async operation. let say the server are sending a data (512 bytes) to client, during the data still sending (no matter due to internet delay or resend cause by wrong package) server send again another 512 bytes data. those 2 data will always arrive in order or not another question is: me don't know exactly how the async work, will it crash or error if sending too much data at once while the previous data still in process(me have no idea how to test it, test on my local machine always seem ok -.-') should me implement a pending for the Socket Async send method(something like below, this is what me doing right now) function sendMessage(){ if(sending){ pendMessage() }else{ sending = true S ...Show All

• Visual C++ Using animated GIF image in Forms

  Hi, I'm trying to use an animated gif image in a form within C++/CLI but so far without success. I looked at picturebox control but the image stay still, no animation. I browsed the NET to find any clue to my problem and got a few articles stating the fact that I have to make somekind of class that would rather display one at a time each frame found in my GIF. Any clue or easier way, any example on how to do it Thanks in advance, Stephane   Stephane Beauchemin wrote:   I'm trying to use an animated gif image in a form within C++/CLI but so far without success.  I looked at picturebox control but the image stay still, no animation. Presume you are using VS2005. ...Show All

• SQL Server Bug in Report Server?

  I am running a report using RS2005.  It connects to a web service using the XML data source.  It works correctly in my development environment.  When I put it up on the server and run the report, I get the error message: An error occurred during rendering of the report. An error occurred during rendering of the report. Item has already been added. Key in dictionary: '1' Key being added: '1' If I run the web service from the server, it returns correct data, so I know error is not coming from my web service.  The only answer I can think of is that there is a bug in the Report Server's or XML Data Source's code. Has anyone else seen this problem Thank you, Jessica ...Show All