Jose Ignacio Rodriguez's Q&A profile

• SQL Server Union All Failed the Pre-Execute Phase

  I am getting the following error when trying to execute my package.  I have deleted and re-create the UnionAll task and have yet to figure out what the issue is. Error: 0xC004701A at Load AgencyDim, DTS.Pipeline: component "Union All" (1446) failed the pre-execute phase and returned error code 0x80070057.   Help More information.  Come to find out this is because my data flow does not contain a Source.  I was trying to use a Derived Column as the source to pick up some passed in variables and put them in a table.  This appears to fail.  How can I do this ...Show All

• Windows Forms how do u change the appearance of the windows and buttons

  how do u change the appearance of the windows and buttons from Windows classic style to the Windows XP kind. I have XP and it wont let me change, like there's no choice to put it back HELP ME!!!! PLEASE do you have a manifest file if you dont, hear is what to do: 1 go to the bin folder of yur application 2 create a new text ...Show All

• SQL Server Watermark Generation is Invalid Error

  We are currently doing a proof of concept using SQL 2005 merge replication.  However we are currently encountering the following errors: "The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up." " The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention period, or because of one of the replicas being restored to a backup older than retention ...Show All

• .NET Development Method to connect to AS400 via IDB2.Net Provider or Oledb

  Hi Guys, I need help on 'How to update data into AS400 V5R3 via IDB2.Net Provider or Oledb'. My sample code: Via IDB2.Net Provider Dim cn as New iDB2Connection("Datasource=100.1.1.81;Userid=Tas01;Password=tas01;") cn.open() Dim trx as IDB2Transaction = cn.BeginTransaction(IsolationLevel.ReadCommitted) Dim cmd as iDB2Command cmd = cn.CreateCommand() cmd.Transaction = trx cmd.CommandText = "Update CCPSP set LORNSP = LORNSP + 1 where 1=1" cmd.ExecuteNonQuery() An error encountered : Invalid Operation( if using transaction ) Via OLEDB Dim cn As New OleDb.OleDbConnection(ConnectionString) ...Show All

• SQL Server VS 2005 Invalid database version SQL CE

  VS 2005 windows application SQL CE 2000 dim strSQL As String Dim ssceconn As New SqlCeConnection("Data Source = c:\atisoft\atisoft.sdf") ssceconn.Open() Dim sqlInsertRow As SqlCeCommand = ssceconn.CreateCommand() Invalid database version. [ Db version = 0,Requested version = 0,File name = c:\atisoft\atisoft.sdf ] Since you've posted to emulator related forum, I'm assuming you're running this on emulator. If so, why are you using incorrect path with drive letter Anyway, this error means you're trying to use old database with new SQL Mobile. You need to covert the database first, procedure ...Show All

• Windows Forms how to give value to parameter in a query of dataset in C#.net2005?

  I am in C#.net2005 I have a listbox bound to a dataset, in the dataset, I built a new query: SELECT ServiceID, ProductDetails, ServiceNotes, ServiceCharge,  DeliveredDate, CustomerName FROM [Freedom Scooter Service Reminder] WHERE CustomerName = "@CNAME" AND DeliveredDate IS NULL in Code, I want to give value to this parameter "@CNAME" , so that the listbox will show the records with given CustomerName. by the way, the value of "@CNAME" I want to get from is comboBoxCusName.SelectedValue.ToString() plz help Hello again i gave you an example in the last thread you opened adapter.FillByCandidateID( this .powerJob ...Show All

• Visual Studio Team System finding an exception

  hi, Can anyone tell me what are the different ways of finding out an exception hi, ihave another problem now. On finding the exception, i've to check for the presence of destructor in the target sample. How do i implement a rule which will check for destructors ...Show All

• Smart Device Development Voice Command and Mobile PC

  I am about to begin developing an application for Mobile PC that requires the user to dictate a string of letters and numbers into the computer and have that string of number and letters appear on the form. Is Voice Command 1.5 capable of this I have read the rather sparse manual that comes with the software and it looks like it is only capable of predefined operations, however, I am hoping someone has had experience with this type of operation and can give me some advice. If VC cannot do what I need it to do are there any suggestions on alternative voice recognition software Thanks in advance! I believe that Voice Command is an app wri ...Show All

• Visual Basic Pause

  Hello, A quick question. I am using Microsoft Visual Basic 2005 Express Edition. I was wondering if there was an easy way to add a pause. I have some graphics I want to display but want them to stay on the screen for a second or two then hide. I know its probably an easy question, but I cannot find the answer anywhere. Thanks a lot for your help. Scott There are at least three ways I can think of, Sleep, Do While <date>, and Do While TickCount.  The sleep function (Thread.Sleep(<value>)) will cause your UI to be unresponsive, for example to pause for 2 seconds:  Thread.Sle ...Show All

• Visual Basic converts a u_short from host to TCP/IP network byte order, vc++ [htons] -> vb.net ?

  '// write data stream into 'void WriteBits(BYTE* p_buff, int pos, int len, unsigned long value) '{ '    int start_byte, end_byte; '    int start_bit, end_bit; '    int byte_pos; '    BYTE width_mask, or_mask, and_mask; '    BYTE byte_value; ' '    start_byte = pos / 8; '    start_bit = pos % 8; '    start_bit = 7 - start_bit; '    end_byte = (pos + len - 1) / 8; '    end_bit = (pos + len - 1) % 8; '    end_bit = 7 - end_bit; ' '    if (start_byte == end_byte) '&nbs ...Show All

• Windows Forms Combox.SelectedValue is null after item is selected

  In my new C# 2.0 windows application, I want to display drop down lists that hold key/value pairs. So I created a simple class "ClsLookup" with LookupText and LookupValue properites. I add instances of these lookup classes to a ComboBox's item list and set the DisplayMember and ValueMember properties of the ComboBox. After the user selects an item in the ComboBox, the ComboBox.SelectedValue property is null. The ComboBox.SelectedIndex and ComboBox.SelectedItem properties contain the correct values. Why do I want to use the SelectedValue property instead So, I can use a BindingSource to bind to the SelectedValue property. ...Show All

• Visual C# Updating Database

  Hi I am receiving an error message "Error 1 'System.Data.DataRow.DataRow(System.Data.DataRowBuilder)' is inaccessible due to its protection level ",when i try to update the database programtically through datagridview control placed in my from. I want to edit and update a database at run time while changing the corresponding cell values of my datagridview control. Please,provide me the appropriate code snippet with a brief note.... The DataRowBuilder class is not intended to be used directly from your code. The class is sealed and doesn't have a public constructor. Because this class doesn't have ...Show All

• SQL Server ntext syntax question

  I have read the books on line about this topic and I have a very basic question about ntext. I am using SQL 2000. My question: Is there any reason why we should ever use the "updatetext " statement if we are replacing the entire ntext column Couldn't we / shouldn't we just use the update statement. Will this ever fail if the item we are inserting is very large Lets say we are inserting a xml file into this column and it is 100k, is it better to use the updatetext rather then an insert / update (this is the reason which the person gave whom I inherited the code from, because the insert could fail on large items, so we started to ...Show All

• Windows Forms Programmatic access to treeview control

  The help index in VS2005 indicates that it should be possible to change the selected node on a treeview control programmatically, but both the selectednode and selectedvalue properties are marked as read only so they cannot be changed.  How do I change the selected node programmatically to allow the tree to correspond to a web page that is opened from a Server.Transfer command (the default behavior is for the tree to remain pointing to the previous page) Dim MasterTree As TreeView = CType (Master.FindControl("NavTreeView"), TreeView) MasterTree.SelectedNode = Session("SelectedNode") Fatal Build E ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Erorr in loading DirectX Reference

  Dear All, I have two versions of VS.NET (2003 & 2005) installed and DirectX SDK Dec/2005 version installed as well. I am trying to develop just a few lines of code to create the device but it caused the errors as below: An unhandled exception of type 'System.IO.FileNotFoundException' occurred in TestDX.exe Additional information: File or assembly name Microsoft.DirectX.Direct3D, or one of its dependencies, was not found. TestDX.exe!TestDX.Form1.Main() Line 78 + 0x14 bytes C# I reference to three directX libarary in the the following folders: C:\Program Files\Microsoft DirectX SDK (December 2005)\Developer Runtime\ ...Show All