ii's Q&A profile

• .NET Development Using System.Transactions and System.Data.SqlClient.SqlConnection

  We are attempting to use the System.Transaction classes with a SqlConnection.  When we call the EnlistTransaction method we are getting an InvalidOperationException with the following message [Cannot enlist in the transaction because the connection is the primary connection for a delegated or promoted transaction.]  I'm pretty sure what's happening is that we are getting a pooled connection that already has a transaction reference and we are trying to set it again.  The error occurs in the System.Data.SqlClient.SqlInternalConnection.EnlistTransaction method.  This method is checking an internal HasDelegatedTransaction pro ...Show All

• Visual Studio Uninstalling Tool Output Question

  I try to uninstall everything related to VS2005 Betas (WebDeveloper, SQL Express and Studio Standard) The reason is that somehow the whole SQL Express thing did not work properly. Allways got some error message. Also I now have the final 2.0 .net framework installed. After a night of try and error I removed a lot or what I thought was everything. I do now run the uninstall tool (wich I found after that night) and get the following XML output: < xml-stylesheet type="text/xsl" href="C:\DOKUME~1\Markus\LOKALE~1\Temp\IXP000.TMP\issues.xslt" > <Issues> <Issue> <Name>Uninstall Visual Studio components</Name> <Id> ...Show All

• Visual Basic Wierd error message with Access DB

  Hi all, I have this wierd error message that I get when I use my DataAdapter.Fill function. The message is : "No value given for one or more required parameters" I just Cant figure it out, here's my fuction Dim strSQL As String Dim cmdSelect As New OleDbCommand dsIPBs = New DataSet 'Verification de l'existence du chapitre dans la BD strSQL = "SELECT * FROM PN Where PART_PK = '" & gIPB.PARTNO & "' AND NOMEN = '" & gIPB.NOMEN & "'" cmdSelect.Connection = cnNewIPBs cmdSelect.CommandText = strSQL daIPBs.SelectCommand = cmdSelect Try daIPBs.Fill(dsIPBs, "PN") Catch ex As ...Show All

• SQL Server Connecting Sql Server 2005 from ASP?

  Hi We are planning to move over to SQL Server 2005 in near future. At the moment Website is on a seperate server then the Database. OS for both the server is Window 2003 and currently our data is on SQL Server 2000(on which everything works fine). Part of the testing process we tried to connect our website on SQL 2005 and it does not work at all. I get this ---------------------------------------------------------------- ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. When i use following connection string "Provider=SQLNCLI;Server=127.0.0.1;Database=dbName;UID=UserName;PWD=Us ...Show All

• Smart Device Development "\Windows\wceload.exe", "/noaskdest/noui ?

  Hi, I am installing cab file of my application using wceload.exe. While my application already exist it gives message "My application is already installed.Reinstall I should not get this message and the application should silently installed.I tried using Rapi class of Opennetcf.Desktop.Communication as shown below.   Dim m_rapi As New RAPI m_rapi.CreateProcess("\Windows\wceload.exe", "/noaskdest/noui \Windows\MyApp_PPC.ARMV4.CAB") But still i am getting the message .So how can i prevent it Regards, Senthil. That is no really a surprise because you're trying to install that from none-existing fo ...Show All

• SQL Server dataflow and expressions

  Greetings! I am attempting to implement the following case statement BEFORE getting the data in to my destination table but I don't know how to create an expression for it. In the mapping section of my OLE DB destination component I can only do mapping but I can't actually manipulate the data before it gets to the destination table. What do I have to do to implement : case when SOPD.PRICE_TOP_NUMBER is NULL then -8 else SOPD.PRICE_TOP_NUMBER end AS price_top_number, before it goes to the destination column ! Thanks for your help in advance. It looks like you wish to manipulate the value of t ...Show All

• .NET Development Arrays/Trees In the Registry

  Hey, I tried searching to little avail. I'm relatively new to GUI programming, and the registry is therefore still a little new to me. I want to know how to store arrays and trees (i.e. a heirarchy styled thing) in the registry. Is there a better way other than storing 'key0', 'key1', 'key2', 'key3', etc. Because with multi-dimnsional arrays, this can get messy quickly. Is my best bet to serialise the object, and store it in there as binary Is there any reason not to do this Thanks. Josh. Fortunately, you can store binary data in the registry. You can serialize your arrays by transf ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Possible to apply shader to DX7 content?

  We are using an existing DirectX 7-based game engine to render 3d content. We do not have the source to the engine. We'd like to apply shaders to some of the objects rendered in this engine. Since it is DirectX 7-based, this seems like a technologically difficult, if not impossible, feat. Is this possible Impossible is a strong word. There is a way to do this but I am sure you want not go it because it is many work. It should be easier to port your game to a newer engine with shader support. ...Show All

• .NET Development .NET Redistributable and SDK for CTP releases?

  Does Microsoft release a redistributable and SDK for the Community Technical Preview releases for .NET 2.0   I can only find these installs for the Beta 2 release. I am developing an ASP.NET application, and I am using VS 2005 July CTP on a Windows XP virtual machine for development, but I would like to test it on a Windows Server 2003 virtual machine (which supports IIS 6).  The size of the virtual hard disk for the WXP + VS 2005 July CTP is 5 GB.  I'd much prefer to just have a redistributable (or the SDK if I need to debug something) to install on the test VM rather than have to install the entire VS 2005 package. Thanks, ...Show All

• Visual Studio Express Editions Saving My.Settings variables

  This is a two part question. My weather program stores a partner ID and license key for the user in My.Settings, as well as a string collection for their favorite zip codes. The app is set up to check my website for updates to the program and install from there. When you install a newer version of the program when it prompts you to, it makes you lose your My.Settings variables. I'd really like to not have to write these to a text file somewhere and then read them every time. Is there any way to stop this from being lost when you upgrade Also, I was trying to find where the program gets installed so I could look at the config file for it. ...Show All

• SQL Server Arithmetic operation failure. Is this a bug, or am I doing something wrong?

  I used the following code in a function. The @infloat is input parameter For every other number than 16.31, 17.31, 18.31, 19.31 and 20.31 (at least those numbers I checked) the code runs ok. For those numbers the result is wrong. What I want to do is return a ten digits number left filled with zeros, with the last two digits consitered as decimals. What I do is multiply the given float with 100.00, and take the resulting integer But when @infloat is multiplied with 100.00 and @infloat in (16.31, 17.31, 18.31, 19.31 and 20.31) the result is (1630,1730,1830,1930,2030) instead of (1631,1731,1831,1931,2031).. Can anyone try ...Show All

• Architecture N-tier layer separations and connection/interaction

  I happen to be experimenting based on some examples I've found on the net but I want to be directed to the right path, those samples tend to be incomplete or misleading. In a typical N-tier scenario, which should reference which And is the use of Data Transfer Object in accordance to any best practice that maybe existing Accordingly, how does those layers supposed to connect/interact with one another eg. what does BLL passes to the DAL and what is returned to it... What they pass and return depends on what your needs are. It could be a .Net DataSet, ADO RecordSet, XML, or some custom object. I'm currentl ...Show All

• .NET Development Windows App Not working over Network

  I've got a windows app that connects to a DB and copies a few files from a network share to the local PC. The app is ran on the network share because everybody in our company uses it and when modifications are made, we don't want to have to redistribute 50 or so copies of the .exe. Every time I run the program from the network, I get a standard Windows error and Microsoft wants me to send them the information, it doesn't get too involved other than that. BUT if I run the app from the desktop of the Network box then it runs fine. The network share can see the database and connect to it, so I know it's not that. It must have something to d ...Show All

• Visual Studio Team System Bug Rates Report - Getting very weird report

  The report "Bug Rates" used to work great. It shows us how many Work Items were in the System, how many were resolved, new active etc. (the way it should). I exported 250 Work Items from one of our products as a trial for TFS, threw them into Excel, and published. This worked great. The Report showed a huge spike of Work Items. Now, I've gone through all those Work Items, and instead of having them assigned to me, I have them assigned to "Administrator" who we're using as a place holder for Work Items not yet assigned until we have our meeting on what we should do with these. Now when I go to this report, it shows 0 for everything o ...Show All

• Visual Basic Displaying the procedure or sub where a error occurs to a user.

  Is there a way to display the name of the routine where an error occurs in my code using the framework Obviously, I could put the name of each routine in a message and so forth but that is just a bad design. I was hoping that I would be able to use Reflection or Exception handling to do this in a structured way. I have several applications that are monitored by IT professionals internal to the company who need as much information as possible about an error that occurs when support is not immediately available. Also there are reporting considerations for tracking the errors. ( source code with test ...Show All