Nick Boyd's Q&A profile
.NET Development SqlBulkCopy problem
Using SqlBulkCopy to bulk copy tables from DBASE to SQL server. An error occurs during copying one of tables. The error is "The given ColumnMapping does not match up with any column in the source or destination.". I checked column mapping is fine. Also, all other tables are ok. This table has 138 columns. Not sure if SqlBulkCopy have limitation on the number of columns Did anyone have the same problem Any idea Thanks The ADO.Net forums may be able to provide answers to your specific question and/or provide some tips on determining the cause of the error. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=45&SiteID=1 ...Show All
Gadgets ActiveX for Sidebar best practices
I am interested in further exploring the possibilities of using/developing an ActiveX object for use in a Sidebar gadget but havent done anything like this before. What are the best ways of proceeding with this Can i use Visual Studio 2005 to create an ActiveX object i tried using ATL project, i was able to compile it but not to register it yes his article looks good but he says: "Now our initial ActiveX control implementation is complete – you can press F7 to build and register your new ActiveX control." when following his instructions F7 doesnt do anything furthermore i dont have that option ...Show All
SQL Server SP2?
I have recently inherited the administration of a SQLEXPRESS db. I'm not sure how long it's been in service. Do I need to install a service pack Where do I find the SP level hi Ted, Ted Dawson wrote: I have recently inherited the administration of a SQLEXPRESS db. I'm not sure how long it's been in service. Do I need to install a service pack Where do I find the SP level SP2 is currently still in CTP and thus not fully "supported", but should be released "when ready" (Q1 2007)... if you like to know the actual build and level you can execute SET NOCOUNT ON; SELECT SERVERPROPERTY ( 'ProductVersion' ) AS [Build], SERVERPROPERTY ( 'ProductLevel' ) AS [Version]; --& ...Show All
Visual Studio Installing .net framwork on windows xp pro sp2
When i was trying to install .NET framwork 2.0 on "windows XP professional service pack 2" i recieve this error message: Component .NET Framework 2.0 has failed to install with the following error message: "Fatal error during installation. " The following components failed to install: - .NET Framework 2.0 See the setup log file located at '...' for more information. in log file : Process exited with code 1603 please help me. hi, Thanks for your reply,but those threads didn't solve my problem. (i disabled services,antivirus,firewall and etc) Today i found a simple way to solve the problem! Because my processor type is AMD Athlon 64 ,the windows "Execution Protectio ...Show All
Visual C++ Problems with my project
I have 3 problems I am unable to resolve regarding operating visual studio .net 2005 I created an MFC application project using VC++ using the wizard. 1. My project got messed up in the solution explorer panel somehow. Now, instead of having folders called Source Files, Header Files, etc it is saying Release, Debug, res, and hlp. Its just a listing of the directory structure now, and the folder contents shown include intermediate build files like the precompiled headers, obj files, exe file, etc. How can I get it back to regular again without having to totally recreate the project again And, more importantly, what causes this change to happen in the first place 2. Even though I changed my project's .ico file in the resources, m ...Show All
SQL Server Invalid class string in Enterprise manager
Hi, Sorry to be cross-posting, but I'm not getting much response to this... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=807314&SiteID=1 ...which I don't even think is in the right forum anyway. can anyone help Basically, I get a error box saying "Invalid class string" in Enterprise Manager whenever I try to run a query. nope didn't work. I installed the Analytical services, ran the regsvr line (which worked) but still having the same problem. btw, I used to have some version of SQL Server 2005 installed (as part of Visual Studio 2005) but removed this, as I though this was causing the problem. I tried a repair of Visual Studio 2005 hoping this might help, which t ...Show All
Visual Studio Express Editions Right margin indicator in editor?
Is there a way to enable some kind of right margin indicator in the editor I would use this as a visual guide to keep my lines of code under a certain length so they don't wrap when I email, print, whatever. Thanks. joeljkp wrote: Is there a way to enable some kind of right margin indicator in the editor I would use this as a visual guide to keep my lines of code under a certain length so they don't wrap when I email, print, whatever. I haven't found anything. Here's how I help myself work around it: First, depending on your preference, in the Tools | Options | Text Editor | All Languages | General property sheet, you can turn word-wrap on or off. If it is on, you can request ...Show All
Visual Studio 2008 (Pre-release) Using controls defined in exe-assembly from external xaml-files.
I have a program that can load xaml-pages and resourcedictionarys from an uncompiled xaml-file during runtime. This works fine but one thing that bothers me is that all controls i use in these files has to be compiled in a dll-library, if they are in the main exe it won't work. Take this resourcedictonary as example: <ResourceDictionary xmlns:MyNamespace="clr-namespace:MyControlLibrary;assembly=MyControlLibrary" xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " > <Style x:Key="testbutton" TargetType="{x:Type MyNamespace:GUIButton}"> //Properties here </Style> </ResourceD ...Show All
Visual Studio 2008 (Pre-release) Dynamic Queries accross joined objects. Lambda
Hi all, I am attempting to construct a dynamic query across a join (Contact belongs to one company). I have achieved this using hard coded Lambda expressions: var FilteredContacts = DB.Contacts.Where(c => c.ReadOnly == false ).Select(c => c); FilteredContacts = FilteredContacts.Where(c => c.Company.Name.Contains( "Compan X" )); This works fine but I am looking for a way to construct this on the fly, this is what I have so far but I can not get it to work IQueryable q = DB.Contacts.ToQueryable().Including(c => c.Company); ParameterExpression p = Expression .Parameter( typeof ( Contact ), "c" ); ParameterExpression pCom = Expression .Parameter( typeof ( Company ), "Compa ...Show All
SQL Server Verfiying stored procedures
Hi, I wish to run a stored procedure which will verify a digital signature on some data and return a pass or fail. Is there a way for me to ensure that the stored procedure returning the result is one created by me rather than one created by someone else that always returns a pass without checking the digital signature I know i can encrypt stored procedures but these encryptions can be broken with a profiler/ debugger. Thanks, Ewen Are you using SQL Server 2005 or SQl 2000. SQL 2k5 has much more functionality in encrypting the information from stored procedures. Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Windows Forms DataGridView Header in VS2005 (c#)
Hi, How do i give my DataGridView an overall Header. Ive found examples with row and column headers but i want to give it an overall header. The previous way to do it was using CaptionText for a Datagrid but i cant find a way with DataGridView. Any help would be much appreciated. Thanks. Read this post ...Show All
Visual C++ /QIfist deprecated, but bad fp conversion still sometimes generated?
I've noticed that specifying the /QIfist switch to the compiler in 2005 raises a deprecation warning; according to the documentation this is because the compiler now generates the correct code under all circumstances without it. With the /fp:fast option set, most of the time this seems to result in a call to _ftol2_sse. However I have noticed that in some cases, specifically the assignment of a float onto an unsigned int (such as the one detailed below), the compiler still generates the terrible fnstcw..fldcw..fistp...fldcw instruction stream, which is a serious performance hit for us. At first I thought this was because of the unsigned nature of the output, but upon examination the fldcw is simply setting the rounding mode of the FPU t ...Show All
Visual C++ Access outlook address book
Hi, I work in medical domain and i need to email to all the patients list that had the treatment dated the nextday thru my VC++ project(i.e i need to extract the email addresses from the outlook client and then mail them. ) the project is written in win32. Any help is appreciated. thanks, KK_VC. I don’t think it is a good idea to do it in VC++. You have to use COM for that. But if you use some VB instead, you'll be able to accomplish quite a lot. You'll find a lot of help here http://www.outlookcode.com/ You'll find how to send e-mails to a particular address here: http://www.outlookcode.com/d/code/sendreminder.htm But you'll have to be a bit more specific about how you store the list of peop ...Show All
SQL Server Restore Databases in AS 2005 from CAB Files created in AS 2000
I have to restore some analysis services 2000 databases on AS 2005. Is there some tool which can perform this Hello, I understand that the solution of Artur will work, if you have access to the relational database from which the cube is calculated because when you finish migrate the cube it has to be recalculated. I have the same problem (a few cubes that I’d like to try in 2005, but I don’t posess the access to the relational database). Is there any way of migrating the cab without the access to the relational db Regards ...Show All
Visual C++ Running an external .exe from C program
Hi, I want to run an external .exe file from my C code. If i use "system" command the external exe runs in the same window. How can i run the child exe in a different window Thanks Karthik Maybe instead of system("MyExternalExe.exe"); you should try this: system("start \"My external EXE\" MyExternalExe.exe"); I hope it helps. ...Show All
