gorance's Q&A profile

• SQL Server Rowcount - Returning Rowcount from SSIS to a vb.net app executing the dtsx package

  I have a vb.net application that executes a simple flat file to sql table dtsx package. I want to capture the rowcount to display back to the user to verify the number of rows that were inserted or updated to the table. I have a Row Count component placed between the flat file source(without errors) and the destination component. I have assigned a variable named RecordCount to the Row Count component. So far so good I hope : ) Now, I also use a variable to "feed" the package the flat file source. This works fine, but I cannot figure out how to retrieve the row count information and how to assign that to the variable RecordCount. Also, if anyone has any insight on the way to work with the OnProgress method in SSIS I would a ...Show All

• Audio and Video Development Changes in Build 5472?

  Is there anyone who knows what the changes there are latest build of Vista build 5472 For example the SDK know longer has the mfpropkey.h. Thanks, R. Sparrow Specifically we were using: CComPtr<IPropertyStore> sProperties; sProperties->GetValue(PKEY_Device_FriendlyName, &value); PKEY_Device_FriendlyName use to be in that mfpropkey.h. Thanks, R. Sparrow ...Show All

• Visual Studio crystal report - data and authentication

  Hi, I have created a report for a windows form and it run correctly but when i lunch it, i always recive a request to insert a database user's password. If i see a report's connection property i saw userid=sa but not a password. How can i set a report connection property so that never call me to insert password ! ! Thank's!!! Dear Carlo You said that you have created a Report. So you can get Report Document reference from the code. Every Crystal Report Viewer component takes a reference of ReportDocument. and Every ReportDocument is binded with a report file. So you need to look at your code. Regards, ...Show All

• Windows Forms Get Response From Web Browser

  hi everybody, i have a web browser in my form, and im hitting a url with some data after which i will be getting a response from the URL, im using document complete event to trap the response, well everything goes fine till the event fires, but im not able to receive the response and store it in a variable, i tried it in 2005 with this wBrowser.DocumentText.ToString()...., works fine but i need the equivalent for this in 2003 Helps Please hi, ya i have tried out but i receive mshtml does not exist, actually i want to know how will be the response coming, in the html format, if so i have fiter out the responses and do some if else conditions, how could it be acheived. Regards, ...Show All

• Audio and Video Development TitleResource... What is it good for.

  After looking through some other threads, and the spec, it still does not seem clear what a TitleResource is good for. The TitleResource element does not have the attributes autoRun or sync, which might be important items to address when working with Advanced Applications. These two elements are available to the ApplicationResource element, which appears to be a more powerful solution to Resource needs. I have a hunch that the element is redundant and useless. Has anyone successfully used the TitleResource element, and what might a use case be thanks. Title resources are just that -- resources that are available for the entire duration of the title. If you want to ensure that a resource doesn't get kicked out of filecac ...Show All

• Windows Forms Problem with Clipboard class

  I am doing the following in my code // print screen SendKeys .SendWait( "{PRTSC}" ); // get the image Bitmap memImage = Clipboard .GetDataObject().GetData( "Bitmap" ) as Bitmap ; However the dataobject returned by Clipboard .GetDataObject(). is always null. If I open mspaint and do a paste (Ctrl + V), it shows me the captured image. Can someone on this forum please help me with this Thanks ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. problem with adding camera input

  I have to use camera input and to do this i am using a third party .net utility (from theimagingsource) when i put it on its own winform and i try to compile ActiveX control 'e0110be7-ebf0-4612-b2f8-817194557141' cannot be instantiated because the current thread is not in a single-threaded apartment. am i doing something wrong forgetting something I have no problem getting cam input this way in the DX samples i managed to get the same error from DX9c empty project any suggestions anyone I am kind of lost Best regards Bill ...Show All

• SQL Server pb fail over automatic with one instance alias with data mirroring

  Hello, I've got a question about failover with the database mirroring. I have 3 servers, 2 with SQL 2005 and 1 with SQL Express as witness. After getting some problems to install database mirroring with Windows authentification, i had to create an authentification by certificate. All goes well but my problem is about my primary instance SQL alias. The alias on the primary doesn't follow on the secondary when the primary is down. I've searched on forums and in the internet SQL web sites, but i didn't find anything. I create another alias on the secondary but i don't know how to modify it in T-SQL... I would like to know if there's any solution to modify an SQL instance alias by transact-SQL or if anyone has already i ...Show All

• Visual Basic File Streams

  How can i detect if a text file is already open by another process before i try to write to it. Thanks Is it your program which is locking the file, or another program If it's another program, then there's not much you can do about it. However, when you open the streamwriter with a filename directly, you will open it for exclusive access (i.e. no sharing). If you can't open it exclusively, you will get an error. Normally, I would open a file for writing, but with shared read: this will allow other applications to read it (but not write), and still allow you to write to it. ...Show All

• SQL Server Access denied on assembly load

  Hello, We are experiencing an “access denied” problem with analysis services assemblies. We have two safe assemblies named "safe" and "safecalled". The first assembly contains a mdx stored procedure that in turns calls a stored procedure contained in a safecalled.dll assembly. We register safe.dll in AS2005 as a safe assembly giving the current user impersonation (our application require that). However when a remote user (allowed to access to the cube) tries to execute the assembly we got: Esecuzione della stored procedure gestita Test non riuscita a causa dell'errore seguente: Exception has been thrown by the target of an invocation.Could not load file or assembly 'safecalled, Version=1.0.0.0, Culture ...Show All

• SQL Server Reset password

  How does one use SMO to reset a login password Thanks.. Server s = new Server ( "." ); Login l = s.Logins[ "Jens" ]; l.ChangePassword( "OldPassword" , "NewPassword" ); //Or the short one new Server ( "." ).Logins[ "Jens" ].ChangePassword( "OldPassword" , "NewPassword" ); HTH; Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Performance issue when using Reporting Services?

  I have found indications in internet that the performance isn’t optimal in SSRS – both the CPU resources and the memory are consumed in a way that affects the performance a lot. The CPU resources are the same as SQL Server uses and if SSRS consumes a lot of these resources this might affect other parts. The memory can also be an issue since the SQL Server Standard edition is the one we uses and this is limited to 2GB RAM as I understand it. Are these “bad performance” indications true In some articles it is even pointed out that the SSRS should be placed on a Stand-alone server which thereby causes additional licenses. Is this really the case It depends how you look at it. Essentially what you have be ...Show All

• Visual Basic Vvarious user controls need to reference Module1.vb

  Module1.vb needs to be available to various user controls which utilize methods in this file. Where do I put this file and then how do I reference it from within the user control projects Can I wrap these interop Functions into a class and instantiate it I can create a class library within a solution but not a 'module library' Thank you for allowing stupid questions. -Greg Module1.vb Imports System.Runtime.InteropServices Module Module1 Public Declare Function SetSelectedAxis Lib "foo.dll" ( ByVal Index As Long ) As Long Try this: 1. Create a new Class Library project called testclass . 2. Use the following code for your class: Publ ...Show All

• Visual Studio Team System Network mix connection speed

  What is the connection speed that Team System uses to simulate LAN and T1 connections First of all, you should be aware that the network simulation provided by VSTS is simply this: the measured response time for each Web test request is increased based on the network speed from the network mix and the content-length of the response. The files that define the connect speeds that are simulated are contained in the directory <Program Files>\Microsoft Visual Studio 8\Common7\IDE\Templates\LoadTest\Networks. There is an XML file that defines each network type. The value in the file for T1 is 1544 Kbps. For LAN, the value is 0 which is special value meaning that the response times should not be adju ...Show All

• SQL Server AttachDBFileName refers to original log file

  Hello, I'm using the AttachDBFilename option in the SQL connection string to attach a database mdf file copied to another machine. There is an error though, it seems to want to refer to a log file on the machine the .mdf was originally created on. The error is as follows: Could not attach file 'C:\Program Files\Strategic Systems\Time Master\TimeMasterDat.mdf' as database 'TimeMaster'. File activation failure. The physical file name "D:\Visual Studio 2005 Projects\Strategic\Applications\TimeMaster\Database\Strategic.TimeMaster.Database.SQL2005\TimeMasterDat_log.LDF" may be incorrect How can I get the attach to avoid referring to this log file If you want to use a server attached instance you will ...Show All