mrshrinkray's Q&A profile

• SQL Server Error message returned when executing package via C# app on Citrix

  Hi, I'm at a loss as to why i am getting the following error: Retrieving the COM class factory for component CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E}failed due to the following error: 80040154 I am calling the package from a C# application which i have installed within a citrix environment. The application works without any trouble on my development machine but as soon as i run the code that executes the SSIS pacakge i get the error. Can anyone enlighten me as to what is causing this Many thanks in advance, Grant Hi Grant, Error 80040154 is the error you'll get when a class is not registered. Are you referencing any assemblies or 3rd party components that aren't installed on the citrix server Make ...Show All

• SQL Server SQL Express and SQL 2005 developer edition on same machine

  Hello, I am wanting to setup both SQL Express and SQL 2005 developer edition with visual studio 2005 professional on the same machine and want to make SQL dev edition the default local accont to where I can set the sql connection to server=localhost. Is there a way to do this Thanks So, I then should proably install SQL 2005 dev as default instance, then go ahead with the visual studio 2005 pro with SQL express installation after, correct Also, I am seeing this in the IIS ASP.net configuration settings connection string data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true. I am assuming that sql express is the default server. ...Show All

• Windows Forms changing font properties programatically...

  Hi, Lets say I have coded a column for my dataset containing comment: For Each di As DataRow In perTable.Rows If ( CInt (di(sC1)) > CInt (di(sC2)) And CInt (di(sC1)) >= pSm And CInt (di(sC2)) >= pSm) Then di.Item( "Comments" ) = "Dropped in score" End If Next Now if I want to change how the comment font looks like for example in a different colour or different size, can we do this programatically. Thank you. Sorry for the lack of dtails. I am displaying as part of a data set through a datagridview. As part of my final project app, I am trying to make the conents of the "comments" column change from its normal font to h ...Show All

• Visual Studio Team System New Team Foundation Server MSSCCI Provider Available Now!

  I am happy to report we have released an updated TFS MSSCCI provider here . We have been able to address a number of requests (keep them coming) in this release including the following: PowerBuilder support Enterprise Architect support Improved Open from SCC experience Work items can now be modified in the checkinwindow Get latest on checkout support Check-in lock is treated as exclusive Setup works on x64 This is an unsupported "powertoy" like tool. There have been some discussions about the possibility of supporting it, but nothing yet. Keep reporting issues and comments to the forum or by e-mail . I have installed this thing in the hope of using it to manage my VS.NET 2003 projects wi ...Show All

• .NET Development How Load a XML file with a XSD file into a DataSet

  Ok im in trouble! this night i drink some weird stuff with some friend's and i cant think straight and simple i dont understand... "plus" i never work with XSD files so... i sucks today! Any help would be great!! Thanks. Acctually i was doing this: // If the Xml file is Big this is the way dataSet1.ReadXmlSchema(TheSchema); foreach ( DataTable dataTable in dataSet1.Tables) dataTable.BeginLoadData(); dataSet1.ReadXml(TheXmlFile); foreach ( DataTable dataTable in dataSet1.Tables) dataTable.EndLoadData(); So Obvious I am ashamed. Sniff. but my real problem is how load this data into a DataGrid... the stupid Schema file has 35 tables!... im doing this only to view the data my final task is cre ...Show All

• Visual Studio 2008 (Pre-release) versioning in WCF?

  Is versioning, according to this article: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnservice/html/service10152002.asp the recommmended (up to date) practice for versioning service contracts for web services headed to WCF I have a chance to create a versioning strategy, right now, for our WSE2 (later, WSE3 & WCF) web services. I appreciate any help. Thanks. As of the November CTP, VersionAdded is gone, but I have written an article on contracts here: http://www.dasblonde.net/PermaLink,guid,91973b53-b5a2-4bf8-ad20-ec504db2da99.aspx and have posted a short commentary on versioning here: http://www.dasblonde.net/PermaLink,guid,a0b48932-4b7d-4d7b-9886-e7d0764d8908.as ...Show All

• Smart Device Development login screen acting as a spash screen

  I am having some issues with my login form. Its acting like a spash screen where it stays on only for a few seconds until my program loads and then closes. I have made sure that I created the login form with the template and checked my code, but it shouldnt be that difficult! Help! nope..its definately gone! I thought about that too but I closed out all the other windows and its not there. i am just so confused as to why its taking on all the characteristics of a splash screen. I had created a splash screen as the login screen, but realized there was a template for the login screen so I made sure to delete the splash screen and create a completely new login screen. But its like the new login templa ...Show All

• Windows Forms Dropdown List

  Is there a way to make a Dropdown List typing enabled in a web application. Thank you in advance hello U_T_A I dont thnk that we can attempt this,because its against the design of that control ,but again why did u actually need such a functionality ...Show All

• Visual Studio Team System Project reference

  Hi! I have one solution with several projects. I have configured the project dependencies using the "Project Dependencies" and the "Project Build Order" dialogs. The solution builds fine on every developers PC, but when we let the builder do the job it is unable to detect the project dependencies. It seems from the log that the builder is not even looking for the referenced project, it just says I have the following projects (in dependency order): Infrastructure.Interface, Infrastructure.Library, Infrastructure.Layout, Infrastructure.Module The first error message I get is on compiling the Infrastructure.Library : error CS0234: The type or namespace name 'Interface' does not exist in the namespace I'v ...Show All

• SQL Server update problem within cursor

  Hi there I written some tsql that uses a cursor to update certain tables in a database. --CURSOR TO REPLACE SYS__DB VALUES WITH 20202 DECLARE @V_TABLE_NAME NVARCHAR(128) DECLARE @V_UPDATE_SYS_DB NVARCHAR(128) DECLARE @V_DB_NAME NVARCHAR(128) DECLARE dbnames_cursor CURSOR FOR SELECT ENT_ID FROM VehiclesSYS.dbo.ENTITIES WHERE ENT_IS_VIRTUAL = 0 ORDER BY ENT_ID; OPEN dbnames_cursor FETCH NEXT FROM dbnames_cursor INTO @V_TABLE_NAME WHILE @@FETCH_STATUS = 0 BEGIN /* Process each database here. */ SET @V_DB_NAME = N'USE PEOPLE' EXEC sp_executesql @V_DB_NAME SET @V_UPDATE_SYS_DB = N'UPDATE @V_TABLE_NAME SET SYS__DB = 20202' EXEC sp_executesql @V_UPDATE_SYS_DB The problem lies with the update statement. T ...Show All

• SQL Server Bulk Insert Task - Where Does The First Row Begin?

  Hi, I am using the Bulk Insert Task to bulk copy data from a flat file to a SQL Server 2005 table. The flat file contains pipe ( | ) delimited columns and several thousand records which are {CR}{LF} delimited. The file also contains a header record and trailer record, which contain several words but also contains a ( | ) symbol among those words. E.g.: HEDR | yadi yadi yada 500 | Data Data | More Data | 600 460 | Datum | More More | 705 550 | Data | Data | 603 FOOTR | yadi yadi yada I need to ignore the header and trailer records and just pickup the proper records. But even though I manually set the First Row property to 2 and the Last Row property to 4, It does not pickup the first true record i.e. the record which begins wit ...Show All

• Windows Forms .NET 3.0 Pre-requisite Error - Please help

  I'm trying to build a setup for my application using a Windows Installer project. I'm using VS2005. My Windows application requires .NET 3.0, so I marked that as one of the prerequisites. But the installer gives the below build errors: Error 9 No 'PublicKey' or 'Hash' attribute specified for file 'NETFX30\Dotnetfx3.exe' in item '.NET Framework 3.0'. D:\Bancassurance\Deployment\BancaServices\Bancassurance.NETServices.vdproj Bancassurance.NETServices Error 10 No 'PublicKey' or 'Hash' attribute specified for file 'NETFX30\Dotnetfx3_x64.exe' in item '.NET Framework 3.0'. D:\Bancassurance\Deployment\BancaServices\Bancassurance.NETServices.vdproj Bancassurance.NETServices Error 12 General failure building bootstrapper D:\Bancassura ...Show All

• SQL Server Quorum & MSDTC Cluster Questions

  We are trying to setup a Windows Server 2003 Cluster with 2 systems and a DAV. We intend to install SQL 2005 on this Cluster. We purchased a DAV with 3 physical disk arrays as follows. 73GB RAID 1 (our plan is to use this to store sql transaction logs) 146GB RAID 1 (sql backups, temp database & other temp files) 420GB RAID 10 (sql databases) Now as we are setting all this up we find out we need a shared physical drive on the DAV to store the Quorom. It is my understanding we cannot partition the physical drives and use one of the partitions to store the Quorum because when you create the resource for the Quorum the resource is the phsyical disk not the partition. So my question is, is it in our best interest to buy a seperate ...Show All

• Visual C# DateTime.parse problem when i change language

  Dear All DateTime.parse giving me problem when i change language, the exception is " the conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value" The best way to parse a date is to use ParseExact or TryParseExact methods. Can you describe what is your scenario of conversion. The smartest way to work with dates is to not have any conversion and to work with typed datetime values only. ...Show All

• Visual Studio Tools for Office VSTO2005SE

  I have a VS2005 Prof project I built for Office 2007 using VSTO2005SE that modifies the ribbon yet I cannot get the callback from a button to call the sub I have created for it. I suspect That I installed something wrong. I discovered a web site with pretty clear instructions (for this mere mortal) http://msdn2.microsoft.com/en-us/library/ms406046.aspx . I descided to start over with a new project - paying careful attention to instructions provided. Now things are more strange I cannot find Microsoft.office.interop.word in "add references" anywhere. At least not by that name. My previously mentioned project shows the dll in reference but I have no idea how I got it there. I could use some help on how to make this available. ...Show All