HbH's Q&A profile

• SQL Server OLE DB Source Editor

  hi, I am using SSIS to extract data from sql server and import into MDB file. In the process, under data flow task, I have used OLE DB Source Editor as source. Here i have choosen SQL Command as mode of data population. In the box below i have typed the following statements. "Exec Site_Address" I have used many temperory tables in this procedure. When i run this procedure in the query analyzer window i get the desired data which has to be imported to an MDB. After typing the above statements and when i click the button preview i can see the data. But when i click the Columns.... i dont see anything there. I am unable to see any columns there. This is getting to my nerves because, when i use OLE DB as Destination i am unable ...Show All

• Visual C++ cannot open file 'comdlg.lib'

  I've just installed MS VC++ 8.0, followed the instruction to install SDK update and tried to to build my Win32 console app project. Building output gave me an error message: LINK : fatal error LNK1104: cannot open file 'comdlg.lib' I checked directories and file locations. Everything corresponds with instructions to install PSDK. But when I try to find comdlg.lib, I find nothing. Maybe the problem is in project settings but I need help with this. Thanks Martin, I tried your solution (linker->general->show progress-> display all progress messages (/VERBOSE)), and learned little. However I did link sucessfully by copying C:\Program Files\Microsoft Platform SDK\Lib\comdlg32.lib to *\comd ...Show All

• SQL Server Generating and directing new rows in PostExecute.

  I want to construct a dataset based on all rows passed in from a source and, upon running through all of them, push each dataset record to an output. Unfortunately, upon calling the AddRow method, I get an "object reference not set to an instance of an object" error. Am I not allowed to create new rows in PostExecute Hmm, strange. if you want, drop me an email via here: http://blogs.conchango.com/jamiethomson/contact.aspx and I'll reply so you can send me the package. I can take a look and see if anything jumps out. If you can build the package so that I am able to run it as well (i.e. not reliant on external data sources, just use a script source component instead) then that'd help. -Jam ...Show All

• Visual Studio Problems building using December CTP

  Hi Ive been happily using August CTP (been too busy to upgrade!) with no problems, I tried December CTP but have problems with documenting several assemblies because they result in a command that must breach the 260 characters path limit, but I dont get this issue with the August CTP. I'm not too familiar with exactly what happens during the whole documenting process yet but I'm including a snippet from the log file from both CTPs in the hope that someone might spot something which may help me out. From August CTP doc build (works fine): Info: Building topic P:Exchange.EnterpriseLibrary.Caching.Configuration.CustomCacheStorageData.Properties Info: Building topic M:Exchange.EnterpriseLibrary.Caching.Configuration.CustomCacheStor ...Show All

• Visual Studio Express Editions Install Error - "Encountered a problem" - Solved

  What is wrong with the Visual Basic Install It does not even begin the installer. I get the message "Encountered a problem..", click "OK", and it is done. The message seems to come as the installer gathers files and performs system checks. I do have MS Office installed, and I am running XP pro SP2. I am doing a manual installation from a CD. I tried to install Visual C just to see if there is something else I need to do prior to install. The installer runs with Visual C, Express Server and every other package. VB just does not want to go. Thanks ahead of time for any help. Rudy. You can check if there is any recent logfile in the %TEMP% folder. If you find one that seem to be created for the installa ...Show All

• Visual FoxPro Speeding up SQL Statements

  As per Tamar Granor's interest, I'm curious if I can speed this up a bit; it takes almost 3 seconds of user-time on an IBM X41 tablet (SANS networking). Behold: Select Allt(patient.first_name)+' '+ patient.last_name As PatientName,Record From patient; UNION (Select Allt(patient.last_name)+', '+ patient.first_name As PatientName,Record From patient); UNION (Select Distinct Alltrim(Proper(patient.Record))+' '+Alltrim(patient.last_name)+', '+Left(patient.first_name,1) As PatientName,Record From patient Where patient.Record <> (' ')); UNION (Select Distinct Alltrim(Proper(visit.insur_no))+' '+Alltrim(visit.last_name)+', '+Left(visit.first_name,1) As PatientName,Record From visit Where visit.insur_no <> (' ') ...Show All

• Visual Studio Team System Unit Testing Change

  In CTP3 I can create a unit test for a stored procedure by right click on the sproc in the list of Schema Objects. In CTP4 this functionallity is missing (at least on my install). Should I be able to see the 'Create Unit Tests...' menu option on the context menu for a sproc One other thing I've noticed (that may be related) is that in CTP3 the sprocs show as dbo.SprocName while in CTP4 they show as SprocName.sproc.sql (i.e. the file name is shown rather than the name of the stored procedure) To make this work in CTP4 do the following: 1) Select your database project in the Solution Explorer. 2) Select View | Other Windows | Schema View 3) Expand the nodes until your find a stored procedure, right-click and there is Create ...Show All

• Smart Device Development How to set the default size of a custom control in C#

  I altered this custom button for NETCF: http://www.codeproject.com/cs/miscctrl/PocketPCColourBtn.asp For some reason, which I cannot figure out, when you add a new button to a form the default size is always 200 x 200 pixels. I've opened up all files in the entire package in Emacs and searched for the string "200". I got no relevant hits. Is that size inherited from System.Windows.Forms.Control How do I set a new default size I tried to do it in the constructor with no luck. /Lars Error 3 'ColourControls.ColourButton.OnHandleCreated()': no suitable method found to override C:\Proj VS 2005\Bromma\GUIet\Rund Knapp - Custom control - AdvButton\ColourControls\ColourButton.cs 200 29 ColourControl ...Show All

• Windows Forms Change the default install directory

  Is there any way to change the default installation directory in VS.NET 2003 It is a setup and deployment project. I have found the dialog in the user interface, but there is no property to change the default location from "C:\Program Files\..." to a different path. Is there some other way to do this Thanks ...Show All

• Visual C++ Consuming VB.NET dll in VC++.NET

  Hi, I'm sure this is a question that comes up reasonably regularly, but I'm getting an error with the forum search function at the moment, and haven't found anything with a browse, so forgive me if this is repeating things!! Should also clarify that it's a VERY long time since I've done much C++, so I may well have forgotten something simple... I have a VB.NET dll that I'd like to be able to use in a VC++.NET application (all using VS.NET 2003). all the documentation I've found suggests that all I need to do is to copy the DLL into an output folder and tell the compiler to look in that folder to resolve #using directives, then add a #using "VBFunctions.dll" into my cpp file. Following that, I should be able to create an instance ...Show All

• SQL Server SQL server: How to see tables

  I have VS and SQL server database engine installed in the my office PC (Both legal copies). I would like to see the tables and like to create the new tables / databases as well for learning. How to do that Please help me.... Here is a good example using SQL Server Express: http://msdn2.microsoft.com/en-us/library/ms233763(vs.80).aspx Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Visual Studio Team System Trigger Schema

  I'm not sure if this is a bug, I tried searching the forums with no luck. I imported a SQL 2005 Database schema, which contains 2 tables which are not [dbo] schema, the schema name is [Unblinding].  Everything looks fine, except the triggers for these two tables keep trying to get created under the [dbo] schema, which isn't correct.  On my production database I imported from, the tiggers are in fact under a different schema [Unblinding], not [dbo].  So when I try to deploy changes, I get invalid object name errors.  Here is the alter statement that gets generated: ALTER TRIGGER AuditIns_Users ON [Unblinding].[Users] AFTER INSERT It should be: ALTER TRIGGER [Unblinding] . [AuditIns_Users] ON ...Show All

• Windows Forms ? in file path for activex control in Registry

  Please note the " " in lieu of a ":" in the path below. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\-1-5-18\Components\296878DB682FFA144898BF24E107BBCE] "FB7A40E69E5647B4580A29B901E0D140"=" N \\Program Files\\IDX Web Desktop\\sg20.ocx" This control was delivered as part of an MSI I created using ISS 11. I posted this quesiton to the ISS site, but the moderator only pointed out the fact that this "situation" exist for a bunch of MS files as well! This is not good enough (for me and definitely NOT for my client!). Does anybody know why this happens and/or how to prevent it ...Show All

• Windows Forms Help! "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records"

  Help! I have a Access 2003 Database that holds info like "customer name" "phone number" etc. When I enter that info and then click new record then go back to the previously created record and add some more information in the other text boxes ("address", "age", etc) I get the following error: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records and when I click on details then row, I get this: '((Help_Desk_Center.HDC_DataDataSet.Table1Row)(((System.Data.DBConcurrencyException)($exception)).Row)).Customer_called_on' threw an exception of type 'System.Data.StrongTypingException' What is all that and how do I fix it, get around it, ignore it, or what ever I need to do Thanks for ...Show All

• Smart Device Development CFV@ SP1

  Will the CF2 SP1 be available for Platform Builder 4.2 and 5.0 as a QFE When http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=495314&SiteID=1 ...Show All