bitbonk's Q&A profile

• SQL Server sqlcmd, bulk insert and affected rows

  When I use sqlcmd to "bulk insert" data, I don't have the message "... rows affected" on the output. I do have this message for select and insert statements, though. In osql it works for all the cases (no matter whether I use -Q query or sql input file). Is it an sqlcmd bug or rather a feature by design Is there any work around different than using osql Thanks, You are right, your example works for me, unless I use bulkload.txt with 500,000 rows and not 10 rows. I use both SQL Server 2005 v. 9.0.2047 and SQL Server 2003. v. 8.0.2039, the behavior is the same on both. Probably I will not need this functionality eventually, but this remains strange. Thanks, ...Show All

• Visual Basic Math Questions. Just do this instead, it's easier....

  This is my code I'm working with. I'm trying to use the sum from the lhGal to show in lhGal2.Text. Dim FirstNum, SecondNum, ThirdNum, FourthNum As Double 'Intial Fuel Add FirstNum = lhPounds.Text SecondNum = lhDensity.Text ThirdNum = lhGal.Text FourthNum = lhPounds2.Text lhGal.Text = FirstNum / SecondNum - 0.4 'Additional Fuel Added to bring to 1200 lhGal2.Text= FourthNum / SecondNum - lhGal Save all values as Double. The TryParse() method (in VS 2005 only) will convert a valid numeric string value into a number. If not valid it will convert the string into 0 without throwing an exception. Then use the Double values to perform the math processes. Convert the ...Show All

• .NET Development problem in running 2 threads

  I have a function which connects to the server (it is a synchronous connection) and returns bool value based on whether the connection got successful or not. While connecting to the server I would like to show progress bar on the UI. I have used separate thread for connecting to the sserver and I showed the progress bar in the main thread. I am starting the progressbar once “connect button clicked” and I will stop the progressbar run after “connect to the server function” returns. Once the “Connect” button clicked I started the “ProgressBar” running and also I started the Thread for connection to the server. Since the connection to the server is synchronous the whole application got hanged while connecting. Even the progress bar running ...Show All

• Windows Live Developer Forums Messenger Live Team Please Help! Error - "Message could not be delivered"

  I need to submit a ticket to the Microsoft Messenger Team.  For some reason the majority of the bots out there are unable to connect to the Microsoft Network. The following message is displayed to the user: The following message could not be delivered to all recipients: It seems that on rare occasions people are able to get through.  This problem started surfacing around the second week in November. Any help in resolving this problem is greatly appreciated. Thanks in advance.   Isaac Encouragebot v1.0 EncourageBot@hotmail.com   You should take a look at http://msn-errors.blogspot.com/2006/11/following-message-could-not-be.html It may help you ...Show All

• .NET Development NullReferenceException vs. invalid address

  Hi, The ECMA Standard states "The results of all CIL instructions that return addresses (e.g., ldloca and ldarga) are safely aligned." Now, let us assume that I have a local variable V whose declared type is a (managed) pointer type. Moreover, let us assume that V has not been initialized. In other words, that would mean that V carries an arbitrary address. Depending on the target architecture, this address might be unaligned, i.e., invalid! If I now use the instruction "ldloc V" to load V's value, I will practically push onto the stack that arbitrary address carried by V, right That arbitrary address is regarded as V's value. An attempt to use that address with "ldind" or "stind" can throw a Null ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Two Questions About Microsoft XNA Framework (Beta): Origin / Upgrading to Framework 1.0

  I have 2 questions about the XNA Framework (low priority): I find that I have Microsoft XNA Framework (Beta) installed on my computer (I don't use it / I don't put beta software on this particular machine in my environment). Where did it come from Was it supplied as part of Microsoft Visual Studio 2005 Did I get it from my video card manufacturer (ATI) when I downloaded a recent driver upgrade A third source I note that Microsoft XNA Framework 1.0 came out about 3 weeks ago (Dec 14, 2006). What is the suggested process for upgrading Typically the recommendation is to uninstall the beta version of a product before upgrading to the released version. However, I don't see that recommendation in the details for the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Question about the game windows class...

  I am trying to display flash movies in XNA. So far, I've been able to do this by creating a windows form, embedding the flash movies in the in the windows form, setting the form's default state to minimized, and then maximizing the form after my Game has launched (note, that this only works when the game is in windowed mode). Unfortunately, when a flash movies goes past a certain point on the screen it begins to flicker. I can fix this if I manually minimize the game window, and then then restore it to it's original size. My question is, is it possible to do this programmatically There doesn't seem to be a way to programmatically set the game window state as it does not seem to inherit from the forms class. Any suggestions Thanks in advanc ...Show All

• Visual Studio Team System A connection could not be made to the data source with the DataSourceID of 'Puts', Name of 'Puts'.

  Hi All, could someone pls help me out regarding this problem.. Error Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Puts', Name of 'Puts'. Error Errors in the OLAP storage engine: An error occurred while the 'USER NAME' attribute of the 'User' dimension from the 'Dummy1' database was being processed. Error Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'User', Name of 'User' was being processed. Error The following system error occurred: Logon failure: unknown user name or bad password. . 1) my connectivity to database is perfect in data sources. 2) i can also view the data in data source views, by clicking right ...Show All

• Windows Forms Starting a .NET Application from .NET Windows Service

  Hi there, I have been trying to strart a bunch of instaces of an application (XYZ.exe targets framework v1.1) from a service (also ABC.exe targets framework v1.1). Using ProcessInfo ( e.g. System.Diagnostics.Process.Start(ProcessInfo pi or String file)) object. This works alright until the count is less than or equal to 24 but as soon as I try to start 25th process I get the following error in the event viewer: The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: .NET Runtime version 1.1.4322.573- XYZ.exe - Common Language ...Show All

• Windows Forms datagridviewcomboboxcell selectedindexchanged problem

  i have a datacomboboxcolumn in a datagridview which looks something like this: ---------------------------------------------------------------------------------------------- ELEM VALOR UNIDAD ----------------------------------------------------------------------------------------------- Cu 5.6 "GR" / MT / OZ Cu 64.2 "GR" / MT / OZ Cu 1.2 "GR" / MT / OZ Ag 0.4 "MT" / OZ Ag 50.3 "MT" / OZ Ag 7.5 "MT" / OZ Sn ...Show All

• .NET Development Oracle and VB.Net

  Hello, I'm new in VB, and I'm doing my first application. I want to publish my application in a file server. The Database is an Oracle 9i, the DataBase is in a different machine than the file server, do I need to install the Oracle Client in the file sever Because, when I try to execute the application in a client machine, I got this error message: Unable to Load DLL 'OraOps9.dll' ************** Exception Text ************** System.DllNotFoundException: Unable to load DLL 'OraOps9.dll': No se puede encontrar el modulo especificado. (Exception from HRESULT: 0x8007007E) at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel) at Oracle.DataAccess.Client.OraTrace.GetRegistryTraceInfo() at Oracle.DataAccess.Client.OracleCo ...Show All

• Visual Studio Express Editions Copying a Project

  This may sound basic but I haven't yet found the appropriate button. I would like to create a new project which is based on an existing project. In essence I would like to execute a "save as" on my existing project and save under the new name. Is this possible I would call it "renaming a project". This is a problem that I have asked before and there is no good solution. My best workaround is to copy the code, then create a new project with the required name, paste the code and delete the old project. Limitation: If there are many references or many forms it can take time ...Show All

• SQL Server Cannot perform a differential backup for database

  hi seniors , I am running sql server 2005 under details Microsoft SQL Server 2005 - 9.00.3033.00 (X64) Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) When i attempt to take differentail backup i receieved following message "Cannot perform a differential backup for database "abc", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)." when i search this msg on net than i find that it is microsoft bug 863 so i found hotfixes about t ...Show All

• Visual Studio Embedding shapes in v1

  Hi, First of all congratulations on getting v1 out. It's looking pretty cool! I have been trying to migrate a DSL I developed in the June CTP version, but I have run into some errors. A couple of examples are.. Error 23 A GeometryShape may not be parented on a GeometryShape. In the ShapeMap mapping State to StateShape, the parent element path leads to StateManager, whose mapped shape is StateManagerShape. Error 26 A ImageShape may not be parented on a GeometryShape. In the ShapeMap mapping EnterCommand to EnterCommandShape, the parent element path leads to State, whose mapped shape is StateShape. Basically my DSL is similar to UML statechart notation, but I want to be able to nest states inside one another hierarchically in ...Show All

• SQL Server Error Handling in Sql Server 2000

  I am having a SP (Stored Procedure) I want to handle the error in any case for the SP. My SP is inserting a record in a table when I had changed the Column name of the Table the error is not traced but the error is directly displayed in the TSql. How to Handle any error that occured in the SP Thanks in Advance. CREATE PROCEDURE SP_InvoiceFromRBOPInvNoHdr @AutoBillID int, @NextBillDate DateTime, @OPInvNo int OutPut AS declare @InvNo int declare @CustID int declare @InvAdd1 varchar(50) declare @InvAdd2 varchar(50) declare @city varchar(50) declare @Postal varchar(20) declare @Country varchar(50) declare @Province varchar(50) declare @BillDate datetime declare @BillingContact varchar(50) declare @BillingCurrencyCode varchar(5) declare @Sto ...Show All