Caleb T's Q&A profile

• SQL Server some guidance for an SSIS newbie wanted

  Hi! I'm new to SSIS (and quite new to SQL Server). I have a process which I'd like to automize via SSIS - just don't know how and couldn't figure it out yet by playing around with the program. Shouldn't be too difficult though. First of all, that's the process as I do it now: 1) Load several flatfile sources (dumps of SQL tables) into an SQL database. 2) Add identifier rows (to some tables), set the primary and foreign keys so the database is "recreated" and I can work on it. 3) Do several simple transformations, aggregations and selects across tables and finally write a new table containing information for reporting stuff. I succe ...Show All

• .NET Development Data accessing

  Hi,     Im actually an MBBS student (IIIrd yr).. I had this great intrest in computer programing and so i learnt VB6 long back..before millenium.. i Know to use data accessing by DAO method.. Like, i know to create an access database and use it.. but now when i use the same method, im gettin many errors in VB .net 2003.. like the recordcount feature not working.. :( i don hav intense knowledge in VB as my proffession is different.. Basically im creating a program to Print prescriptions.. Drugs are stored in a data and on clicking the drug the doctor should get the prescription printed..  to make the selections ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MC2 Editor

  I can not see the MC2 Editor being part of the XNA project. When I build/rebuild MC2 the editor files are not updated. What do I do wrong or How can I make changes and updates to the MC2 editor Correct, the editor project is not part of the XNA build projects because Visual C++ Express cannot build them as they require MFC. If you have Visual Studio Standard or Professional you can build the project with no problems. In the Source\Editor folder you will find the projects for building the editor code. Compile both of these: EditorMFC.vcproj and Editores.vcproj and you should be set. Thanks! ...Show All

• .NET Development Help : "error: 40 - Could not open a connection to SQL Server"

  I'm using VS2005 and SQL2000. I created a database name "myDatabase" in SQL Server 2000 and built a website that connet to this database. When I'm running this website in VS2005 IDE (press F5 or Ctrl-F5), everything is OK. I publiced this site. When I connect to database on my computer, everything is OK also, but when I connect to database on another computer, an error occurred like this : "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, ...Show All

• Visual C++ Passing an array of structs

  I have this struct struct student//Struct layout { char name[30]; char id[11]; float gpa; int age; char gender; }; this is the syntax I have for the function I want to send the array to: void firstmenu(student students[]); student students[5];//Struct Array, this is where I make the array firstmenu(students[]); and that is where I try to call it. I get a compiler error of: error C2059: syntax error : ']' when I try to call the function. So I am assuming I have the right parameters when I make the function but I am missing something when I call it. I tried it without the [] doing [5] and it still gives me errors. I'm not sure ...Show All

• Visual C++ bug with virtual private memeber function

  I created a base class with a private virtual funciton. I was then able to inherit from that class and override the private function as if it was protected. No compiler errors, and the behavior is as if it was 'protected', not 'private' I would have inlined the code, but there's no clear way to avoid it taking up ridiculous amounts of space by skipping lines. You can not protect a virtual function against overriding if this is the issue you want to solve. The private keyword tells the compiler to protect this function from "outside the class usage". You can create a new derived c ...Show All

• Visual Studio Tools for Office Unable to Reference office.dll in VS 2005 project

  I have created an Outlook addin in VS 2003 and wanted to port it over to VS 2005 and .net 2.0; however, I dont seem to be able to reference the office.dll in the project in vs2005. It is properly registered in the GAC and is still visible from VS2003. Even when I point directly to the dll it doesnt seem to recognize it. When I compile the code I get the following error: Error 1 The type 'Microsoft.Office.Core.CommandBars' is defined in an assembly that is not referenced. You must add a reference to assembly 'office, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. J:\EDMGProjects\CET03136\ESNP\Code2.0\EsnpOutlookAdd ...Show All

• Visual C++ Event "Onclick" defined runtime

  "Hello world", i'm developing an application which creates runtimes X CStatic objects, During the for loop i inserted this code, and it works: int IdEntry = 2500; for (BYTE i=0;.......;i++)         {             StaticLabels[ i ].Create("...", WS_VISIBLE|SS_CENTER, CRect(...),this,IdEntry++);               ................               ..................................         } StaticLabels[0] is a vector of CStatic controls example: & ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Compiling issues, DirectInput .dll is in two different places

  I'm having a problem compiling due to the compiler finding the .dll in two different places since updating my DirectX version. Here's the specific error... Error 1 The type 'Microsoft.DirectX.DirectInput.Device' exists in both 'c:\WINDOWS\Microsoft.NET\DirectX for Managed Code\1.0.2902.0\Microsoft.DirectX.DirectInput.dll' and 'c:\WINDOWS\assembly\GAC_32\Microsoft.DirectX\2.0.0.0__31bf3856ad364e35\Microsoft.DirectX.dll' C:\Documents and Settings\Joe\My Documents\Game Programming\MegisShell\GameDriver.cs 61 47 MegisShell How do I make Visual Studio 2005 point to the correct one Or is it something more than that Please help, thanks! ...Show All

• Visual Studio Express Editions newbie question - 2nd window

  i haven’t programmed since the times of turbo-c. with the zero-cost-edition of visual c++ 2005 i’ve started again - and of cource i am a little bit confused about .net framework 2.0 my problem: i’ve built a window called "form1" with a button on it named "build new window". by pressing this button i planned to open another (fully functionable) window. this window is added to the project via project > new element > window forms and is called "form2". the IDE seemed to add "form2" to the project (form2.h has been built). so i created an instance of the class. form2 form_window; in fo ...Show All

• Visual Basic Browse button OpenDialog to TextBox

  I am putting together a WinForm VB.Net application in Visual Studio 2005 and on two forms I need to allow the user to click a "browse" button, choose a file, and have that file name fill the textbox upon the user clicking "open" from the dialog box. I can add the opendialog to the btnClick, open the dialog box and set the properties for a specific file type, but can't seem to get the file name moved to the text box. I have one form, txtFileName, btnBrowse, and that's it. Thank you!! No, as I understand you problem it must be : Public Class Form1 Private Sub btnBrowse_Clic ...Show All

• Visual Studio Express Editions Starting Over?

  Ok. I have had VB express for about 3 weeks now. I have 0 experience with programing. Sorry, all you techy people. But I have learned some cool things. But as I tried to jump into the fire ( and its hot ) i found nothing but frustration. Hence, I have improved on my "google" searching abilites and might add found "never before patience." Says my wife. Any way. Too bad for all of the very nice people that have put up with my "trey" annoying posts asking horribly bad questions. Why You may ask Well because I am not giving it up thats why. I have this need to learn. Its a very bad habit know. So I am starting over ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Maximum primitivecount

  Hi all, I’m moving over to DirectX from OpenGL for my CAD program. Just found that there is a maximum primitivecount limit, I can easily have 1,000,000 plus verities (Circles and Arcs use a lot!). I’m using One big Vertex buffer, for every thing, before I start splitting things up I just want to make sure that I have not missed anything obvious and that I have no alternative. I very new to DirectX you see! Cheers Julian MaxPrimitiveCount does not limit the size of your vertex buffers. It only limits the number of primitives you can draw with one call. In the case you objects have mor ...Show All

• Visual Studio Team System Understand your own dogfood

  Hi, not sure if Im coining the phrase right but I've some recent postings on blogs about dogfood statistics. such as http://blogs.msdn.com/bharry/archive/2005/10/08/Microsoft_VS_Team_Foundation_Server_dogfood_statistics_10_03_05.aspx My question is, is there just one report to produce this information, or is it a case of generating several reports and right down the results on a piece of paper Regards Andy The VSTS Reporting will pull items from the different databases into the TFSWarehouse db.  in this db we have almost everything that Brian posted in his list expect for the ones i highlighted. ...Show All

• SQL Server The underlying connection was closed: An unexpected error occurred on a receive

  Hi, I use RS webservice to generate the report from VB.NET Windows application. This report would take some 5 mins to generate. I get the following error I set webservice time out to some 1800000 (30 mins) Still it fails. How can I solve it . Is this something to do with connectiontimeout of default web site System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive.    at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)    at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)    at System.Web.Ser ...Show All