lanerebel's Q&A profile

• SQL Server Join Dates....help!

  Hi group, I want to check if a date in table a exists in a holiday table. I need to match the [date] field of both tables. The problem is that table a has a datepart and a hourpart. Table b has only a datepart (the hour part is always 00:00:00.000). How do I join them so that the hour part is not taken into account PLEASE HELP! Regards, Sander Here is the layout: #PeriodDates Column DataType [Date] DateTime Values: 2006-01-01 00:00:00.000 2006-01-01 01:00:00.000 2006-01-01 02:00:00.000 tbl_Holidays Column DataType MarketID Int [Date] DateTime Values: 1 2000-01-01 00:00:00.000 1 2000-04-13 00:00:00.000 This is my query: ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. do you have to use createwindow to create the main directx window? or does the directx api have its own way?

  i am starting to look at directx , do i have to use createwindow to make the window or does directx api come with its own way to create a window ,, Pieter Germishuys wrote: Yep, You have to create a window and then pass it's handle to the method that will create the device. In c++ it will look something like this pDirect3d->CreateDevice(...Window->hWnd...) In Managed DirectX you pass the handle to the constructor of the device. Device device = new Device(... Window.Handle...) The reason for this is in the flexibility it provides when you want to render to other controls such as Panels for creating tools and you want t ...Show All

• Visual Studio Team System error 32000

  Team Foundation Server Dual-Server Deployment ,while install Application Tier get the error: Error 32000.Failed to get CustomActionData. here is log file info: vs70uimgr: DisplayMessage_START:Error 32000.The Commandline '"Z:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\widbloc.exe" -s datasvr -d CurrituckDB' returned non-zero value: 1. [06/16/05,23:57:14] vs70uimgr: DisplayMessage_END:Error 32000.The Commandline '"Z:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\widbloc.exe" -s datasvr -d CurrituckDB' returned non-zero value: 1. [06/16/05,23:57:14] Setup.exe: AddGlobalCustomProperty [06/16/05,23:57:14] ...Show All

• Visual Studio Complex automated build environment, conditional dependency resolution, multiple SCC branches

  I'm trying to set up a fairly complex build environment consisting of multiple configurations. The details for this environment are as follows: I need to have two branches of source code for a project in our SCC system. One for current stable code, ready for release to customers, another for "bleeding-edge" code containing our latest and greatest fixes and features. I need to build each branch independently, but using the same VS Project regardless of what branch of code is being built. This product that spans multiple projects, most of which are evolving independently and some of which are shared among other products ...Show All

• SQL Server client redirect

  Trying just to figure out how this works...how does it know the other server to reconnect to What does the application see, just a SQL error and the application has to redrive the TX Can it route TX to the MIRROR and redrive it like Oracle's TAF Thanks! Hello I think you are talking about the transperent Client redirection thats available if you mirror your DB and have a whitness server available. If so, then the above feature is "only" implemented into the native SQL drivers. If you use other drivers to access SQL you wont be able to use this feature.  So basically the driver itself knows that th ...Show All

• Visual C++ Templates

  Can never find stuff from microsoft. Hard site to navigate. Anyway where can I find some templates I searched and came up with nothing. Thanks   As the previous post mentioned, VS comes with different project skeletons. Not all types of projects are available on all editions. For example, if you are using the VC Express edition then there are lots of project types that are not there (e.g. STL, MFC) Thanks,   Ayman Shoukry   VC++ Team ...Show All

• Visual Studio Express Editions SQL Server 2005 Express Edition April CTP fails to install

  I have spent the last hour trying to find other cases of the same install error on the web, but w/o luck. Does anyone know how to fix the following. I have Windows XP SP2 with VS 2005 Beta 2 (April 2005). When trying to install the "SQL Server 2005 Express Edition April CTP" I'm getting an error at the end of the install. Here's some of the messages: The initial error dialog: "Microsoft SQL Server 2005 CTP Setup" (window title) Microsoft SQL Server 2005 CTP Setup was unable to install on your computer. Microsoft SQL Server 2005 CTP Setup has encountered a problem and will end. After clicking on the "What does this error report ...Show All

• Visual Studio Tools for Office Shared Excel Worksheet on Sharepoint

  I am contemplating the purchse of VSTO to replace some vba on an excel spreadsheet. This vba connects to 2 datasources (SQL), enables a user to enter their name and retrieve only their data, make changes and save the changes (only change the spreadsheet data, not underlying data source). The idea is to put this in a shared workspace on SP Portal and have all 6 of the people update their data and combine for viewing by the VP. I have working but with vba it's megaslow...10 minutes or more to upload. Will VSTO solve this problem Can I use VSTO to write shared excel sheets and put them up on Sharepoint THANKS I have a deadline....:( ...Show All

• Visual C# "Absolute path information is required" bug.

  Hello, I've installed Visual Studio 2005 MSDN and I have problems with C# projects. Whenever I try to start a C# project (Windows Application or something else) I get message box: Microsoft Visual Studio "Absolute path information is required". Solution file is created in specified directory (and *.suo file), but nothing else. I also cannot open/convert C# projects from VS2003. I don't have any blocked/protected directories. Everything works with administrator permissions. I have my system partiotion (C:) and all apps (including VS) are installed on drive D:. I've never installed any VS (2003, 2005 BETA) or any SDK on this machn ...Show All

• Visual Studio Team System VB: Edit and Continue

  I have a problem with Visual Basics Edit & Continue for projects under Team Foundation server, the IDE says its Read-Only even if its checked out prior to debug start. In a non-source-controlled environment it works. You even see the little "lock" symbol on the tab-page with the source code in the IDE on the file you are current trying to edit, so clearly the IDE thinks its locked. Any ideas I ran into this once too, but maybe under different circumstances. I had a setup project attached to a primary project. I deleted the setup project, and then found that I'd recovered the ability to run edit and continue functionality with ...Show All

• Visual Basic vb.net2003 and excel2000, new to vb.net

  Would some one please tell me where I'm going wrong with this I have a referenced Microsoft Excel 9.0 Object Library . I can get this to create, write to, read from and save as. When I try to open the very file this created I get an error. From what I have googled the excel com file has some problems working with vb.net, is this true. If so what is the proper solution An unhandled exception of type 'System.InvalidCastException' occurred in 34907A.exe Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim exl As New Excel.Application If exl Is Nothing ...Show All

• .NET Development dll file is getting locked even after the domain in which it is loaded is unloaded

  hi, i am having a problem with dyanmic loading of assemblies.the problem is that the dll file is getting locked even after the domain in which it is loaded is unloaded.The code below shows a dll search being loaded in domain appdomain.then we get a specific type from the dll and unload the domain thereafter. Now if we want to replace the search dll  or delete it ,it is shown as being used and hence can't be deleted. But unloading a domain should have made it free.Does anyone have a solution for this behaviour .please help.code is as follows =============================== AppDomain appdomain = AppDomain.CreateDomain("loader domain"); ...Show All

• Visual Studio Crystal Report for Visual Studio 2005: where is the .msi for deployment?

  Hello, I understand that in order to use CR in my ASP.NET 2.0 I have to install some CR stuff on the production web server. I should have two choices:  - create a deployment project for the whole web application and use the merge modules to include CR dependencies   OR  - run a specific Crystal Report .msi package on the web server. I would rather use the second choice but I could not find the Crystal Reports installation package (crystalreports10_net_embeddedinstall.msi) on my Visual Studio 2005 Professional dvds. Thanks in advance. Have you checked the dependancie ...Show All

• Microsoft ISV Community Center Forums fast search

  hi all i have used workspace in msaccess 2000 project in order to get an atomic transaction so it can rollback at any problem the workspace allow me to open the record set for once but i need to open the record set with multiple conditions so what i did i opened a generic record set set rs = db.openRecordset("t1",2,dbseechanges) then i used a filter to determine the conditions dim x as recordset rs.filter ='c = ' & c set x = rs.openRecordset but the problem is that it is toooooooooooooooo slow and the applications has to be nearly on time and can not stand this delay so what can i use instea ...Show All

• SQL Server Need a task that will zip a file prior to upload via FTP

  I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this Thanks. We have built task for archiving in Zip, GZip, BZip2, Unix, Tar. We also have task for secure FTP (SFTP). You may give it a try here: http://www.cozyroc.com/ Regards, Ivan ...Show All