Lesego's Q&A profile

• SQL Server Using variables in a data reader source

  Greetings SSIS friends, I have tried using a sql command for my data reader source. I added the following expression to my datareader source : "select * from result where result_id > " + @[max_result_id] but I get the following error message : The SQL command has not been set correctly. Check SQLCommand property. I then got rid of the variable (defined at package level) and replaced it with a string like so : "select * from result where result_id > " + "123456" but I still get the same error message! What am I doing wrong ! Please advise. Does this help http://forums.microsoft.com/msdn/showpost.aspx postid=73466&siteid=1 Afraid not. The p ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Reference rasterizer

  My graphics card doesn't support Pixel and Vertex shader so i won't be able to do anything interesting with XNA, it's what i have heard. So i started thinking: will i be able to utilize the reference rasterizer (only to learn XNA) XNA supports reference rasterizer in addition to the HAL rasterizer We added an explicit check for a SM 1.1 hardware device with DDI9 drivers for v1.0. So you need to have hardware (even if you are using the reference rasterizer) in order to create the GraphicsDevice. ...Show All

• SQL Server Cannot get access to my Access 2003 database tables

  I developed a database with Access 2003 and everything was working good until my tech came in and reformated my hard drive and install a new Ghost image that met our company standards. Now I cannot go in and make any changes to any of the tables, queries and forms. All of this started when a new Ghost image was installed on my pc. The message I get when I try to open my database is "You do not have permission to run "tblSwitchboard." I get the same error message when I try to do anything at all on the database. I am at a loss as to what to do. Please help. Hi, if you are using an access database, you probably should address your question to an access forum. use the MS publi ...Show All

• Visual Studio Ive installed SP1 for VS2005 but I have the same problems with report viewer in Firefox

  The report viewer still does not display correctly in Firefox. Am I missing something My border around the reportviewer control stops short and overlaps the data. Also, unless I place a textbox that extends across the whole width of my report, I still get the issue with data being shrunken. From what i read these items were supposed to be fixed in SP1 ...Show All

• SQL Server Bootstrapping SQL Server Express

  Can someone tell me if there is a definitive description somewhwere re how to get SQL Server 2005 to install from the same CD as a VB application. Despite the help pages that I found not mentioning anything about copying the files into the Bootstrapper\Packages folder, I found this in the forums. However, whilst Windows Installer and .net framework install ok, it still bombs out with SQL. I discovered that the old machine I was using to test on was a P2 and it needs P3 to work. A friend has now tried it on a modern PC and it wouldn't install for him either. Don't have the error codes yet. Is there anywhere that lists exactly which files need to be where and any other little hidden secrets Regards, Rich ...Show All

• Visual C++ crazy error

  hi i made a simple Form with almost nothing of real importance on it using VC++ windows form application wizard but it runs fine on this computer but not on my other computer when starting the application on my other computer i get this error message: "this program couldnt start cause the program configuration is wrong. if u install it again, this can solve the program" does anyone know how i can solve a problem like this. thanks This was programmed in VC++ and it is a general question so i think i am in the right part of the forum for this problem Thanks for the reply and the link. After reading all that im even more confused i am only a beginner and there were several options of which i understood none i never had any of these pr ...Show All

• Visual Studio Tools for Office Manual Deployment of VSTO project

  I have a VSTO Word project in VS2005. I'm trying to deploy it via commandline vs deployment wizard. Deployment wizard appears to work fine. But what command and arguments do I use to do the same manually I've tried using the normal VS2005 webdeployement but obviously this is not correct. TIA Jerry Hi Jerry, Take a lok at these two topics: http://msdn2.microsoft.com/en-us/library/2zs2w66f(VS.80).aspx http://msdn2.microsoft.com/en-us/library/ms269007(VS.80).aspx Thanks and regards, Darryn Lavery [MSFT] ...Show All

• Visual Studio Express Editions MessageBox Issue

  Hey, Still pluggin away here and learnin.....New question/error. When I attempt to use MessageBox.Show I get the following error: Error 1 'Show' is not a member of 'MessageBox'. I understand that it should work like: Result = MessageBox.Show(Message, Caption, Buttons) But it is not....Is this an Issue in VB Express How do I solve this Thanks in advance LDavis501 Spotty. As is obvious you are right. But here is the code that I started with (changed it back to the orginal before trying MsgBox): Public Class Form1 Private Sub btnClose_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles btnClose.Click Dim drQuit As DialogR ...Show All

• Visual Studio Team System From Express to Team

  I just installed Team Suite from Express. Do I need to rebuild the current projects I'm excited, it seems there are more tools/option in the Team version Thank you Luis, that's very kind of you. A few hours ago the prob has solved. Somebody told me to install "Virtual CD-ROM Control Panel v2.0.1.1" and change the .img to .iso and it worked. Best regards, ...Show All

• Visual Studio Tools for Office How can I copy range's style to another in Excel?

  Hi everybody, I have a problum that I selected a range on Excel worksheet, and inserted another range on the same worksheet, now I wanna copy the selected range's style to the inserted one, I use insertedRange.Style = selectedRange.Style; or insertedRange.Cells.Style = selectedRange.Cells.Style; both of the two works not correctly, what is the mistake This appears to be more an Excel object model question than a VSTO question, so it might be better to ask in the Excel-specific group. When you do ask, you should describe exactly HOW it doesn't work. FWIW, from a quick scan of the Excel UI and VBA Help files, I'm guessing you might have to first create the style you want to copy (assign a style name to the formatt ...Show All

• .NET Development microsoft.office.interop.outlook.dll retrieving user's inbox

  I want to retrieve a user's inbox authenticating with a username/password. The KB article and examples I have seen all use the profile name/password of the local machine. I need to use the username/password because I am using this in a web app. Is there a way to have this done using the Microsoft Outlook 11.0 Type Library, or would I have to create a custom pop3 component and use that Thanks in advance! ...Show All

• .NET Development Creating a database storage and information access?

  Okay I'm totally lost. I've been trying to make a website for our customers to sign into where they can view specific details relating to their company (their product purchases, warranty end dates, and points balance tracking). How do I go about creating such a database storage and access website. Does anyone know where I find a tutorial or if someone can help me out. I've tried everything I could find and nothing. All I got so far is the actual layout and log in working. Now i need the backbone of the website; the database functions. Thank you. Okay I went back and did it again. I got it to work this time. I have all my data showing but I have a couple new problems. How do I make it so wh ...Show All

• Visual Studio Team System I get error when trying to acccess http://localhost:8080/Warehouse/V1.0/warehousecontroller.asmx

  Invalid at the top level of the document. Error processing resource 'http://localhost:8080/Warehouse/V1.0/warehousecontroll... TF10216: Team Foundation services are currently unavailable. Try again later. If the problem persists, contact your Team Fou... Since you have not responded for a while, we mark this as closed for now. You can reopen it or start a new thread if you still have problems. Bo ...Show All

• SQL Server Reusability & SSIS - issues they do not write in books about

  I have a simple requirement: Each package needs to have Error Handling - which needs to Execute a SQL statement. It's the same Stored Proc - where each package passes in its ID. Ok - I get that part about creating a custom task and so on for reusabilty. But - lets say that after deploying this task in 20 packages - I need to change the name of the Stored Proc. What is going to happen in that case Correct me if I'm wrong - but after deploying the new version of the custom task - do I need to go to each package and update the reference to new version Jon Limjap wrote: I think for what you want to do you have to save your script in a legitimate VB 2005 class library and register that class library with the CLR so you can referenc ...Show All

• Windows Forms Transfering info with Class file

  I have 2 forms Form1.h URL.h I am trying to take the information from "txtURL" on "URL.h" and place it into "wmp->URL" on "Form1.h" i was told i have to use a Class file as information cannot be transfered from Form to Form. So i made a class file "URLC.h" the code in it is //////////////// #pragma once #include "Form1.h" #include "URL.h" namespace M12; ref class URLC { public: URLC(void); int URL; }; \\\\\\\\\\\\\\\ Note: the \\\\\ and ///// are not part of the code, its to show start to finish. i was told that you decalse strings with "int stringname;" so i use int URL; How can i place the info into URLC and then have Form1.h read it when URL.h is clo ...Show All