Andrew Millspaugh's Q&A profile

• SQL Server Gurus: Please help! SSIS package using custom dll fails on server

  I have a SSIS package that has a script component. In the script I reference a custom dll that contains some functions. The dll is registerd with a strong name in the GAC on my machine and the SQL Server 2005 box. The package works fine in Visual Studio. The problem lies when I deploy the package to the server. (note: several other packages created without the dll work fine on the server). Is there something else that has to be configur ...Show All

• Visual C++ C1083: Cannot open include file: 'crtdefs.h'

  Hi ALL: The Story so far ... We are trying to get C++ Express to go! So Far it is not doing anything except giving cryptic error messages. Build Log Build started: Project: TIM, Configuration: Debug|Win32 Command Lines Creating temporary file "f:\Program Files\Microsoft SDK\Bin\HELLO!\TIM\TIM\Debug\RSP0000392883768.rsp" with con ...Show All

• Windows Forms Double click ListBox

  I have populated a list box with a dataset.  I would like to double click on a row and have it copied to another list box.  Any suggestions.   If you mean that you simply want to double-click on an item in  ...Show All

• Visual Studio Language Service Options - what's the correct approach?

  What is the recommended approach to adding options to a Language Service DialogPage provides an easy way to add Options pages. Visual Studio then manages the presentation and serialization, but it seems hard to access the values actually in the page each time via the DTE. What is the role of the LanguagePreferences class The documentation suggests extending it, but they you have to manage the serialization, loading, etc. The XML Editor seems ...Show All

• Smart Device Development Problem with Binding Source witn ResultSet as datasource

  I have a binding Source witn a ResultSet as datasource,I use resultset instead of a dataset becasue the DB that i’m working witn has 30000 and witn a dataset the aplication is to slow and uses a lot of memory. But I have a problem: When I try to cast bindingsource current Item to datarowview,i have this exception "InvalidCastException",this exception also occurs when I’m try to addnew Item to my bindingsource. Dim DRV As ...Show All

• .NET Development Using transactions with TableAdapters

  I have several table adapters, each with an InsertCommand (among others). I call BeginTransaction before I start calling Update for each adapter. Update results in the InsertCommand being used but I get an exception because the command has no transaction. The commands are private members of the VisualStudio-generated adapter classes so I cannot access them to set their Transaction members. Is there a "proper" way to do this (In case it ...Show All

• Smart Device Development Non-public methods/members for CF DataGrid?

  Where I can find some full info for DataGrid (public/non-public members/methods) - Compact Framework I'm also interested to find such info for other standard Windows.Forms controls (UML, descriptions, and more...) Thanks! Try here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemwindowsformsdatagridclasstopic.asp If you expand the tree, the members, properties, ...Show All

• SQL Server How do I get the script to create a table & all the Indexes

  In SS2K I could go to task and it would script the table, indexes and any other script that was set for that table. How do I do it with 2005 Thanks Right click on a database, select all tasks, generate scripts and then just follow the steps. If you are using SSMS Express it is not included. ...Show All

• Visual Studio Crystal report using dataset read prompting for database login on a deployment machine

  Hi,   I created a windows application that reads data from ms-access database using OLE DB connection. I used push method (filling dataset and adding dataset to the report object). Everything is working fine on my development machine.       I included merge modules during build process and created msi. When I installed the app in a different pc, the database login screen pops up with already fill ...Show All

• SQL Server using package variables as parameters in Execute Sql Task

  Hi, I need to run an SQL command, in which one of the fields is based on the current time, represented as a string in a specific format. I used a script task to create the string from the current time, and store it in a package variable named "newDate". Later, in the execute sql task, I have the following update statement: "update table_1 set field_1 = " (OLE DB connection is used) and in the parameters mapping I set ...Show All

• Visual Studio Team System Code Coverage just for Unit Testing

  Hi, Is there any way to use Code coverage capabilities with Web Test, Generic Tests and Manual Tests It would be nice to know the coverage of all my test not just the developer ones. Thanks LucasC To clarify some more... Web Test - already enabled for Beta2 Generic Tests - already enabled for Beta2 Manual Tests - coming soon Unit Tests and Load Tests should work as well. Chris ...Show All

• SQL Server Trying to SET a variable from a SELECT

  Hello, Wondering why the following won't work: DECLARE @objName VARCHAR(50) SET @objName = 'happyhippytable' set @objCnt "select count(*) from " + @objName + " where begtime > endtime " or set @objCnt ("select count(*) from " + @objName + " where begtime > endtime ") or set @objCnt = ("select count(*) from " + @objName + " where begtime > endtime ") or ...Show All

• Visual FoxPro Foxpro, or Access, or Filemaker?

  I was a professional foxpro programmer 9 years ago, and haven't used it since. I have written some fairly large programs, including my first, which was the tax collection system for Samoa. My last version was the first windows version. Unfortunately, that version, will no longer run on the current XP operating system. I now own a wedding photography business, and need to track leads, and send emails, write invoices, and keep track of servic ...Show All

• SQL Server Encryption not supported on SQL Server - Error Message

  Hi, When I click on the MSDB node, under Stored Packages (in Object Explorer | my local server's Integration Services), I get the following error message: Client unable to establish connection Encryption not supported on SQL Server. (Microsoft SQL Native Client) I can, however successfully, enumerate File System packages. I am running... Microsoft SQL Server 2005 - 9.00.1187.07 (Intel X86)     May 24 2005 18:22:46  &nbs ...Show All

• .NET Development Determine schemas used by document?

  Using .Net 2.0 what is the best way to determine the list of schemas used by a XmlDocument. I want to do two things: - dynamically determine what schemas are referenced in a document so I can build a XmlSchemaSet with the correct file paths to the actual schema files for validating the document. - check if a document uses a specific schema and if it does change that schema name to a different schema... Thanks Donal ...Show All