Tim Daley's Q&A profile

• SQL Server How to execute ssis package from stored procedure

  how to excute ssis package from stored procedure and get the parameters back from ssis into the stored procedure. Thanks for taking the time to respond. Permission to execute sp_oacreate has to be explicitly granted to users if they aren't to be given membership of the sysadmins role. As I understand it, if you can execute a sp_oacreate command you can run any command line using wsccript.shell. SQL injection attack springs to mind.... This approach is far from ideal and only seems to be appropriate where the users are known, trusted etc. I remember reading a forum question from a person want ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Generic GraphicsBuffer

  From what I've been able to find, there is supposed to be a generic GraphicsBuffer. I have been unable to find it, and it is starting to get very annoying. I'd like to make something in managed DirectX, but it's a little difficult when you can't get anything to draw. Would anyone happen to know why it does not appear for me Microsoft.DirectX.Generic.GraphicsBuffer< T > is only avaliable in MDX 2.0 beta, your prob running MDX1.1 but dont use MDX2.0 caz its beta (and other reasons) ...Show All

• Visual Studio File or assembly name CrystalDecisions.Web, or one of its dependencies, was not found.

  To All I have developed a report in VS 2003 that is ran in both a Win App and a Webpage.  When I run the app or the webpage via "localhost" the report is ran correctly.  When I run the webpage on our webserver (different machine) I get the error:   "File or assembly name CrystalDecisions.Web, or one of its dependencies, was not found." I have found a post on the http://support.businessobjects.com website refering to the assemblies being different versions but this not the case here. Following is the full error from the website:   Server Error in '/webKanban' Application. Hello David, It sounds like you need to deploy ...Show All

• SQL Server SQL Express hangs on "Setting Registry Security"

  The last few lines of the log show: <Func Name='LaunchFunction'> Function=Write_sqlRegSDDL <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: Write_sqlRegSDDL PerfTime Start: Write_sqlRegSDDL : Tue Nov 08 23:13:03 2005 WinXP Pro SP2, just FDISK'd and re-installed my OS today - no leftover RC/CTP bits on the machine.  I'm logged in with my Domain account.  I belong to the local Administrators group and am able to install other software (also installed all of the client tools such as SQL Server Management Studio, etc. Network gl ...Show All

• Visual FoxPro Leading zeros

  I am trying to create a numeric field without decimals with leading zeros. This could also be a character field as long as the number is right justified. How do I do this Thank you Suppose you want a 10 characters (numbers) with leading zeroes. nNumber = 1234 cNumbers = Padl(Transform(nNumber),10,"0") HTH   ...Show All

• Visual Studio C# Express 2005 and Report

  Dear All,   I am using C# Express 2005 and SQL Server Express 2005 as well. I am planning to use no-touch deployment as well. At the moment, I am stuck as I cannot find any report designer to make my report work in the enviroment of C# Express. Is there any way or extension that I can include into the C# Express so that I can use to build the report Highly appreciate your advice.   Regards,   LG Install Visual Web Developer 2005 Express Edition ( http://msdn.microsoft.com/vstudio/express/vwd/download/ ). Then install the Report Designer and Report Viewer control from http ...Show All

• SQL Server cursor problem

  Actually My proble is DECLARE @SNO INT DECLARE CURS_FOR_SNO CURSOR FOR SELECT * FROM MACB where cntrl_no='DC000429' and isnull(listed,'')='U' AND ISNULL(SNO,'')='' ORDER BY SNO OPEN CURS_FOR_SNO FETCH NEXT FROM CURS_FOR_SNO WHILE @@FETCH_STATUS = 0 BEGIN SET @I=@I + 1 SET @SNO=@X + @I UPDATE MACB SET SNO=@SNO where CURRENT OF CURS_FOR_SNO FETCH NEXT FROM CURS_FOR_SNO END CLOSE CURS_FOR_SNO DEALLOCATE CURS_FOR_SNO it gives read only column but i want to update that so plz, solve my problem YOu will have to pout the UPDATE syntax after the Select statement, for more information and samples, look in the BOL. HTH, Je ...Show All

• Visual Studio Visual Studio 2005 on VB 6.0

  Hello all, We want to start developing our project in .NET environment but at present we have got VB 6.0 installed on our programmer machines. For existing system we can't get rid of VB 6.0. 1. Is it possible to install Visual Studio 2005 on the same machine or need to install in other machine 2. If we install VS 2005 and VB 6.0 on the same machine, if we create an .EXE file for our existing project, our users doesn't have .NET framework. Will this cause a problem 3. What is the best way to use both VB 6.0 and VS 2005 We want to go from VB 6.0 to ASP .NET with C#. Each answer to this question will help me to make up my mi ...Show All

• Visual C# PInvoke Doubt.

  Hi, i am working for Certificate Management module in a Smart Card Management System project. I am planning to use Platform Invoke to access the XEnroll.dll, CertCli.dll and Certadm.dll. I am planning to create an wrapper like the following public class XEnrollWrapper { [DllImport] << Function that i like too call from the win32 dlls>> } My Question is: The certcli.dll or XEnroll.dll may be changed/replaced entirely in feature, in this case i have to change not only my wrapper and also the core library i am going to develop because the prototype of the function in the dll may change or the function i am u ...Show All

• Visual Studio Team System Suite downloads and Install - clear confusion please

  Hi, I've just downloaded the MS team suite 180 day trial and intalled on our W2003 server test box that has SP1, SQL server 2005 RTM, and sharepoint server to evaluate if we could replace our source safe system with team suite. Am I correct in thinking that I will also need Team foundation server to allow the developers boxes to connect to Is the setup that team suite integrates with VS 2005 so you can design applications and so on, but if i want to do 'source control' e.g. source safe type stuff, I will need foundation server to upload, and check-in code to Presumably everything is now integrated with VS2005, so if ...Show All

• Visual Studio Team System Check for throw or rethrow in a try block

  Thank you David ...I have another question.... How can I check if there is any sentence in a block ... for example i want to check an empty catch and I do this: public override ProblemCollection Check( Member member) { Method method = member as Method ; bool isCatchExists = false ; bool isThrowExists = false ; if (method == null ) return null ; InstructionList iList = method.Instructions; for ( int i = 0; i < iList.Length; i++) { if (iList .OpCode == OpCode ._Catch) { isCatchExists = true ; } if (isCatchExists) { if ((iList .OpCode == OpCode .Throw) ...Show All

• .NET Development Combine Visual Studio with Access

  Hi All, I have an app developed in Visual Basic 2005 connected to an SQL Server 2005 database (both Express editions). What I would like to do is create an Access .adp connected to the same SQL Server 2005 database. It seems however that Access (I have 2002) does not support developing against SQL Server 2005. Never mind, I can use Visual Studio or SQL Server management studio 2005 to make changes to the database, and I can connect the .adp file to the database and make data changes. However when i open the .adp file i get a connection error when trying to run the VB app and I need to run both simultaniously. Is this due to some ...Show All

• Visual Studio Express Editions how to open a folder in code

  How do i open a folder in code eg.  I have a password locking system anmd I want to (after the password has gone) to have a window comming up with a folder the inaccessable otherwise.  How would I do that ...Show All

• Windows Forms Deploy chm file with click-once

  I'd like to include a chm file with the application that I am deploying, but no matter what subdirectory of the project I put it in I can't seem to get the file to be included in the deployment. The help file does work correctly from my application on the development machine where I have it located in the project bin directory. Right now, my deployment is just to a directory from which I burn a CD. Thanks, jerryK You need to make sure the BuildAction of the .CHM file is set to "Content". Then it should show up and be available. ...Show All

• Visual Basic Generating a unique ID

  I want to generate a unique ID in VB.NET that starts with ASXXXXX where XXXX represents a number. The number has to start in an orderly fashion. This ID will then be stored in a SQL Server express table. Can someone advise how this can be achieved. I'm not sure how 'unique' a 5 digit number is . What you could do, as this is being stored in a database, use an incrementing index column and use that as your ID. Or, depending how often your Unique IDs are generated, use some format of Year, Month, Day, Hour, Minute and/or Second. If you are willing to extend the number to 12 digits (YYMMDDHHNNSS) you ...Show All