Scott McKeown's Q&A profile

• SQL Server Virtual cube

  In As2000 we can link 2 cubes together to create a virtual cube. But I don't see this in As2005. How can I link 2 cubes together You can have multiple measure groups in the cube in AS2005 - this gives same functionality as virtual cubes in AS2000. The measure groups can also be linked measure groups to the other cubes, so one measure group can be shared among multiple cubes, just like in AS2000. ...Show All

• Visual Studio Express Editions PictureBox Condition Check...

  Hi All, How can I do a If then Else condition check on the status of my picturebox1 for Blank/empty condition So that I can output a msgbox to hint the user to open file and load an image into the picturebox before I can continue my intended application procedure. Cheers Ken Tucker wrote: If PictureBox1.Image Is Nothing Then Thank you so much... ...Show All

• Windows Forms Installing click once published application programmatically

  Hi, I am trying to install the ClickOnce published application programmatically. My code is exactly the same which is done here http://msdn2.microsoft.com/en-us/library/system.deployment.application.inplacehostingmanager.assertapplicationrequirements.aspx . While I running the application I am getting error saying "Not a valid number of matching trust were given an application version" .Could some one help me in solving this Regards, Santha Hi, To be more specific regarding the problem, I published the site using the visual studio 2005 and the url is http://localhost/SampleDeploy/SampleDeploy.application , with giving full trust I tried to deploy that application using the u ...Show All

• Visual Basic VB6 dll to .NET- basic question

  Hello there, as the name suggests I'm a complete novice, so apologies in advance... I have a VB6 dll that I need to use in VS2005. After using the VS upgrade tool, the dll (which deals with scanning) works, but not as it should. Instead of opening its own scanning dialog box, I get the scanner dialog box. After doing some research, I've tried to use the tlbimp as well as the regsvr32 tools with no success (the tlb told me the dll is not a library type and the regsvr returned a message saying the DllRegisterServer entry point was not found). I don't have any idea what to do or where to look for info for beginners, and would be grateful for any suggestions. What we're talking about here is using you VB6 dll, there is no ' upgrading t ...Show All

• Visual C++ Visual C++ 2005 Express Edition: Where can I find msdev.exe ?

  Hi, I am a newbie to visual c++ environment. I am trying to build some code from a command line environment. The documentation for the build refers to msdev.exe which I cannot seem to locate on my machine. Could someone please let me know where this is available If it is not shipped as part of Visual C++ express edition, please let me know that as well. The following is the list of software that is installed on my machine: - Visual C++ 2005 Express Edition - Microsoft .Net Framework 2.0 - Microsoft Platform SDK for Windows Server 2003 R2. If there is a package available that I need to install, please let me know. Thank you for your help and time. Regards, -- Nachi ...Show All

• SQL Server Removing protected beta files

  I cannot install SQL SErver 2005 because of files still on my hard disk from beta version. These include sqlmgmprovider.dll and svrenumapi.dll. The uninstall program is no longer available. How do I get rid of whatever remains of the old beta installation so that the released version of SQL Server 2005 will install Thanks, Sam, The zap tool worked and I was able to get past the objection to the old beta files. However, the install was not completely successful. In fact the main part of it did not install successfully. Do you have any hints on how to diagnose this problem Allen (moontube) ...Show All

• SQL Server Error 18452 (not associated with a trusted sql server connection)

  Using sql2005 on a Novell network... When attempting to log into Mgt Studio using windows authentication I am getting the error: Error 18452 (not associated with a trusted sql server connection) . I added my domain\userName in sql with no problems and added the account to the sysadmin server role. However, I noticed my credentials on my pc are not listed as domain\userName but rather ComputerName\UserName. I think this is what is causing the problem but I am not sure. Can anyone lend a hand I'd appreciate any help, Thanks. Scott Have you checked if the other SQL Server machine is using mixed mode authentication If it does, try troubleshooting the SQL authentication using Management Studi ...Show All

• SQL Server Totaling of the represented values (but not dataset values)

  Hello! I have a problem with totaling. There is table below which represents what exactly I need. Each cell value in the table is field multiplied by a coefficient. Totals should sum all row values as represented below : Tasks            User1 value                  User 2 value      ...     Column Totals  task 1            =field1_1*coef1           =field2_1*coef2   ...    =field1_1*coef1 + field ...Show All

• .NET Development Intermittent ODBC.NET issue

  Hi, I have an Application that starts a OdbcTransaction and executes a number of OdbcCommands one after another. The commands are Prepared ( OdbcCommand.Prepare() ) and also Cached in a Hashtable by a unique name. The application runs for 100s of interations where each iteration is an execution of the Transaction and all the underlying commands. The transaction object and commands are cached so that for each iteration, they do not have to be recreated. However, after running for a long time, we some times receive: "ERROR [HY000] [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt" There are "SELECT ... FROM ... WHERE ..." statements that run during the transaction time. The &qu ...Show All

• Visual Studio Express Editions Where can I learn more about Movie Editing

  I want to make a Movie Editing Program this is the type of Help I need to learn it: Trying to learn how to do this with C# *Make a program play media files with out a windows media player, or quick times compenet. *Where can I learn how to make a program that can upload Videos from a camera and edit the uploaded videos. *Where I can learn how to make an Exportanting Program to export the videos. * Maybe how to make my own file types. I'm Sure the Link will help. Its a start with the capture part. Also If its web cam thats good too cause I have some new Ideas with another program that I'm making that might help its develpment. I will display the program in the future when I fix out the bugs. ...Show All

• SQL Server SQL 2005 Trial Edition and SP1

  I have just installed SQL 2005 Trial, I have downloaded the DVD iso image from Microsoft. We are planning to upgrade it to the SQL 2005 Standard Edition. My Question is, does the Trial Edition already include the SP1 When not, ist it possible to Upgrade the Trial with SP1, and the later to Standard Edition Or is the only supported way to Upgrade the Trial To Standard, and first then apply the SP1 patch thanx for anny suggestions If the trial edition is RTM, then SP1 is not included. It is not a good idea to upgrade trial edition + SP1 to Standard edition RTM as it is a degradation. The best approach is upgrade trial edition RTM to standard edition RTM, then apply SP1. ...Show All

• Visual C++ Problems with CBitmap and CDC

  Hello, I am trying to use a CBitmap that is quite a bit larger than the DC on the Windows Mobile device I am using. As a test, I am blitting this CBitmap black and then copying it to the buffer DC using an intermediary DC. However, it is not working. I cannot for the life of me figure out what is going on! Here is the code (all the calculations are correct going into the BitBlts): RECT screen; GetClientRect(&screen); int bufferWidth = screen.right*Minotour::Constants::BUFFER_SIZEFACTOR; int bufferHeight = screen.bottom*Minotour::Constants::BUFFER_SIZEFACTOR; CDC* tempDC = new CDC(); tempDC->CreateCompatibleDC(readyBuffer); CBitmap* test = new CBitmap(); test->CreateCompatibleBitma ...Show All

• SQL Server Connecting to Linked Servers

  I know this is an easy one for most of you but this is new territory for me. I am trying to link a production application database to an existing SMS database. Both of these databases are SQL 2000. I have sa access to both of them. I have an accreditation application that deals with internal processes within our active directory network. We are using SMS database collections to provide the discovery for reporting of this application database and I want to compare the collection to the existing data between the 2 databases. For simplicity I will define them both. Application Database we will call “A-Database” SMS Database we will call “B-Database” I have gone into the A-Database and gone to linked Se ...Show All

• SQL Server avoiding "NaN" , "infinity" in reports

  When I use calculation in generating reports, I get "NaN" and "Infinity" values, I wanted to avoid this and display "0" if the result of calculation is null or infinity.. I used the below calculation =(Fields!approved_tier_cnt.Value)/(Fields!approved_cnt.Value) Please let me know how to avoid "NaN" and "infinity", while displaying in reports Regards Durai I would use some explicit type casting and conditional logic. Firstly to avoid NaN I would make sure the fields are numeric by using one of the standard VB conversion functions e.g. CInt(), CDbl() etc. like this: =CDbl(Fields!approved_tier_cnt.Value)/CDbl(Fields!approved_cn ...Show All

• Visual C# BYTE in a UNICODE world

  I am reading a binary file into a byte array. I need to spawn a process via ProcessStartInfo class and pass this byte array to this process via redirecting its stdin to my program. So far no problems. Unfortunately, the StreamWriter that is used to send input to the spawned process (the write () function of Process.StardardInput) is via a string and/or char which are both unicode (it actually has 20 overloaded functions for all kinds of data types but the two applicable to me are string and char []). The text I am tryinig to send to the program is decrypted messages in binary format which when translated from byte to unicode string or char[] is losing some of its high ASCII values (> 128). Is there a way to send a byte array (or a ...Show All