ACraigM119's Q&A profile

• SQL Server SSIS Package Store and Sql Server

  Hi everyone, Just a question, generally speaking, when you’re going to save a dtsx package, what are the main differences between SSIS Package Store and Sql Server -When you choose ssis package store option you can save the package in: /MSDB/Maintenance Plans/ mypackage (it saves to sysdtspackges90) /File System/mypackage (are we asuming that sql is going to save it on the folder where .dtproj project file is ) -When you choose sql server option: /Maintenance Plans/mypackage (it saves to sysdtspackges90) Thanks for your comments. Well keeping your Maintenance plans seperate to stuff that you have built yourself in BIDS sounds like a good idea to me. I think you ca ...Show All

• SQL Server 'Invalid authorization specification' from IDBInitialize::Initialize (c++)

  Hi I've been trying to connect to my local SQL Server instance (SQL Server 2005) using the SQLNCLI interface from c++ without success. I consistently receive an 'Invalid authorization specification' error (SQL state 28000 and SQL error number 0) when I call IDBInitialize::Initialize to connect to the database. I was hoping someone here could shed some light on this and help me out. The strange thing is that I get no error if I leave the user blank (L"" in vValue.bstrVal) and try to connect. Also, IDBProperties::SetProperties returns 0 when the user is blank but 40eda when the user is set. This seems to be a message from the pipeline facility but I haven't found the description of the code (0xeda). The user in the database is conf ...Show All

• Visual Basic control panel items

  Hi there, I'd like to ask how could i retrieve the name of the items on the control panel. I know they are .cpl files and know how to run them, but how could i get the name of them thnx; There is a sample C# application that does this here: http://www.codeproject.com/csharp/appletengine.asp You can try taking that and porting it over to VB. -Scott Wisniewski ...Show All

• Visual FoxPro form help

  hi! i am new in vfp now i am creating new proj and icreate form with theree grid i would like to auto increment id field (tab not to stop on this field) also when i click add buton it will refresh only parent form field ( not grid field) thanks lavesh thanks for your reply i am using vfp 6.0 what is the code for when i save record it will auto increse no and when i add record i want to refresh parent field and grid field ( e.g if you create invoice with order detail and when you save invoice the new invoice no increses auto and customer and order detail both are blank for new invoice) ...Show All

• Architecture Transaction across Applications

  HI, We have a Web application that consists of a Sharepoint web site with ASP.NET pages as web parts. In the admin module of the application, we have a provision to add a user. On adding a user through the application, the user is added in 3 places, namely in Active Directory (AD), SQL Server database and in Sharepoint database. All this is a part of ASP.NET code with no transaction happening through out the user creation. Now is there any way to impose a transaction in this process That is, until all three AD, Sharepoint and SQL Server databases are up and running and the creation of user happens with no errors, the new user must not be committed in all three databases. This is very critical as it causes inconsistency if the u ...Show All

• .NET Development Best Practice: Activity status

  I'm back again! For me this is a bit hard to grasp/tackle. My application has a UI and several other classes. I know that no class should interact with the other if its not needed, which is fine. I know about these things. If I have a class doing some work (not the UI), I want to be able to notify the UI of the status/activity that is going on in this work. Is it correct for me to say that I should create events which would be raised from this class, so that the UI will catch it and display the status to the user Obviously this "work" class knows nothing about the UI class, nor does it need to. All it needs to do is its work and then display the status of what its doing, wherever this status is displayed is none ...Show All

• Visual Basic How to upload files

  Hello I got a problem with uploading files. Look at the code: My.Computer.Network.UploadFile ("D:\file.txt", " http://www.onh1986.com/file.txt ", username , password ) And I set permission to "777". And it couldn't to upload the file. What's problem, please Thanks & Regards I don't know if I'm right, but if you send a File to per HTTP, you will have to write some script on the HTTP-Server, which will handle the File-Upload. Something like < php Check POST-VARIABLES for uploading File If (IS_FILE_TO_UPLOAD) then MOVE THIS FILE TO SOME DIR end if > ...Show All

• Visual C# Opening and printing a word doc.

  How do you do it I.ve tried using a rich text box to display the Text and images, but first i had to convert the doc to rtf. which is going to take forever if i have to convert all my doc's. Help!! Much appreciated. Hi check this Sending Documents to the Printer The PrintThisFile method in the cShellExec class lets you send a specific file to the printer. The code fragment for PrintThisFile is: Public Sub PrintThisFile(FormName As Long, FileName As String) On Error Resume Next Dim X As Long X = ShellExecute(FormName, "Print", FileName, vbNullString, 0&, SW_SHOWMAXIMIZED) End Sub As with both the ExploreFolder and OpenThisDoc methods, the PrintThisFile method requires that y ...Show All

• Visual Basic Interoperability in VB6 with dll in VB.NET

  Hello, I have a problems with one dll i've made in vb.Net 2005. The problem is that the dll si gonna be used in anothe computer in vb6. The dll was made with a Com class, so there's no problem with the interoperability (technically is like that, isn't it ) The point is that i register my dll in my local machine (develop machine) an i create a new project in VB6, reference the dll an instances it with no problem. I run the project an works perfectly. When i pass my dll to the machine with the VB6 application where is gonna be used, i register it and reference it in the project, i can see all the methods in it, but when I run the program, it gives me an "Automation Error" . the instruction that I'm using to register my dll ...Show All

• .NET Development SN.EXE | Strong Names ?

  me have read few articles that use SN.EXE to generate a keypair and use in .Net program. <Assembly: AssemblyKeyFile("..\..\MySNFile.snk")> but me not understand how it work and what the purpose/benefit with making my program "Strong Name" can anyone explain to me thankyou thanks for your answer and information. what the FullTrust and AllowPartiallyTrustedCallers mean thanks again ...Show All

• Visual Studio Team System Build Fails with errors: TF30063: You are not authorized to access Microsoft-IIS/6.0

  I am trying to make build with Team Foundation Build Service, but receive a lot of errors, which occure during " getting sources " build step: TF30063: You are not authorized to access Microsoft-IIS/6.0 . Somehow source files are successfully received, but not built, because of build system doesn't want to proceed with mentioned errors. I was looking for problem description on this forum and found a similar topic " TF30063: You are not authorized to access Microsoft-IIS/6.0. " (https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=105035&SiteID=1). Seems that this problem was solved, but there is no answer how to fix it. Could you please help me to fix this problem Team Build Services is running und ...Show All

• SQL Server How to make a DB to update its own Table colums

  Is there any way to update a table columns automatically. For example: We have a table( tblFirm ) which columns are: FirmName,IsOpen And another table( tblTime) which stores time information: OpenTime,CloseTime What i want to do ; between the time intervals of  OpenTime&CloseTime , DB will automatically set IsOpen 's value to true , otherwise false . Is there anyway to do this Happy Coding... I agree partially with  Gurpreet Singh Gill. But it wont automatically set false when the current time elapsed with CloseTime. The best solution is, 1. Create a function which will find the Firm is Open or Close from the TBLTIME table. Create Function dbo.IsOpen(@CurrentDate datet ...Show All

• Windows Forms Forms size

  How do I control the size of all of my forms I would like to set them so they are all the same size. How do I acomplish this thank you Hi Since you want to have a uniform size across use the concept of Visual Inheritance, where you inherit from a base form. Thanks, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3D presentation

  Hi guys, I really want to waw my client and write a window display for a real estate shop using C# and managed DirectX 3D. It will be a presentation running accross 4 screens. I have a basic amount of experience working with meshes and textures, etc (I made a 3D space shooter around a year ago). But, I'm lacking ideas really of how to present pictures and info about apartments and houses... Could anybody possibly inspire me Thanks! Haha, well that was certinately interesteding to read, but perhaps not what I had in mind. ...Show All

• Software Development for Windows Vista it Test Case 1 - embedded manifests and MSIs

  I am able to embed a manifest into my executable with mt & a custom action, but it does not work when I put it in an installer. I can verify that the manifest is being embedded into the executable that I am building but when I create an msi, using a standard setup project, and install it, the executable no longer has the manifest. Do I need to run mt on the .msi Is the execuable being placed in the .msi before the post build events Or is there just something wrong with my setup project Check the following thread to see if it helps: "How to add manifest file which verifies UAC in Vista in my setup bootstrapper or setup.exe file" http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=11 ...Show All