djenerate's Q&A profile

• SQL Server cannot convert between unicode and non-unicode with SQL Server

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I bel ...Show All

• SQL Server How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. first thing is how to search the keywords from the tables Second thing after u search the result ,how to link the result to a number related to the result ...Show All

• SQL Server Error updating data in table that uses a trigger?

  Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error: ------- The data in row 1 was not committed. Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) update ...Show All

• Microsoft ISV Community Center Forums Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• Visual Studio Team System Performance testing basics - what are some good metrics?

  Hi everyone, I got pulled into a performance testing project and I don't have any previous experience. My company is also just starting out with performance testing of our software, so we are still trying to determine the approach, what metrics we should collect and so on. We are planning to use VSTS's Load Test. There are so many different counters and metrics there, where do I even start It would be very helpful if you could share your &qu ...Show All

• SQL Server Failed to generate a user instance of SQL Server

  Hello Everyone, I have instaled SQLExpress September on my Windows Server 2003 Standard. and I work on a windows XP SP2 for development using Visual studio Web Edition (Beta2) which comes with sql server 2005 too. I've built my application and tested it on my computer and everything went fine. But When I copied the application to the server, it showed the following error: "Failed to generate a user instance of SQL Server due to failure in retr ...Show All

• Visual Studio 2008 (Pre-release) wsDualHttpBinding and TimeoutException

  Hello, I am trying to develop an WCF service with enabled duplex communication between client and service. WCF service is hosted under Windows Service. Everything works fine if I use client and service on the same machine. If service is located on the remote machine, no calls pass through for services configured for wsDualHttpBinding. All of them end up with TimeoutException. Client and service machines are in the same domain. For testi ...Show All

• Visual Studio Team System Object Reference not set to an instance of an Object

  I really would like to use this tool, but when I try to import a database, all I get is the error message "Object reference not set to an instance of an object." I'm working on a 2000 database (sp3a if that matters) where I have sysadmin privileges. I just don't understand why this isn't working. Any help out there OK. A bit more information. My normal login is not the admin on my box (security ...Show All

• SQL Server Error on Attaching SQL server 2005 DB

  Hai When i try to attach (using raw .mdf & .ldf)  DB that was detached from another SQL Server 2005 instance. I got this error The database 'Content' cannot be opened because it is version 611. This server supports version 603 and earlier. A downgrade path is not supported. Could not open new database 'Content'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948) How can i slove this Error Regards It ...Show All

• Software Development for Windows Vista Using data objects from database for holding Workflow/Activity-Properties

  Hello, we are building a end-userfriendly workflow engine (with own designer) (see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=265499&SiteID=1 ) I have only on question (at the moment). Our activities have some properties, all workflows are derived from our own base workflow (with some properties, for example a workflow object which is sent through the whole workflow). The workflow object is used in IfElseActivities. ...Show All

• .NET Development System.Web.Mail.SmtpMail.Send breaks on attachments > 100kB

  Hello, I am attempting to send HTML email with attachments using System.Web.Mail.SmtpMail.Send. This works great, until the total attachments size exceeds about 100kB. Then I get: Exception of type System.Web.HttpUnhandledException was thrown. System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. ---> System.Web.HttpException: Could not access 'CDO.Message' object. ---> System.Reflection ...Show All

• Visual Basic Find Data in VB2005 program

  In VB2005, can I search for specific text or numbers that I want to review or edit (just like find button of MS-Access 2000 Form) in running mode. running mode mmmmmm You can search for any characters in your project using Edit - Quick Find...now that is used in the design environment...as far as searching when in runtime...you would have to implement a search routine for your application! ...Show All

• Visual Studio Add IVsUIHierarchy to Team Explorer

  Hello, I've been trying to extend team explorer with my own hierarchy.  I can get it to the point where my root node shows up fine, and there is a plus icon next to it indicating that it knows there are leaf nodes inside of it, but if I try to expand it, the leaf nodes don't show up and the plus icon disappears. In my implementation of the BaseUIHierarchy class, I've added trace statements in ExecCommand and QueryStatusCommand, but they nev ...Show All

• Visual C# Generic math functions

  I want to create some functions that operate only on the numeric types but I don't particularly care what those types are. I'd rather rely on the invoker or .NET's automatic casting rules to create the answer in the appropriate type. I could declare two versions of every funciton one taking and returning doubles and the other decimals but that seems excessive and slow. Is there a way to make a function generic yet restrict its parameters to nume ...Show All

• Visual Studio Express Editions Visual Web Developer Express - No Publish Button

  Hi, I am trying to publish an website that I built with VWD.  I test the site (f5) and it works well, but when I try to publish the site, the only choices I get is build website or copy website.  I do have IIS 6.0 server with asp 2.0 loaded and ready to go, and I can connect to it, but I can't seem to publish to it.  Has anybody run into this and have a solution   PS I'm using a connection to sql server 7.0 which VWD and my s ...Show All