Tryin2Bgood's Q&A profile

• SQL Server Distribution Job Step Retries all in one connection and/or transaction?

  When a distribution job step "Retry Attempts" is > 0 and the step has certain problems, the step is "retried" after "Retry Interval". But I am uncertain as to the details. Are the retries within one database transaction Does each "try" get its own transaction And what about connection Is the "retry" done with the same connection I know this may sound funny but I would like to know exactly what is going on here. Thanks, I am pretty sure that each retry spawns its own transaction - any failed attempt will rollback the current transaction. And the retry is done in the same connection unless it's a retry due to a connection issue. I can try to cla ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Need a PDA or Hendheld with hardware support for Mobile Direct3D

  Hi there, i found in the .NET Compact Framework 2.0 the Microsoft.WindowsMobile.DirectX Assembly. A quik review to the sdk i made a simple 3D application for a Windows Mobile 2005 pda. I can test this with the emulator of the Visual Studio .NET 2005 IDE, but on my Windows Mobile 2003 SE with installed .NET 2.0 i get an exception by the DirectX Assembly. Where in hell i can get a Pocket PC, PDA or Smartphone where i can test Mobile DirectX I found the chips NVidia GForce 5500, Gforce 4800 and a Intel 2700G with 3d capabalities. Does thouse chip run with Mobile DirectX And who manufactor produce a device with that chips Thanks, Dodo502b Thanks for this link, but this information about current devices is to old. Whats about the ...Show All

• Windows Live Developer Forums Article: Redesign the Virtual Earth Dashboard

  Hey guys, I just put together what i hope is a really good reference for anyone wanting to change the look and feel of the V4 virtual earth dashboard. http://www.soulsolutions.com.au/Articles/VEDashboardStyles/tabid/101/Default.aspx Let me know if I'm missing anything. John. According to John's kick-*** reference, add the following to the sample I gave above: navAction_ObliqueMapView{visibility:false} Cheers, Greg ...Show All

• Visual C# Is there a event for Minimize button clicking?

  What I want is that clicking the Minimize button in the application's titlebar to hide it (this.Hide();) but not just minimize it. So I m looking for a event in VC# for the clicking on Minimize button to do that but I failed. Any help will be appreciated! Cool, it works. Thanks! private void Form1_Resize(object sender, EventArgs e) { if (WindowState == FormWindowState.Minimized) { this.Hide(); } } ...Show All

• Visual Studio Automation server can't create object - figured out my problem

  Recently I was working in Microsoft Visual Studio .NET 2003 and all of a sudden I couldn't create a new project. I tried creating a Visual C++ Project (Console Application .NET) but I always got the error message: "Microsoft Development Environment >> Automation server can't create object". I then searched Google for that error message and found a page that said that downloading the "WindowsXP-Windows2000-Script56-KB917344-x86-enu.exe" update would fix this ( http://www.microsoft.com/downloads/details.aspx familyid=C717D943-7E4B-4622-86EB-95A22B832CAA&displaylang=en ) So I downloaded that update and installed it. When the computer restarted I got the error messsage "Error registering the OCX C:\Windows\sy ...Show All

• SQL Server How do I use a variable to specify the column name in a select statement?

  How do I use a variable to specify the column name in a select statement declare @columnName <type> set @columnName='ID' select @columnName from Table1 In addition to that and to make you aware of the problem about dynamic SQL you should read the following article: http://www.sommarskog.se/dynamic_sql.html HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creative X-Fi support

  Hi I was wondering if XNA / XACT can support the advanced features of Creative's X-Fi range of soundcards. I mean things like preloading sounds using X-Ram which is supposed to help increase frame rates. XACT uses its own software mixer; it doesn't use OpenAL. One of the goals was to provide a consistent experience across all systems. Therefore, it will not take advantage of hardware accelerated cards such as the X-Fi. However, XACT does fully support surround sound, so if an end user has a multi-channel sound card or a PC with built-in multi channel outputs, you can still do 3d positioning and the user will hear it in proper surround sound. -Brian ...Show All

• .NET Development Datasets and SQL Server

  I'm currently working on a application in VB.NET 2003, with a SQL Server backend. I was asked to make an import function that would allow a user to import an Excel worksheet into SQL Server. I'm aware you can do it from Excel directly to SQL Server, but the clients would like something that wouldn't involve the users of this application touching the SQL Server. I'm using an OLEDB for the Excel connection, and a ODBC connection for the SQL Server connection. Next, I have a button event that would open up a OpenFileDialog window, and a user can choose an Excel sheet. If the Excel sheet is valid, it would go on extracting the data into a dataset: ds = New DataSet ds.Clear() strSQL = "Select HEAT, Practice, C, Mn, P, S, Si, Cu, ...Show All

• Microsoft ISV Community Center Forums "Building Custom Report Views Webpart"

  Hi, I downloaded "Building Custom Report Views Webprt" white paper from the Microsoft site and tried implementing it. I intially created a Windows Control Library project and created a usercontrol. I built this application in to a DLL,created a strongname to it and then put this asembly in GAC. I then created a pmbuilder.exe.config file in the location given below. "C:\Program Files\Microsoft Office Business Scorecard Manager 2005\Builder" The content of the file is given below:- <configuration> <configSections> <sectionGroup name="Bpm"> <section name="CustomReportViews" type="System.Configuration.DictionarySectionHandler, System, Version=1.0.5000.0, Culture=n ...Show All

• Software Development for Windows Vista Calling GetWorkflow multiple times for same instance

  I'm new to WF and still in the experimentation phase. In any case, I came to scenario that seems a bit confusing and was wondering if anyone can shed some light on the matter. I have a very simple sequential workflow that has only one code activity which writes to the console, sleeps 10 seconds, and writes to the console again. To run this, I've created a Windows application with two buttons and their click events are as follows: private void button1_Click(object sender, EventArgs e) { WorkflowRuntime wfr = new WorkflowRuntime(); SqlWorkflowPersistenceService persist; persist = new SqlWorkflowPersistenceService(...); wfr.AddService(persist); wfr.StartRuntime(); WorkflowInstance wfi = wfr.CreateWorkflow(typeof(MyWorkflow ...Show All

• SQL Server SSIS - SQL Server Developer to Express Edition

  Hi, Does anyone know if it is possible to use SQL Server Developer Edition to produce SSIS packages that will operate on a remote SQL Server Express Edition database The situation is such that it is easiest to install a SQL Server Express Edition database on a remote server (for use within a company intranet) due to server availability and licensing restrictions. It would be great to be able to do Excel round trips with the data though - would it be possible to use SQL Server Developer Edition to do this on another computer, and have it update the data in the Express database Thank you for your time. Kind Regards, Ray Muirhead SQL Server Express Edition does not contain SSIS, and you cannot execute SSI ...Show All

• SQL Server Installing SSIS with SQL Server 2000

  Hi All, I have installed SSIS on server running SQL 2000 but I don't see the Business Intelligence or SSIS. I could see the SSIS service is running but do not see VS or BI version of VS. Any ideas Thanks in advance. That was my understanding too but after installing SQL 2005 client tools and Integration Services, I don't see the BIDS. ...Show All

• Visual Studio Team System Unit tests not run when building ASP.NET site

  Hey. I just created a team build for an ASP.NET site with unit tests. However, the tests are not run and I'm not sure where to begin looking. Could anyone help me out The BuildLog.txt states: Target CoreTest: Creating directory "C:\DailyBuilds\Tove\ToveDailyBuild\BuildType\..\Sources\..\TestResults". __________________________________________________ Project "C:\DailyBuilds\Tove\ToveDailyBuild\BuildType\TFSBuild.proj" is building "C:\DailyBuilds\Tove\ToveDailyBuild\BuildType\TFSBuild.proj" (RunTestWithConfiguration target(s)): Target RunTestWithConfiguration: TestToolsTask MetadataFile="C:\DailyBuilds\Tove\ToveDailyBuild\BuildType\..\Sources\Ebutik\Ebutik.vsmdi" TestLists=& ...Show All

• Windows Forms Stopping long running SQL in OleDb

  I have a program that will execute various SQL statements and return their results to the user. On occasion the user will enter a SQL statement that will cause them to sit for a while waiting. In such cases I want to give them the option to cancel the request that they made. Is there a way to get a OleDbConnection object to cancel all its requests I have tried doing a simple [Close()] on the connection object but it will throw an error saying that the connection is in use. Didn't you check OleDbCommand.Cancel(); method Here: OleDbCommand command = new OleDbCommand(queryString, connection); command.Connection.Open(); command.ExecuteReader(); command.Cancel(); // Cancel To do this form other butto ...Show All

• Visual Studio Team System Open source query in Stored procedure returns an error

  I noticed when trying to do "write updates" or "export script to editor" with a stored procedure that had an open source query I recieved and error because it was within the begin transaction statement. When I remove all the transaction statements it ran fine and this scripting error only occurs when doing a "write updates" or "export script to editor" type update, with deploy there isn't an issue. ...Show All