Lowell2002's Q&A profile

• SQL Server Problem with SSIS Transaction...Transaction Scope

  Hi, I am having some problem with SSIS transaction. Eventhought I tried to imitate the concept that Jamie presented at http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservices.asp . My workflow is as followed ********************************* For Each ADO.Record in Oracle (transaction=not supported) If (Certain_Field_Value = 'A') Lookup Data in SQL DB with values from Oracle (transaction=not supported) DO Sequence A (Start a Transaction , transaction=required) INSERT/UPDATE some records in SQLDB(transaction=supported) Finish Sequence A ( transaction shoul ...Show All

• Visual Studio 2008 (Pre-release) Custom data source provider

  I have some data that comes through a Web Service and it is cached locally using the isolated storage. For me it seems like a good scenario for implementing a custom data source provider: look for the data in the cache, if the data is stale get it from the web service. My questions are: 1. How is the error mechanism working For example, if an exception is raised during the connection to the web service, how do I notify about this error I have thought that Error property will automatically have a reference to the exception raised during BeginQuery (something like asynchronous web service error mechanism). 2. How about asynchro ...Show All

• Windows Forms Extending MenuStrip and ToolStripMenuItem

  Greetings! I need to create MyMenuItem inheriting from ToolStripMenuItem, add a private variable to the class and a property with get&set accessors to return the value of the variable. Now I need to create a MyMenu class inheriting from MenuStrip so to make available to add MyMenuItem to MyMenu as menu items in design mode. May be the inheritance for MyMenuItem should be from some other class, but I hope you get the idea. How this can be implemented Thanks, truetype If you need to add one propery, use Tag property that each control has, and may hold any item you need, anyway, just override the To ...Show All

• Windows Forms Basic DataGrid Question Where do I start here?

  I manually put a datagrid in on a form.  I then added this code to an event to populate it: OdbcConnection conn = new OdbcConnection("DSN=CardBase"); sqlCardHolders = "SELECT * FROM tblcardholders " + "WHERE last_name LIKE '%" + txtLastName.Text + "%'"; DataSet rs = new DataSet(); conn.Open(); OdbcDataAdapter myOdbcAdapter = new OdbcDataAdapter(sqlCardHolders, conn); myOdbcAda ...Show All

• Visual Studio Team System Publishing a web-site after build

  Hi all I have a web project and when building the solution using Team Build I want the web-site to be published and then copied into the Binaries folder together with the rest. Any way of achieving this Thanks Kev Kev - checkout this post by anutthara http://blogs.msdn.com/anutthara/archive/2005/12/27/507525.aspx hope it helps. ...Show All

• SQL Server Deploy SQL Server 2005 Business Intelligence Metadata Samples Toolkit

  Today, I download SQL Server 2005 Business Intelligence Metadata Samples Toolkit from Microsoft download center, per readme.txt instructions, build the project, but there was an error as below: Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0 After then, I just build the project,but didn't deploy it, then I tr ...Show All

• Visual Studio Problems loading package

  While probing the DSL tools and figuring out how to use them I came accross an issue that I need to get resolved. The issue has to do with loading the package (and is something I most likely caused by using the same combination of CompanyName.ProjectName on all my samples). Problem is that when I try to debug my DSL the debugger prompts me with the message 'Package Load Failure'. Inside the message are some details regarding my packagename (CompanyName.ProjectName.Designer.MyPackage, CompanyName.ProjectName.Designer) and the GUID. The package names with different GUIDS pop up (as stated I used the same combination on multiple sample proje ...Show All

• Visual Studio Team System tfsbuild.exe.config AllowedTeamServer

  Hi, I'm having trouble executing a build from the command line or through TE on my build machine- which is also the TFS. I get the same error when I try each way TF42053: The build machine is not configured to build for server http://<servername>:8080/ . ... To change the team foundation server for the build machine update the AllowedTeamServer key in the config file for TFSbuildService.exe ... I don't see a config file for TFSBuildService anywhere but, I have tried to add this key to the Tfsbuild.exe.config file- the key did not exist when I looked at the file the first time. I did restart the build service after I added ...Show All

• Windows Forms add an empty line to combobox?

  hello, I have two questions. 1) When using Databinding with combobox, the application shows the first record automattically inside the combobox. I want it to show nothing until the user selects drop down tab. When user selects drop down they should be able to see the available choices. How do i do this 2) I have another combobox that I don't want to populate until the selection is made in the first combobox. so how do i keep the combobox2 visible and unpopulated until the selection is made in first combobox (Making a selection in first combobox gives me a value that i use for filtering purpose for second combobox) I am very new to C ...Show All

• Visual Basic Starting phase 2, need some advice

  Greetings, I am a relative beginner with programming (took a class six years ago, don’t remember much), and I am delving into a “file managing” program for my family’s business. Today I finished phase 1 (of 3). Before I get started on phase 2, I could use some advice. In our business, we receive files (from our clients), each in their own distinct folder, uploaded to our FTP server, located in our office. Each client has their own (password protected) space on the server, and they could upload most any time of the day or night. Phase 2 of my programming venture is to have my software “sweep” each clients designated f ...Show All

• Visual Basic drawing lines on form

  Hi, jumping straight in from VB5. First pocket PC app. In old VB, it was possible to draw lines/shapes onto form as objects. now line/circle/etc on toolbox is not there Or do I need to code the drawing of these objects Thanks Simplefi Those controls don't exsist anymore, but look at LineControls sample found here http://www.gotdotnet.com/team/vb/   ...Show All

• .NET Development Grant File Access To Another User

  I would like to know how to grant, to a specific user, access to a specific file. My application user would be an administrator on the machine where the file is located. The user I want to grant access to the file is also a user on the machine. How can I do this in C# (.NET 1.1) Thank you Thank you for your reply. I think that your solution is only available in .NET 2.0 as I cannot find it in .NET 1.1 regards -dominic ...Show All

• Software Development for Windows Vista DirectX.AudioVideoPlayBack Volume problem

  Sorry am new to this and couldn't find anywhere else to post this! I have been writing an audio player program in C# and keep coming up with a problem everytime i try to change the Volume. It plays fine otherwise. the error comes up with DirectxException "Error in the Application", like i said i'm new to all of this so it might be something very easy, but i am pulling out my hair! Thanks for your help Dyl. Thanks Douglas, I will check out IBasicAudio. Dylan ...Show All

• Visual Studio Team System Error 401 when accessing project portal

  Ok so I finally got TFS installed ok. I can create projects, etc. no problem. Only issue I am having now is that with the default web site set to Integrated security, I get an Error 401 when attempting to access the project portal sites. It only seems to work when the site is set to basic, but I don't want to have to login everytime to access the portal. We have ISA 2004 proxy internally. I read that NTLM won't work Is there a way to fix this so that Integrated will work Follow up info: Found information that indicated sharepoint needed to be set for NTLM with adsutil: cscript adsutil.vbs set w3svc/xx/NTAu ...Show All

• SQL Server an insert

  Hello, I need to realize an insert something like the following: Exec GetMyID @tName, @MyId OUTPUT INSERT INTO MyTable2 (MyId,MyName) SELECT @MyId,MyName FROM MyTable1 Here I am getting MyID from a stored procedure and I need to insert this to MyTable2, however I need to get a new MyID for each row in MyTable1. How can I do that you could write a view which uses a cursor to step through all the names and inserts the names and the result of that proc into a table, and then insert that. What does the proc do Where does the ID come from that you need to use the proc ...Show All