clint 2's Q&A profile

• SQL Server DTS : Format Problem !

  I have a statement in the DTS ( Activex Script ) like this : TomorrowDate = Format$(Now, "yyyy-mm-dd") When i am running the package, i am getting the following error : --------------------------- ActiveX Script Task: undefined --------------------------- Error Code: 0 Error Source= Microsoft VBScript compilation error Error Description: Invalid character Error on Line 8 Can anyone tell me what is the solution to this error Thanks in advance. Hi vijay, Thanks. Even when i removed $ from format, still an error : Telling that : Type Mismatch "Format" ...Show All

• Software Development for Windows Vista Outlook 2007 On Vista Crashes When Calendar Reminder Pops Up

  Hi, I'm not sure if this forum is the right place to be asking this question. However, two weeks ago I installed Windows Vista Ultimate and Office 2007 on my Dell laptop. Everything works fine, except Outlook 2007. Whan a calendar reminder pops up, Outlook 2007 crashes. Has anyone else seen this problem or know of a solution It is incredibly annoying! Thanks very much in advance, Mike Puddephat. This is happening with me with the installed Office that came with my laptop. I have Office 2002 so I thought upgrading to 2007 would solve this problem but maybe it won't. Maybe I'll just have to get a Mac. I didn't know Vista would suck so hard. Did anyone answer your question ...Show All

• Visual Studio 2008 (Pre-release) Linq-Objects via WCF

  Hello, i am developing a service via Windows Communication Foundation. I have added a DataLinqObjects.dlnq with my Objects to the service-project. And want to retrieve them in the Client. But then i get an Error: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:00:59.9680000'. I think that is because the Linq-Objects aren't Serializable, how can i do this Code of my Method: public List <DataObjects. User > GetUserList() { Table <DataObjects. User > table = _context.GetTable<DataObjects. User >(); List <DataObjects. User > list = new List < ...Show All

• .NET Development Too many arguments specified error in stored proc

  I'm getting a 'too many arguments specified' error when I call my stored proc. I've assigned the stored proc to a SqlDataAdapter and a DataSet which is called when the SqlDataAdapter.InsertCommand is called. I've checked the numbers of variables and I can't see where there is a mismatch in the number of arguments being called. I assume that this error has something to do with how I am retrieving the SQL autonumbered identity column (CitationID) with SCOPE_IDENTITY(). If someone could look over my code and let me know what I'm doing wrong, I would greatly appreciate it. Stored Proc: ALTER PROCEDURE tbl_Citations_AddNewRow @CitationType nvarchar (6), @ARTFlag nvarchar (7), @Title nvarchar (1000), @PublicationDate date ...Show All

• Visual Studio Team System Working folder is already in use

  Just migrated from VSS to TFS and its fantastic! Having a problem on my PC when trying to get source code for a project. I get the message ' The working folder is already in use by another workspace on this computer'. I have cleared all the work spaces for all users on my machine (as far as I can tell) by clearing down the C:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Team Foundation\1.0\Cache\VersionControl.config files. I have also had a poke around in the tbl_Workspace and tbl_Workingfolder on the server to make sure there are no stray workspaces defined. Does anyone have any ideas on how to resolve this One thing that may be causing the problem is that our development team is working on vir ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Toolbox

  in the first XNA CTP was a XNA toolbox with a kind of workflow symbols (integrated in vs 2005 ) is this feature still there No this is not the same thing. XNA is the name of the overall technology area. the products that come out of it are different things. XNA Build, XNA Framework, XNA Express etc Yes its confusing... ...Show All

• Visual C++ How to add paths to SDK in VC++ Directories automatically?

  I am developing a small SDK of image processing for VC++2005 which includes .h, .dll, .lib files. I would like the the sdk paths of my SDK (path to \lib, \include) to be registered automatically during installation (or through a batch file executed by the user manually) in the VC++ Directories (tools->options->project and solutions->vc++ directories). How can i do that I have seen that the Windows SDK has a tool vcintegrate.exe which does that. How can i achieve such ability for my custom SDK through the installer or through simple batch commands, so that the user does not have to do that manually Thanks. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Sphere mapping

  In mdx 1.1, you can enable automatic generation of sphere mapped texture coordinates with: this._device.TextureState[this._stage].TextureCoordinateIndex = 0x00040000; Is there an xna equivalent Or do you have to do it manually This doesn't appear to do it: this._game.GraphicsComponent.GraphicsDevice.SamplerStates[this._stage].ElementIndex = 0x00040000; Automatic texture coordinate generation like that is part of the fixed function pipeline. Xna doesn't support the fixed function pipeline anymore and so you will have to code this yourself in a vertex shader. The bright side is that you can code all sorts of texture coordinate generation, not just the fixed functions that you previously had available. Chee ...Show All

• Visual Studio Tools for Office What is good way for handling about .pst(schedule, task)?

  Hi~ Nowaday, i'm trying to handle(insert or update..etc) about .pst file(outlook2003). But, still in now, i can't decide in two way. One is Automation and the other is mapix(mapi interface). Can someone tell me what is best way with reason Have a nice day~ Dear Mohit Gupta. Firstly, Thanks for your reply. From now on, I am trying to post my question in office developer forum. Have a nice day~ ...Show All

• SQL Server can't decrypy the child package?

  I had a child package AAA The ProtectLevel of AAA is "EncryptAllWithPassword" and PackagePassword is "passtest" now I put a Execute Package Task on Control Flow TAB of Package BBB in this task I want to Execute package AAA,after set Password "passtest" of Execute Package Task ,I execute package in command line DTExec.exe /F BBB.dtsx I get error message, can't decrypt package AAA Where can I set the PackagePassword of AAA in Execute Package Task.   ycjj wrote: I didn't use any parent variable in child package,   the password protected child package can't be executed in parent package,how can I set the child's passwo ...Show All

• Visual Studio Team System installing Team Suite and Db Pro from MSDN

  MSDN now has the following downloads: 3629.6 MB en_vs_2005_vsts_dvd.iso 3827.0 MB en_vs2005te_for_db_pro_dvd_X13-15163.iso I'm a Visual Studio pig. I want everything, all features, power toys, service pack. Do I need to: 1. install en_vs_2005_vsts_dvd.iso followed by en_vs2005te_for_db_pro_dvd_X13-15163.iso 2. install only en_vs2005te_for_db_pro_dvd_X13-15163.iso 3. install power toys 4. install service pack The download finally finished and the answer is in the readme file. Team Suite or other product must be installed before Db Pro as the readme file says: Visual Studio Team Edition for Database Professionals has the following system requirements: · Visual Studio Pro ...Show All

• SQL Server Display a KPI need the same Dimension on its Value and Target?

  I mean, I have a KPI, it's value is set to a measure of a measuregroup based on a facttable A. and it's Target is set to a measure of another measuregroup based on another facttable B. Now I want to display the KPI, with a given dimension's slice. My question is, is it needed that the dimension I chose must be shared by both the measures of KPI's Value and Target For an example, If I dispaly the KPI with the Promotion Dimention, and the Promotion Dimention has a relation to the KPI's Value's related measure(There's a PromotionKey column in facttable A; ), but it has no relation to the KPI's Target's related measure(There's NOT a PromotionKey column in facttable B). Could I do so Thanks! that's what i am looking for! Th ...Show All

• .NET Development Returning Exceptions with ExecuteScaler and ExecuteNonQuery from RAISERROR in a SQL Proc

  I am experiencing that I am not able to return an exception from a stored procedures that I call using ExecuteScaler if my select statement is before the RAISERROR statement. I do understand that if I use ExecuteReader I have to perform a reader.NextResultSet to get an exception to fire. This is working fine. Is there any way at all to return an exception with ExecuteScaler(after the select) or is this not possible. I'm looking for the answer so I can avoid using this method entirely and move to using a reader. Is using a reader and calling NextResultSet the next best option if I want to ensure all exceptions get returned and have good performance even if it is only returning one value I'm assuming this will perform bett ...Show All

• Visual Studio Express Editions Resource Compiler Fatal Error RC1015

  I downloaded the MediaShare starter kit for VC++2005, but can't run it because of the "Fatal Error RC1015" message I recieve. This error occurs because VC++ can't open the include file "afxres.h". I searched my computer, and found two of this file: one in lower case, the other in upper case. How can I resolve this issue include "C:\Program Files\Microsoft Platform SDK\Include\mfc\afxres.h" then it should be compiled with no error ...Show All

• Visual Studio Team System Relative path for Data Source files in Web Tests

  Hi, In my web test I am using a .csv file as a data source. Is there any way to provide the relative path name instead of hard coding it. The purpose is, I may need to copy the whole web test onto another machine where the absolute path may fail. Thanks At design time, I believe it refers to the directory that vs runs out of, which is \Program Files\Microsoft Visual Studio 8\Common7\IDE Did you try this one ...Show All