Stephen Patten's Q&A profile

• SQL Server ODBC Destination in SSIS

  Hi! I have a problem that stops me from using Integration Services as THE ETL tool. My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver. I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC). Now my question is how do I output/write my data into ODBC ...Show All

• Windows Forms How do I create a GridView/edit screen?

  Newbie question. I have DataGridView that has a list of records. I want to double click on one row and bring up a NEW form with a detailed edit form for that record. 1) How assign a KEY to the DataGridView 2) How to I access the key and pass it do the new form 3) How do I create all this on a row double click (not cell double click) Thanks. you can do it by the following I have answered based on your question number ...Show All

• Visual C# How many threads running from the threadpool in a point of time

  How can I know how many threads are running from the threadpool in a point of time in my app Thanks in advance Try using ThreadPool.GetAvailableThreads() and subtract it from ThreadPool.GetMaxThreads(). Am I missing something ...Show All

• Windows Forms Looking for example for avoidance code

  I am looking for example code for going around a plant when blocked, or going wide around a carnivore. I'm working on a pathfinding package for Terrarium developers.  However, it'll be a while before it's ready for prime time. &nbs ...Show All

• Visual Studio Express Editions Cannot compile the sample from MSDN IADsWinNTSystemInfo

  Dear Sir, I have copied the code from MSDN in order to use IADsWinNTSystemInfo to get the machine name and PDC. The code is listed as follows. #include <activeds.h> #include <stdio.h> int main() { HRESULT hr; hr = CoInitialize(NULL); IADsWinNTSystemInfo *pNtSys; hr = CoCreateInstance(CLSID_WinNTSystemInfo, NULL, CLSCTX_INPROC_SERVER, IID_IADsWinNTSystemInfo, (void* ...Show All

• Windows Forms DropDown - easy newbie

  Hello all, Can someone please tell me how I can implement a simple design time dropdown for a property of my control. I can not seem to find any examples of this. I need to place two possible values in a dropdown. I can get my pr ...Show All

• Windows Forms Drawing too slowly

  So, I may just be overlooking something simple here, as I am pretty new to GDI+.  But I basically have a form, with a panel, and on the panel I'm drawing simple black and white squares, etc.  The squares represent the result of s ...Show All

• .NET Development Exactly when does a runtime callable wrapper call QueryInterface?

  Hello all, we are using a COM component written in ATL that answers queries for interfaces depending on the capabilities of connected hardware. Either it returns E_NOINTERFACE or the corresponding interface. This is implementied with the following entries in the COM MAP: BEGIN_COM_MAP(CController) ... COM_INTERFACE_ENTRY_FUNC( __uuidof (IOptional), 0, &QueryOptionalInteraface) END_COM_MAP() We are currently writing a C# cl ...Show All

• Visual C++ String Table

  Hi I have two string table in a single dialog based application. How do i use second string table and I want to load strings in runtime from different string tables. regards, Manoj Jangid There is only one String table per language! You can not have more than one stringtable, You might have several Strin Table entries in the resource file, but those entries are just seperated by IDs, like they are grouped in the final executab ...Show All

• Windows Forms How to determine mouse click coordinates when clicked in a certain portion of the titlebar

  I've drawn an icon in the caption area of my form. It appears to the left of the close button. I need to be able to find out if the user presses a mouse button over that icon. Any help would be really appreciated!! Snickel65 wrote: I've drawn an icon in the caption area of my form. It appears to the left of the close button. I need to be able to find out if the user presses a mouse button ove ...Show All

• Visual FoxPro what is the maximum field VFP9 can handle

  Good day to everybody... just a little problem with my update at VFP interface with my back-end database I dont have this problem updating my employees table in SQL2000 with 35 columns at my VFP interface, but recently I add another 3 columns at my table, that's where I encounter this problem. Inserting a new record or deleting there's no problem, but when i edit a particular record then saved the changes,the update is OK.. but after I clo ...Show All

• SQL Server Installing SQL Server 2005 (Sept 2005) using VMWare

  I spent several days on this one and saw no comment around here so it might worth mentioning... When you try installing SQL Server 2005 (Sept 2005) on a Virtual Machine (in my case using VMWare) you MUST transfer all the setup files (SQLDEV or SQLSTD or SQLENT folder) to the guest machine. DON'T map the folder to the host. Transfer all files to the guest machine and then run the setup. It seems this is not an issue (anymore from Sept-05) when ...Show All

• Visual Basic Resizing of screen

  Hi, I am having trouble with my forms fitting into the mdiparent child window. The child forms have buttons at the bottom that are hidden, unless I expand the main application to full screen, but full screen also, resizes the right-hand menu leaving more space at the bottom then I want. What is the approach, do I need to lock all controls on the child forms I am using 1024 x 768 as the default screen resolution, since 17" monitors ar ...Show All

• Visual Studio Express Editions SOS!!! Having trouble while installing VWD Express 2005

  Hello David, I already made it during the installation process. Hello David, I think I did. But I'm not so sure. I made automatic error reporting feature. But I don't this is the one you're telling me. Now, I'm making it myself. NETallica PS. I'm so sorry coz I post the same thread twice. During the time while the Internet speed was so slow, I made some mistakes! Sorry!!! ...Show All

• SQL Server SP1 ships

  Download it here: http://www.microsoft.com/sql/sp1.mspx Thanks, Mark The link for the download on that page goes to the link http://www.microsoft.com/sql/tbd , which doesn't exist, and gives a 404 error. I assume "tbd" means To Be Decided. Has it really been released yet It'd also be good if it was possible to install this via Windows Update, but apparantly the technology doesn't yet exist to do this. See here for details: http:/ ...Show All