IanSJ's Q&A profile

• SQL Server Dynamic loading of a file

  I've been told by Kirk that it is possible to load a file whose metadata is unknown at design-time by using bulk insert along with a file (not a flat file) connection. He didn't elaborate though. Can anyone explain -Jamie Jamie, Bulk loading to several different tables with known metadata is simple. I don't know how one could load to a table with completely unknown metadata. The file connection works fine with the bulk insert task. If I remember this discussion, you were asking how to put a load into a foreach loop. If you had flat files with several different schema, you could name them accordingly and load into the table with the ap ...Show All

• SQL Server variables in variables

  It it possible to define a variable that is the result of 3 other variable like @[User::Total] = @[User::varA] + @[User::varB] + @[User::varC] I know that i can set it with a scripttask but is there a way to define it when creating the variable Absolutely - and this is one of the cool things about variables. They can be set using expressions just as any other property of an object can be. Select the variable in the variables pane and hit F4. The properties pane will appear showing properties of the variable. Set: EvaluateAsExpression=TRUE Expression=@[User::varA] + @[User::varB] + @[ ...Show All

• .NET Development [URGENT] COMPILING AND RUNNING THE .NET APPLICATION on LINUX

  Hi: Question: I have developed an application containing 2 projects (one is of type class library and the other is a windows application (.exe) ). I want to compile and run the application on Linux. I know that there is a platform for linux called MONO, but can't find a good article on COMPILATION AND RUNNING THE .NET APPLICATION. I have found some articles but they only contain the compilation of single file e.g. HelloWorld.cs and thing like that. But i want to compile whole solution (THE SOLUTION FILE). Can any one help me and post the links of the articles that cover my problem Please also post the software requirements. ANSWER: Still wa ...Show All

• Windows Live Developer Forums How to get the IAccessible of the child of the DirectUEHWND in the IMWindowClass

  Reccently I am doing a test which could get the IAccessible of the child inside the DirectUIHWND.And i used the Inspect tool and could see the childCount of the DirectUIHWND,but i cannot get it using my own programme.my code as follows: CWnd *pMsnWin = FindWindow("IMWindowClass",NULL); HWND hWnd; CWnd *pConWin; HWND hConWnd; if (pMsnWin != NULL) { MessageBox("find the msn dlg window","IMWindowClass"); hWnd = pMsnWin->GetSafeHwnd(); pConWin = FindWindowEx(hWnd,NULL,"DirectUIHWND",NULL); hConWnd = pConWin->GetSafeHwnd(); if (hConWnd != NULL) { pAcc = NULL; HR ...Show All

• Visual C++ cannot compile ANY C++ project in VS2003

  I think I've screwed up the paths the IDE uses to search for include files and header files. I am unable to compile any project using C++. I cannot compile brand new Win32 console apps or MFC apps. The compiler error is : c:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\atlmfc\include\afxv_w32.h(166): fatal error C1083: Cannot open include file: 'windows.h': No such file or directory I've tried running the repair and reinstalling VS2003, but nothing has fixed the problem. I searched the net and found one person who suggested running C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\vsvars32.bat, but not even this approa ...Show All

• Visual Studio Team System Error 32000: Team foundation server installation setup fails.

  Hello , I have been trying to install on a clean m/c. I have installed the following 1. win 2003 server with sp1 enterprise edition 2. IIS 6.0, SQL 2005 3. Windows sharepoint services with sp2 I followed all the instruction mentioned in the installation guide. The installation exceutes till the last and gives the following error. The commannd line "c:\program files\microsoft visual studio 2005\team foundation server\tools\createds.exe" /setup /install http://server/reportserver/reportservice.asmx tfsrepords" datasource=server;initial catalog = tfswarehouse" returns non-zero value : 4 I have went throu ...Show All

• Software Development for Windows Vista SetWindowsHookEx and JournalRecordProc

  Hi, SetWindowsHookEx(WH_JOURNALRECORD,JournalRecordProc,hInstance,0) This is failing on Vista build 5231. Is this just not supported yet in the beta or is there a change to the SDK that I'm not aware of Thanks, Marcus Hi, I am looking for an answer to this also. When I call SetWindowsHookEx specifying Journal record I get an access denied error. Other hooks such as low level mouse seem to work fine. Does anyone have any infomration on this thanks, tim ...Show All

• .NET Development How to call a method in a windows service from windows form

  I have a windows service which implements a task scheduler for our project(say service1). I also have a windows application which uses this service(winapp1). I want to call a method in windows service from windows application and also expect it to return the result(like service1.somemethod()). How do I do that Regards, Hema. You wont call a method in Windows Service directly. Windows Services acts as a hosting container for other services that are exposed as remote object. What you would do is to create a separate class library that contains remote object for your scheduler a ...Show All

• Visual Studio Express Editions Error when calling function on VB activeX dll from C#

  Hello can sombody help in solving a problem I am having a problem when trying to call the function of VB ActiveX dll from C# and I am getting the error show at the end. The VB Function is Public Function GetStatistics(ByRef varStats() As Variant, Optional ByVal stStatType As e_STAT_TYPE = e_stCLIENT_STATS) As Long And the RCW has created the function as follows (when adding ref from Visual studio) int GetStatistics( ref Array varStats, e_STAT_TYPE stStatType); The problem is we cannot create the object of Array class as its abstrac ...Show All

• Visual C# How to tell if Windows or Web GUI called library

  Is there a system property/method that I can call from within my c# library assembly to tell if it is being called by a windows or asp.net .net program p.s. I have found one way, and that is to put a try catch around a ::global or a webconfiguration call, but I am guessing that this adds overhead. Evan Smith I don't know why you should want to know it. It feels like a bad design to me and it should not need to be know for the Library. The only thing that i can imagine is that you use preprocessor directives to minimize file size, exclude some classes or use a other factory class. ...Show All

• Architecture Restrictive Development- Propagating Architectural Patterns

  How does the architect get their architecture propagated throughout analysis, design, and the construction phase   I have only found one way to successfully do this.   It is what I refer to as Restrictive Development. Here is an overview of Restrictive Development .   I would like your feedback on this.  Do you use another technique I also think architecture governance is an important issue and I guess in a sense I am doing something similar when I provide "Module Blueprints" as part of the Software Architecture Document. One difference, I believe, is that my ( ...Show All

• SQL Server Access 2003 and SQL Express

  Is there a way to integrate Access 2003 as the Front End for SQL Express I tried, but I can't make a new Access project because I need to specify a login/pass and I have no idea what those are set to, or if I need to make an account somehow. As you can see, I am totally new to SQL and any help would be appreciated. Thank You, James The default login/password would probably be sa, with an empty password. That's generally what SQL Server uses before it's changed by the end user. ...Show All

• SQL Server How do I integrate with SourceSafe or TFS-VC?

  Where can I find information about how to integrate a SQL 2005 database with either SourceSafe or Team Foundation Server Version Control I would like to have database changes for tables, views, stored procs, etc. under source control. Is this even possible You do not integrate the database itself with source control. What gets integrated is your development environment. (i.e. Management Studio and BID Studio). Basic steps are 1) Install Management Studio and BID Studio 2) Install VSS (and create source control database and users) 3a) In Management Studio create new SQL Server Scripts project / soluti ...Show All

• Visual C++ Nameless namespaces in c++ 8.

  I am recompiling a program with a nameless namespace using visual studio c++ 8. However, I get "error C2888: anonymous-namespace." Does anybody know if I have to set a switch on the compiler If so, which switch. If not, is this a bug If so, is there a fix for it Regards. PS - What I am trying to do is to declare internal linkage instead of external linkage. As per the standard: The new C++ Standard reads in "Section 7.3.1.1 Unnamed Spaces," paragraph 2:    The use of the static keyword is deprecated when declaring objects in a           namespace scope, the unnamed nam ...Show All

• .NET Development Can I update several attribute values with Update operation in SQL 2005?

  Can I update several attribute values with Update operation in SQL 2005 I can run the Code 1 correctly. But I hope to update several attribute values in one operation, so I create the Code 2, but I get error below when run it. Is it possible to update several attribute values in one operation XQuery [cw_Bookmark.Bookmark.modify()]: Expected end of XQuery expression, found 'replace'. //-----------------------Code 1 ------------------------------------------- create procedure Hellocw_ReplaceBookmark9 @UserId          varchar(80)='61809B69-4AD5-40E4-B456-D957C78DD99E', @BookmarkTitle   v ...Show All