Mardi29's Q&A profile

• SQL Server Failure to run when using DTC

  Does anyone hany any experience of using SSIS with MS DTC I have a package that runs successfully. When I switch it to using transactions (i.e. TransactionOption= Required ) it fails. I get the following messages in the log: -Starting distributed transaction for this container.  -Failed to acquire connection " <connection-manager-name> ". Connection may not be configured correctly or you may not have the right permissions on this connection.  -Aborting the current distributed transaction.  So - it seems it is having trouble enlisting that connection manager in a distributed transaction. My connection manager p ...Show All

• Windows Forms TabControl - Disable/Enable tab page

  I have a tabcontrol with 2 pages. OnLoad the 2nd Tabpage shall be disabled (grayed out and not selectable). Later with code I need to enable the 2nd tab. Any Ideas how this can be done please. /Morten You can't disable a tab as such, but you could mimic it. You could do something like the following: 1. Add a TabControl with 2 pages 2. Set DrawMode to OwnerDrawFixed 3. Attach the TabControl.Selecting event to tabControl1_Selecting 4. Attach the TabControl.DrawItem event to tabControl1_DrawItem 5. Then copy the following code into your form (you will have to change it a little)    public ...Show All

• Visual Basic Working with Files in VB.NET compared to VBA

  I'm an old VBA guy who's trying to figure out VB.Net:    1. Does VB.Net have the equivalent of the FollowHyperlink method from VBA where you can write code to directly open any file or web page    2. Does VB.Net have a way (like ThisWorkbook.Path from Excel VBA, CurrentProject.Path from Access VBA, etc.) to always reference the path of the current project (I've tried using CurDir, but that changes when the Current Directory changes, which seems to change when I use the OpenFileDialog Box). Any insight or answer to either of these questions would be greatly appreciated. Thanks, Dave ...Show All

• Visual Studio Tools for Office Adobe not playing nice with VSTO

  greetings, When adobe professional is installed, it seems to cause a bunch of weirdness with my menu items in my vsto solution. On some machines they are shown for a sec and then hidden, on other machines it takes over my menu items and shows adobe items underneath my top level item. this is a show stopper for my vsto solution as these products are often gonna be found on word. any suggetions. Mary, I suspect that Adobe is merging its menu items with the ones added by your VSTO solution. I think you may have to write some additional code to move your menu items around when Adobe is installed or remove the Adobe addin (temporarily) i ...Show All

• Software Development for Windows Vista Question on SDK/Vista Developer content?

  Hi all, We'd like to get your opinion on how we should spend some of our resources on developing content that is targeted at you, the developer. We are feaverishly working away at producing API documentation an other things, but what areas do you feel need more work We have some resource allocations to make and you input would be very valuable here. I am talking about additional conceptual things like application compatibility, migration, how to conditionally "light-up" your application on Vista while still working well on XP. Or is there a new part of Vista that is just poorly understood and needs our attention. These are just ...Show All

• .NET Development C# SerialPort Read termination issue.

  The new SerialPort class is fantastic and works great. However, I'm now in a situation where I need ReadLine() to return when a 0xC1 is recieved in the port, as all of the incoming messages begin with a 0xC0 and end with a 0xC1. Trouble is, the NewLine property only takes (unicode) strings, making this seemingly impossible. I cannot read one byte at a time (WAY too slow). Please help Oh Gurus! :-) The problem isn't that SerialPort.NewLine takes a Unicode string it's that by default the SerialPort class uses the ASCIIEncoding to convert the bytes that it receives to characters. This encoding would convert 0xC0 byte to 0x3F or ...Show All

• SQL Server Using Unicode in SQL Server

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page correctly when I do a SELECT query. Here's an example of my problems. < php $insQ = "INSERT INTO my_tblBusiness ( pkID, fkbusinessID, ntitle, ...Show All

• Visual Studio Express Editions Working and saving as VB 6.0

  I have an assignment to do and one of the hand-in requirements is that the files submitted are Visual BASIC 6.0 only. I don't have Visual Studio 6.0 available to use, but I do have Visual Basic Express Edition so I'm wondering how do I run VB Express in BASIC 6.0 mode, and so that it will only save files at 6.0 At the moment I load up old files and it converts them to VB 2005, adding code I'm not familiar with, so that's not what I want. Many thanks hi, i don't think this is possible to convert code from visual basic.net to VB 0.6 using VBEE IDE , it just convert code in one way and no way to go back ...Show All

• SQL Server How to iterate over a recordset?

  Hi All, Many moons ago I wrote a blog entry ( http://blogs.conchango.com/jamiethomson/archive/2005/02/08/960.aspx ) about how to, in a script task, iterate over a recordset that is populated into a variable using the Recordset destination. My method there was to use ADODB.DLL but that's a bit "old school". Is there anything in System.Data to which I can cast the Object variable that will allow me to navigate the recordset stored within it If there isn't, can someone tell me where all the ADODB objects now reside because ADODB.DLL doesn't exist in 2.0 Framework RTM. Thanks Jamie   Jamie, I'm assuming you ...Show All

• SQL Server Report Builder Error When Running Report

  Hello everyone, I've come across an unusual error on some of our machines. I'm trying to track down why only certain ones will give an error. I thought it might have something to do with .NET 2.0 not being installed, but I assume that they wouldn't even be able to launch Report Builder if this is the case. I'm at the point now where I've been told these machines have .NET 2.0. I plan on trying to verify soon, but I thought I'd get everyone's opinion on what it could be. With even the simplist report (just 1 field dragged onto the report) the following error appears: "Report execution error The report might not be valid or the serv ...Show All

• Visual Basic Urgent Help: How to import dll correctly and use it in VB.Net

  Hi, I am new to VB.Net 2003, and encountering a problem about how to import dll file. I created a dll file from Matlab by using the COM builder. Matlab creates a dll file, say interpUSGS.dll. Then I create a new project under VB. Under the Project menu, I click Add Reference, and browse the location of interpUSGS.dll, adding to the Project Reference. In my VB IDE, I worte the code like this: -------------------------------------------------------------------- Imports System.IO Imports Microsoft.VisualBasic Imports interpUSGS 'then I create a buuton on the main form Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.E ...Show All

• .NET Development how to set the dataset's namespace

  hi, I'm use the Dataset Desinger of Visual Studio 2005 to design a dataset. Then, I compile the project. The desinger generate a typed dataset class. But the dataset class is inside the global namespace. How to set to generate the typed dataset class in a customed namespace. The namespace above is C# namespace. Not the XML namespace. thanks. Hi, When you create a typed dataset, the generated dataset class inherits the DataSet Class object. That is why it is inside the global namespace. You cannot customize the namespace of the generated dataset class. Hth, Michael Castillones ...Show All

• SQL Server Configuration files and variables

  Hi .. I need some information on the package configuration files. i.e how to set the configuration parameters from outside the packages. Pls provide me some detailed information along with examples. I want to make my packages to read paramaters from the configuration files as we have in .NET(web.config)//// Secondly I want to know how to play well with variables.. i.e setting a variable.. reading a variable.. passing a variable in the SSIS package dataflows and datatasks.. respectively. Please provide some infomation and a good exam[ple on it I need   sam_idea wrote: Hi .. I need ...Show All

• Visual Studio Team System Versions control - Branch & merge versions

  Hi,   I recently installed VSTS Beta 3. I am trying to understand Beta 3 branch & merge concepts. I understood that in this version the user will be able to merge between unrelated branches. However, I tried this and I can only merge between child and parent branches.   In addition, I would like to know if it is possible to specify a file version, (Like version num 3 of a specific file) and not just the change list number in which version number 3 exists   Thanks Yaarit Reiner   Hi, Thanks for the replay, I still have a few questions about bra ...Show All

• Windows Forms ComboBox in DataGridView "Value violates Maxlength of column"

  I'vegot a lookup ComboBox for Units of measure linked to the Units reference table ("UnitsRef"). Table is two fields: Unit             varchar(20) not null (key field) Category     varchar(15) nullable   Datasource:  tried raw table, bindingsources...) DisplayMember: Unit DataPropertyName: Units (same format as "Unit") Regardless of what I link the lookup to, I get the "Value violates MaxLength of Column" error when moving to the next row. Message further states: "at System.Data.DataColumn.CheckMaxLength(DataRow dr)" and a ...Show All