Eugene Katz's Q&A profile

• SQL Server Is It A "Bug"? Or Is There a Logical Explanation for This Behavior?

  A user observed the following this morning and I verified this behavior as well. The report consists of the following: Sales Volume as the only measure, Product Name as a row field, and then Year and Month are added as column fields. Please note that Year and Month come from our Date (Time) dimension, and are seperate attributes with attribute relationships defined and no hierarchy. Everything is fine until the user filters out the current month for the current year. Upon doing so, the subtotals for each year is actually the grand total. Another intersting thing is, we only have data for the 2005 and 2006 in terms of Sales. The Date dimension includes 01/2000 through 07/2006. Before filtering out the current month of the current year in ...Show All

• SQL Server How to import flat files into Microsoft SQL 2005 Express Edition automatically?

  Iam aware that Microsoft SQL 2005 Express Edition does not have agent or DTS capabilities, but how may I automate an import of flat files to the DB tables Must I use an external VB development of is there a way to schedule an import of flat files to Microsoft SQL 2005 Express Edition hi, you can perhaps have a look at the features provided by linked servers using JET data provider as reported in http://msdn2.microsoft.com/en-us/library/ms190479.aspx say you have a situation like this, a flat.txt saved in d:\txt\flat.txt <flat.txt> FirstName|LastName andrea|montanari jr2006|jr2006 </flat.txt> you can define a schema file ( http://msdn.microsoft.com/library/default.asp url=/library/e ...Show All

• Windows Forms Timer X Seconds

  Hi, How can I create a function to wait for x seconds with a timer Like... wait_seconds(5); // is the timer function DispatchMessage(Usuario+Environment.NewLine); txtLista.Text="-Logar-"+Environment.NewLine; wait_seconds(5); // is the timer functionDispatchMessage(Senha+Environment.NewLine); txtLista.Text+="-Senha-"+Environment.NewLine; wait_seconds(5); // is the timer function DispatchMessage("listenerconfig"+Environment.NewLine); txtLista.Text+="-listenerconfig-"+Environment.NewLine; wait_seconds(5); // is the timer function ... Thanks the best way is to use a timer. you should also avoid the use of Application.DoEvents() as it can cause un ...Show All

• Smart Device Development Windows Mobile 5.0 USB driver development

  For my master thesis, I need to develop software that controls a medical implant over a USB link. This USB link requires 1 control transfer (the standard one required by the USB standard) and bulk transfer. In order to do this I need to develop a USB driver to communicate with the implant. Up until now my experience developing for windows mobile: NUL, my experience for developing drivers: NUL. Ofcourse I've already done alot of reading, and on the msdn website I only find some information about developing a USB driver, and there it states I need the platform builder.. which is not free. After what I read about the platform builder, it just configures a whole new windows Mobile, but that's not really needed is it I have a certain PD ...Show All

• Windows Forms How do I retrieve current Project Name and Path for form currently open in the designer

  Hello all, How can I get a reference to the parent project of the form currently open in the designer I specifically need the path so I can traverse it looking for some associated config files Thanks in advance for any ideas and/or suggestions! The following code works at DesignTime when a service can be used: Public Class CustomDesigner Inherits System.ComponentModel.Design.ComponentDesigner Public Overrides Sub Initialize(ByVal component As System.ComponentModel.IComponent) MyBase.Initialize(component) Dim visualStudioIDE As EnvDTE.DTE = _ CType(component.Site.GetService(GetType(EnvDTE.DTE)), EnvDTE.DTE) End Sub 'Initialize End Class ...Show All

• SQL Server Slow Running Insert After Changing OLE DB Destination Data Access Mode

  Hello, In a Data Flow Task, I have an insert that occurs into a SQL Server 2000 table from a fixed width flat file. The SQL Server table that the data goes into is accessed through an OLE DB connection manager that uses the Native OLE DB\Microsoft OLE DB Provider for SQL Server. In the OLE DB Destination, I changed the access mode from Table or View - fast load to Table or View because I needed to implement OLE DB Destination Error Output. The Error output goes to a SQL Server 2000 table that uses the same connection manager. The OLE DB Destination Editor Error Output 'Error' option is configured to 'Redirect' the row. 'Set this value to selected cells' is set to 'Fail component'. Was changing the access mode the simple reason ...Show All

• Windows Forms Error adding a data source - Connecting to a UDB DB2 database on an iSeries Computer i810 V5R4

  I am unable to successfully add a new data source to a Visual Studio 2005 project using the "Data Source Configuration Wizard" being a ODBC datasource defined on the client using the iSeries Access ODBC Driver . On the "Choose Your Database Objects" window I get the following error message : An error occurred while retrieving the information from the database: Column ‘PROCEDURE_CAT’ does not belong to table Procedures Does anyone have a resolution for this Hi Chris, I dont have a fix for you, more of a suggestion, PROCEDURE_CAT is a part of the database schemea, it is possible that the driver is not returning the schema in a way that Visual Studio wou ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Quaternion camera help

  Hi, im trying to build a quaternion camera atm, without much success. ive created a quaternion for rotation, and am currently trying to convert that to a matrix, combine the matrix with a transform matrix to create a view matrix. unfortunately it doesnt work, and i cant figure out what im doing wrong. what im doing is basically: Quaternion q = new Quaternion ( Vector3 axis, float angle); Matrix m1 = Matrix.CreateTransform( vector3 worldPos ); Matrix m2 = Matrix.FromQuaternion(q); Matrix view = m1 * m2; and use view as my view matrix. i suspect that im screwing something stupid up... any ideas Have you successfully built a plain old camera yet using: Matrix.CreateLookAt(Vector3 cameraPo ...Show All

• SQL Server Row by Row Copy

  I'm writing a stored procedure that requires I duplicate records through a loop, one record at a time (required because I need to execute SCOPE_IDENTITY() logic on each insertion). But each row has 40 or so columns, making my stored procedure ridiculously full of long declaration lists. So I want to either: 1) Learn a way to auto-insert the column declarations into my code without having to type them all by hand, or... 2) Learn a way to represent the whole row for insertion, without having to specify each column specifically. The latter solution would be the most elegant, but I'll take what I can get... What version of SQL Server are you using In SQL Server 2005, you can use OUTPUT clause in INSERT statement to get the gener ...Show All

• .NET Development read xml from internet

  Hi, I want to read an xml file from the internet. The file is provided by a web site and is a result of a query. More precisely, this link http://www.localcallingguide.com/xmlprefix.php npa=250&nxx=423 produce an xml file. How can i get it in .net I have tried a webrequest and I always get a timeout exception. Thanks the @ symbol only applies for C#, its for escaping escape characters. the firewall is the most likely cause you are not being able to retrieve the data from the site (Timeout) and wanted to suggest this well before but wanted to make sure I knew for certain. ...Show All

• Visual Basic TCP/IP clients, listener, and servers

  I was wondering if anyone had a good example of a TCP/IP server VB.Net application using TCPclient and TCPListener that you could send me. I need to develop an application that acts as a TCP/IP server waiting for TCP/IP client connections. All of the connections have to be maintained and any received command has to be processed and status information needs to be returned to the clients. Tony Is the protocol something you can modify It looks like the protocol is giving you some difficulty. For example, if a client connects, looks at the status, and disconnects, this should be a specific protocol pattern that the server knows about, and knows that the client will disconnect. This protocol is similar to, s ...Show All

• Smart Device Development Migrating from ASP Web Service to WCF Service

  Can anyone point me at resources or samples of how to access a WCF service from a Compact Framework 2.0 application As I understand it the WCF service has to use basicHttpBinding and that the Compact Framework 2.0 app accesses it as a asmx client. I'd really love to see some samples. Also, can anyone comment about problems or limitations they've run into in doing this Thanks! It's very easy - you don't. Since NETCF V2 has no support for WCF there's no way for you to consume WCF service from NETCF. You should keep your Web Service for a while till you move on to next version of NETCF with WCF support. ...Show All

• SQL Server Accessing the variable in Execute SQL Task

  I have a variable SYear with the data type Integer and the value 2005. Connection type is OLE DB, and my sql statement is: DECLARE @MyYear Int SET @MyYear = I have set the variable User::Syear as Input with the parameter name=0, there is no result set. I set BypassPrepare both True and False. However, this simple statement does not work. I keep having an error. If I put integer value directly into @MyYear, it is fine. What is wrong in here Somebody help me! Thank you Darren. When the sotre procedures are used, how is the variable used (the variable declared for a whole package) I am not quite sure how I can call the stored procedure. Should I use the Execute SQL Task and set the SQL Source ...Show All

• Visual C# Passing image asyncronously from one machine to onother

  I am not able to pass a image asyncronously in a callback from one machine to onother. Could anyone suggest possible solution. That would be more helpful. Thanks, N.Vijay Hi, Image is Serializable, and inherits MarshalByRefObject. I suspect that the image instance is not surviving the callback. Can you provide a little more detail Regards Craig ...Show All

• Windows Forms Using Flash movie with C#

  Hi, i'm Alex and i write from Italy. Does anyone know how can i insert Flash movies into Windows Forms Hi, check codeproject.com, it has some documents about the subject: http://www.codeproject.com/useritems/FlashDBInteract.asp http://www.codeproject.com/aspnet/FlashPlayerCustControl.asp http://www.codeproject.com/cs/media/flashexternalapi.asp ...Show All