Neil Dela Osa's Q&A profile

• SQL Server Variables Not Seen In Custom DataFlow Destination

  I have run into a HUGE problem (possibly a BUG)! I have a custom XML Destination script which uses a FILE Conn to send to another path using the original file name. (found in my foreach container (varFileNm) The problem is that my destination will not use the value found for the varFileNm. I can see the value just fine in the Flat File Receive, but I can't see the value in my custom XML Destination Script using a File Conn (also tried a Flat File Conn for laughs and giggles) In additon, I have tried several other ways to set the varFileNm to some value (both dynamc & s ...Show All

• SQL Server Not able to extract all records from a flat file

  I have a flat file that has over 50,000 records. When I import that file into my table I'm only able to extract 26,612 rows. I'm using a Flat File connection manager The format for this connection is Ragged Right There are about 25 columns, or so My Data Flow Source is a Flat File (Imagine that! ) I appreciate any ideas that you may have. Thanks!! Did you have the error output as ignore failure I've seen this issue where the rows are not readable, and because I've set to ignore failure so it skipped the rows. ...Show All

• .NET Development Deleting row Problem

  Hi, i am trying to delete a row using a simple sql command: DELETE FROM User WHERE userid = 'aaa' but i get the following errof: The data types text and varchar are incompatible in the equal to operator. in the sql server express i have specified the column 'userid' as 'text'. is my sql statement not correct please help. regards, rnv thanks a lot.. it is now clear i need background info on sql db. can you recommend any good link to get basic db ideas regards, rnv ...Show All

• .NET Development Q: How to: ControlParameter referencing across ContentPlaceHolders

  VS 2005 Beta 2, ASP.NET Master Pages, SqlDataSources Master/detail views using linked GridView/DetailView DetailView's SqlDataSource SelectParameters ControlParameter is linked to the GridView that provides the master data.  ControlId is set with the designer.   This works great when the SqlDataSource control for the detail view is in the same content control as the GridView control, but fails when the GridView is moved to a different content control area on the same master page.   That is, the Master page has two content placeholders: cphMain and cphFull.  The child page(s) provide the content for one or both placeh ...Show All

• Software Development for Windows Vista how to customize workflow in web page

  how to customize workflow in web page If you mean that you want to be able to create / modify workflow within and ASP.NET web project You need to do this on your own. Take a look at Jon's blog for an example. ...Show All

• Visual C++ Studio 2005 - No more images in toolbar and treectrl in Debug mode... (CImageList problem ?)

  C++ ; MFC ; x86 ; Visual Studio 2005 I was using Visual Studio 2003, and since I have installed Visual Studio 2005, toolbars (CToolBar) and treectrls (CTreeCtrl) don't show images in Debug mode and works fine in Release mode !! The common link between these classes is CImageList class... I don't really understand how I can resolve this problem, so any idea is welcomed :o) Thanks The problem seems to be linked with my Manifest (to use XP styles for controls) In release, i don't have xp styles for my control And if I remove the manifest in debug mode, it works... Very strange... So, the q ...Show All

• .NET Development Retrieving data in fields in dataset or ADO.NET

  Who knows the codes for retrieving data in a database field in a dataset and inserting it into a textbox   How do i move the arrow in the database through codes in VB.net pls email me at francis_himura@yahoo.com ASAP please! Thanks! Ok, ADO in VB6 and ADO.Net has a very different approach. ADO .Net adapts the principle of a disconnected recordset in VB6. If you want to create a ForwardOnly cursor, just like in vb6, You'll need to use DataAdapters. if you want a disconnected recordset (I think it's adOpenKeyset in vb6) then you'll have to use datatable or dataset. BTW, in ado.net you don't nee ...Show All

• SQL Server ReportService.asmx vs. ReportService2005.asmx

  Hi All, This may be a simple question, but when I am adding a web reference to Reporting Services (using SQL Server 2005), should I pick ReportService.asmx or ReportService2005.asmx In SQL Server 2000, we chose ReportService.asmx (obviously), but in SQL Server 2005 there's another choice, ReportService2005.asmx.  So, I don't know which one to choose (or if it even matters). Also, do I need to add a web reference to ReportExecution2005.asmx Thanks. It basically means that RS 2005 still supports the old RS 2000 SOAP endpoint. Consequently, your applications built against the RS 2000 web service will st ...Show All

• Visual Studio Team System Team build and project references!

  Right now I have all of my projects locally in the path D:\Projects. I have a solution with the following structure: Main project project reference 1 project reference 2 project reference 3 When i tried to build with team build it freaked out because it could not find d:\projects\projectreference1\projectreference1.csproj so i went into the solution file and removed the absolute pathes  and replaced them with "..\"  to simply go up a level where the projects were located relativly. This allowed team build to actually work. What is the proper way to do this 1. What is the actual solution you are tr ...Show All

• Visual FoxPro shall I purchase Visual Fox Pro 9 ?

  Hi there. I have considerable background in Visual dBase Plus which is an OO language with considerable means to create forms, tables and some windows applications but it is hard to do any networking. Thus I am trying to migrate to C#. I do have a Visual Studio .NET 2003 Pro and downloaded Visual C# 2005 Express Edition Beta 2. I have created some forms and added some functionality. Now I need to create tables and I need a table designer which I found to be a part of SQL server. It appears I have downloaded SQL Server but it is not working for some reason and I have to find out why. My question is: shall I just purchase a FoxPro 9 ...Show All

• .NET Development Creating 64-bit applications on 32-bit platform using Visual Studio 2005

  Hello, How can I create 64-bit apps on x86 processor Do I need a x64 or IA64 machine to do that I have installed VS 2005 and the .NET Framework on x86 machine. I have my 32-bit apps ready. How do I proceed Any suggestions will be appreciated. Thanks! Sonia. Any dot net application(vb 2005 or c#) which is compiled for anycpu (the default) will be a 64bit application when run on an x64 or IA64 computer ...Show All

• Windows Forms AxSHDocVw.AxWebBrowser and default IE ContextMenu

     I'm trying to host Internet Explorer's Web Browser ActiveX Control into my one of my applications.    The problem is that i cannot understand Platform SDK's documentation on how to override or disable the WebBrowser ShortcutMenu(ContextMenu).    How do i disable it Please help!    I know that Framework SDK 2.0 has a new WebBrowser Control that contains a property named 'I sWebBrowserContextMenuEnabled' (bool), and you can set this to false, and the problem is solved.    But i'm forced to work on Framework 1.1. ...Show All

• Visual Basic Creating a dataset by dragging and dropping the table form MySQL database.

  With Oracle database, I used to be able to create a dataset by making a database connection in the server explorer and dropping the table onto the dataset designer view. Can you advise if the same would work for MySql database and how. I get the foll error : Mouse drag opertaion failed. The table, view or table-valued function named ''parts'..'PO_mast'' could not be found. Foll. is the error if I try to add a Table Adapter using the wizard, when I hit Finish. An unexpected error has occured. Error Message: Object reference not set to an instance of an object. I am able to access the database from out of Visual Studio. Infact within the VS ...Show All

• SQL Server SQL 2000 Enterprise to SQL2005 Standard

  Can you downgrade a SQL 2000 Enterprise - active/passive cluster to a SQL 2005 Standard active/passive cluster No. It is blocked to downgrade a SQL Server 2000 Enterprise to a SQL Server 2005 Standard. S ee the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. But you can install a SQL Server 2000 Enterprise and a SQL Server 2005 Standard side by side successfully on the same machine. ...Show All

• .NET Development [net2.0] FTP - GetFileSize

  Hi! I want to retrieve the Filesize of a file on  a ftp-server. I tried this listing :         Dim size As String         Dim reader As StreamReader = Nothing         Try             Dim request As FtpWebRequest = WebRequest.Create("ftp://server.com")             request.Credentials = New NetworkCredential("anonymous", "anonymous")             request.Method = WebReque ...Show All