IceHeat's Q&A profile

• SQL Server Calling SSIS packages from ASP.NET - Packages with file system tasks end abruptly

  I've run into a problem with SSIS packages wherein tasks that write or copy files, or create or delete directories, quit execution without any hint of an error nor a failure message, when called from an ASP.NET 2.0 application running on any other machine than the one where the package was created from. By all indications it appeared to be an identity/permissions problem. Our application involves a separate web server and database server. Both have SQL Server 2005 installed, but the application server originally only had Integration services. The packages are file system-deployed on the application server, and are called using Microsoft.SqlServer.Dts.Runtime methods. For all packages that involve file system tasks, the above problem occurs ...Show All

• Visual Studio Express Editions My EXE that I created will not Run on windows 2000

  I created a application that need can run on Windows XP but not on windows 2000. I need to install .Net on the 2000 machine to be able to run the application or shall I say the tool that I created. The qtion is, DID I DO ANYTHING WRONG, or is there a way to create an EXE using the MS visual basic 2005 that will run on both plate forms thanks Wajdi Georges Do you mean VB2005 and not VB5 VB5 is very old (and if you downloaded it, also illegal - regardless, this is not the place for VB5 questions). There is a Process.Start() command you can use to call the shutdown.exe. ...Show All

• SQL Server File in use error on connecting to database.

  * Running SQL 2005 on XP Pro * After running a ETL package to populate a sample DW which completed successfully, I attempted to open the SQL Server Management Studio.  After login, an error was reported : TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc ...Show All

• Visual Studio Express Editions Form Questions

  Hi, I am having trouble with a timer application i am making. I need to make the form central to the x axis, wahtever the resolution, but the y axis must always be at "0". Also, i would like to change the blinking cursor which you type from in a text box to a green square instead of the traditional line. any helop on this would be appreciated. Any Help would be good Thanks Jamie Private Sub TextBox1_KeyDown( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown If e.KeyCode = Keys.Enter Then Dim upstr As String = TextBox1.Text.ToUpper If upstr.IndexOf( "TEST" ) <> -1 Then ' Re ...Show All

• Windows Forms Adding background to toolbar

  Is it not possible to add a toolbar background image there is no option in the vis studio designer that i can see. ...Show All

• Software Development for Windows Vista parallelism in state machine

  Is it allowed to transition to multiple states (can a state machine workflow instance be in more than one state at any given point in time ) I just want to make sure. I'm seeing that it's possibly to drag a parallel activity to an event activity, but that this is only a "parallel sequence activity". Thanks. Hi - I am facing the same problem that u r facing. What i did I make State2 ......State6 as a bool property. Suppose i get Sate 2 event i made it true if i get State 4 then i made state 4 as true. It works fine. But in my Host i want to know what events has been finished. means i want to query what events r finished from State2 to State 6 and what r left. Thanks Bharat ...Show All

• Visual Basic Can't Get VB6 Serv Pak 6 to install in Vista RC1

  Has anyone gotten VB6 Service pack 6 to install in VISTA RC1 I tried and it errors out with some cryptic error about a missing file and quits. VB shows no sp installed and programs that were created with SP6 installd on XP will not run in the API on Vista RC1 with an error message "Component missing". Has Microsoft a fix for this We have lots and lots of custom written programs that we will have to maintain and support on VISTA (if installed) and there seems no way to do it because the service Pack 6 can't install. Courtney, I'm the Program Manager with Microsoft that is responsible for Visual Basic 6 running on Vista. The Visual Basic 6.0 runtime is supported on Windows Vista. The IDE is still supported, ...Show All

• .NET Development Type of File

  Hi Guys, How can I extract the information of a file like 'Type of File' ex. Type of File: Microsoft Excel Worksheet. I am able to extract the other information like Last Access..using FileInfo. But I can't find the value for the said subject. Can you please give me a sample code 'coz I'm just new to Visual Basic 2005 Thanks in advance. I am not sure, if I understood... If you want the type of an object, you can use: <object>.gettype.tostring... If you want the type of a file, you can read its extension with: IO.Path.GetExtension(<path>) Examples... Dim exc As New Excel.ApplicationClass Debug.WriteLine(exc.GetType.ToString) ' -> "Excel.ApplicationClas ...Show All

• SQL Server Replication Issue with Dynamic Filter using HOST_NAME()

  Dear ppl, I am having a couple of problems with using dynamic filters in Merge Replication (SQL Server 2005 - SQL Mobile) 1) I am trying to add a dynamic filter to my publication using the wizard as follows: SELECT <published_columns> FROM [dbo].[Audit] WHERE AuditorID = CONVERT(int,HOST_NAME()) This gives me an error Conversion failed when converting the nvarchar value 'MSSWS02' to data type int. because my computer name cannot be converted to an integer. After reading on http://msdn2.microsoft.com/en-us/library/ms152478.aspx I have found that it has been recommend specifying CONVERT(nchar,AuditID) = HOST_NAME() in the wizard and then use sp_changemergearticle to change the clause to AuditID = CONVERT(int,H ...Show All

• Visual Basic want custom color when selected datagridview cell instead of default dark blue.

  how do I achieve that Is there just a property setting I can choose to provide a cell to display a, eg. purple background, instead of the dark blue one which is what always appears when I click on a cell Thank you, -greg got the answer With GridView .DefaultCellStyle.SelectionBackColor = System.Drawing.x ...Show All

• Visual Studio Mysterious VS JIT debugger invocation failure

  I've got a mystery.. I can't make the VS 2005 JIT debugger automatically invoke any longer. It used to work properly until yesterday. An application crash would bring up the standard crash requester with the "debug" option. Clicking Debug would bring up the VS 2005 IDE and I'd be happily debugging. But now.. I click "Debug" and nothing happens. The crash dialog disappears and nothing, just my Windows desktop. VS is working with no problem. I can use the IDE, compile, everything. I can also use the debugger directly by attaching to a running process. So the actual debugger works with no issues. So I tried to go through all the steps why the JIT debugger wasn't starting up. I went into VS 2005 Options, and made s ...Show All

• Visual Studio Team System TFS and IE7

  Has anyone encountered problems installing TFS on a Windows 2003 Server running IE7 TIA, barkingdog ...Show All

• Visual Studio Express Editions Search local Help files

  When I use the "Search" feature of Help, I get plenty of hits from MSDN, CodeZone, etc, but nothing from the local help files. This only affects "Search". I can access local help through the "Index" or "Contents" tabs. This has not always been the case. It used to work fine. I think it broke when I updated SQL books online. I suspect a setting has been changed somewhere, but I cannot find it. Any suggestions Thanks, Mable The default context for searching local help is bizarre: Templates and Starter Kits. Everybody is a beginner once, me too. Click on the Content Type arrow and select "All". ...Show All

• SQL Server Identity sequence for multithreads insert

  Recently I'm working on a multi-thread solution based on SQL-Server, now I'm facing such a problem:     Suppose I have process No.1(with multi-threads) inserting data to Table A, which has its identity column auto generated. And process No.2(also with multi-threads) retrieving data from Table A ,generate some records and insert the result into Table B. Both of these two processes are doing batch processing(batch retrieving and batch writing), and they are running parallelly.     Now since process No.2 retrieve data sequencely by the identity of Table A, it found there exists missing results. This is due to that records with bigger identities are not necessarily commited earlier than those who h ...Show All

• Visual Studio Team System Unlocking a checked out file

  A developer has checked out files for edit but locked it during the checkout process. How can I, havine administrative permissions, unlick this file so other developers can check the file out The "lock" item in the context sensitive menu is greyed out. In fact, can I disable the locking at all Thanks, Maggie Maggie, I'd download and use the Status Sidekick component of the Team Foundation Sidekicks product from Attrice Corporation. I use this often for just this purpose. The tool is free and can be found at this URL: http://www.attrice.info/cm/tfs/index.htm - Steve ...Show All