ash927's Q&A profile

• .NET Development OleDbCommand.ExecuteNonQuery "Insert Into Select From"

  Hello, I am working with OleDb to perform a bulk insert from a temporary table to permanent database table, both of which belong to the same database. I am wanting to use "INSERT INTO <permanent_table> SELECT * FROM <temp_table>". The query I run in MS Access to perform this bulk load does process correctly, but not in code using OleDb. After properly setting up my OleDbConnection object, opening it, and properly ...Show All

• SQL Server Bulk Insert Speed Problems

  Dear Experts, Our Server Information is: HP Proliant ML570 with 4 CPU (2.00GHz 512KB L2, 2 MB L3) It has 4GB RAM. We have 2 HP Smart Array 6400 Controllers with 192MB RAM. The Disks of the system are all HP ULTRA320 SCSI. We have 8 x 146.8 GB 15K, 2 x 72.8 GB 10K and 2 x 36.4 GB 15K We configured the Disks as follows: First Controller RAID 1 = 2 x 36.4 GB 15K - Operating System(Microsoft Windows Server 2003 Standard Edition Service Pack 1) ...Show All

• Visual C++ NET and mfc

  how can i use the forms made in net and use it in mfc programs Yes: Windows Forms/MFC Programming Differences Hosting a Windows Form User Control in an MFC Dialog Box Hosting a Windows Form User Control as an MFC View Hosting a Windows Form User Control as an MFC Dialog Box Blog by Yves Dolce: MFC 8 (VC++ 2005) and Windows Forms MFC and WinForms Integration ...Show All

• SQL Server failed connect to mirror instance

  While configuring database mirroring in principle server with partner. It shows an error 'Msg 1418, Level 16, State 1, Line 1 The server network address "TCP://mirror:5025" can not be reached or does not exist. Check the network address name and reissue the command.' But i can telnet mirror 5025 successfully. I have use IP instead but same errror encountered. Any advise on it Thanks in advance Take a look at the issues ...Show All

• Windows Live Developer Forums BOTS on MSN

  There have been a number of questions about BOTS in the forum in various theads so I thought I would provide this post with a broader update on the topic. MSN has recently started licensing BOTS on the network.  The huge benefit of a licensed BOT is that it will have contact limitations removed (the reverse list), so that millions of people could connect to the same ID.  Our goal is to enable a broad network of these IM applications ...Show All

• .NET Development Best Practices for Large App Architecting/Construction

  Developing an Insurance app which has multiple projects Project 1 -- Core Layer (Data access, utilities, security namespaces) Project 2 - Business Layer(Accounting, Policy, Coverages, Client, Insurer Namespaces) Project 3 - Application (forms and user controls- more than 500 unique forms and user controls) The problem is that Project 3 is getting onerous. A team (of 2) that works on Accounting has to continually recompile the policy ...Show All

• Microsoft ISV Community Center Forums Send Outlook message via VBA Macro in Excel

  I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error: Run-time error '-2147024770(8007007e)': Automation error The specified ...Show All

• Software Development for Windows Vista directshow and teletext

  Hello everyone, I'm really new in directshow development, and I hope you will be able to help me. My goal is to capture video from a video capture device (osprey 440). I'm proud to tell you that I know how to do this . I'm using an ASF writer filter to do it. My question is : Do the files I create using ASF writer filter include teletext data If so, how can I create a graph to display the teletext If not, is there a way to create a video ...Show All

• SQL Server How can you change the isolation level for SSIS transactions

  Hello, I have a transaction running over a data-flow. My source uses a proprietary OLE DB Provider and when I run the data-flow i get the following error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D008 "The requested isolation level is not valid or supported.".  What isolation level does SSIS use Is it possible to change it I had hoped the answer to these questions would be ...Show All

• Windows Forms cruisecontrol, msbuild, obfuscate, clickonce

  I'm looking to setup an integrated deployment scenario using cruisecontrol. I would like the build process to build the release version, obfuscate the code (including dependant project dll's) using Dortfuscator CE and finally publish the app for Clickonce deployment. Does anyone have any info on how to set this up did you ever nut out how to do this I'm trying to do a similar thing although NAnt is in the mix a ...Show All

• SQL Server Primary key and identity

  Can someone tell me the difference between making a column primary key column vs. making it identity column thanks Identity just auto increments the value in that column (like autonumber in Access). A primary key uniquely identifies a specific row. Obviously you can have only one primary key per table (you can make a combination of columns the primary key - but I do not recommend this). ...Show All

• SQL Server SQL Server Project reference

  Hi, I have created a SQL Server Project. I added reference to an assembly that was already registered in SQL Server. I was successful in adding the reference, but when I try to import that assembly in my C# code, it is not available. I cannot import that assembly with the 'using' keyword. Can anyone help me with this P.S: The assembly that I registered in the SQL Server has 'Unsafe' access(this is shown as Unrestricted in the references ta ...Show All

• SQL Server Object is invalid. Extended properties are not permitted on ...

  when attempting to execute the following query from within 2005 Mgmt Studio: sp_dropextendedproperty @name = 'test_me' , @level0type = 'schema' , @level0name = 'dbHSPS.dbo' , @level1type = 'table' , @level1name = 'Conflict' /*[ , [ @level2type = 'column'] { 'level2_object_type' } , [ @level2name = ] { 'level2_object_name' } ] */ I receive: "Object is invalid. Extended pr ...Show All

• .NET Development ConfigurationSection Question

  I am in the mist of learning about the new configuration classes in the 2.0 framework. Here is what I am trying to do: Define my own custom section in the app.config Have the application read this custom section from the app.config Have the application be able to modify the values from this section Save these changes as a user config file From what I understand with the new configuration classes the flexibility is there to save ...Show All

• SQL Server sorting on an expression

  I wanted to create a column which was one field divided by another field, and then sort on it. I started with Fields!FG.Value)/Fields!ADU.Value but of course when ADU was 0 it caused an error. then I went to =iif( Fields!ADU.Value =0,0,(Fields!FG.Value)/Fields!ADU.value) but sadily it evaluates both the true and the false return values before figuring out which one it would need to return. So then I used this. =iif( Field ...Show All