penninha's Q&A profile

• Microsoft ISV Community Center Forums Output Parameter in Excel VBA

  Hi, I am using Sybase Database. There is a stored proc having an output parameter. I need to write a macro to execute the proc and retrieve the output value. I know how to create a connection, but I dont know how to execute the proc. Kindly help Subhojeet You ned to use the AxtiveX Data Object(ADO) model. Use the Command object which allows you to use the 'execute' method after passing items to the 'paramters' field. See the Code Librarian on the Office Developers edition for plenty code example. Come back if you don't have access. Robert, Edinburgh ...Show All

• SQL Server Microsoft.SqlServer.Dts.Runtime ASP.NET Security Issue

  I am struggling in calling an SSIS package programatically using the Microsoft.SqlServer.Dts.Runtime namespace. I am succesfuly connecting to the package insofar as I am able to retrieve the package ID (GUID), but when I call package.Execute I get a 'login failed for user' error, which indicates a security problem. My ASP.NET app is running as a domain user which has temporary 'SA' rights on the server where the package is hosted. In addition, I have set the protection level on the package to 'DontSaveSensitive'. What am I missing to be able to execute the package remotely TIA, Rick This depends on how you deployed your packages -- I've encountere this problem a few times myself. If you've deploy ...Show All

• SQL Server Developer Edition Remote connection and related issues

  Hi All, I think I'm trying to do something I shouldn't but want to verify. I've got Visual Studio Pro 2005 Academic Edition with SQL Server Developer Edition. I loaded SS on my Windows Server 2003 PC server but am not able to connect remotely. I received help on another forum about how to connect the DevEdn but it doesn't read right. It appears that to do so, well, it even says, is a security risk. It just seems to me like Developer Edition was not made for remote connection. Is that true For any of you VB.NET/C# developers, is it hard to migrate a solution from a local solution to a network solution. That's what I'd do if I had to upgrade from a local version of SQL Server to a server PC based version of SS2K5. What is the ...Show All

• Visual Basic IDE, compiling, copy and paste, debug are all slow

  Any tips on what is making the project so slow. I have about 5 report server projects, and about 3 other projects. One for My Generation and another Base Class project with one form. My machine is a 2.0 Intel with 1 gig of ram. Some times hitting enter causes a huge delay or selecting a chunk of code (10 - 20 lines) and doing a ctrl-c causes a huge lag and then again when I do a paste. Trying to debug by step thru no longer lets me do edit and continue. I get the error "Cannot currently modify this text in the editor. It is read only" Compiling a 6 meg project after simple changes takes a minute or two to come up. Is it a sourcesafe issue References Mcafee Anti virus Thanks, Phil ...Show All

• Visual Studio Team System Schema Compare Problem #6

  I just did a schema compare where the source is a database and the target is my project. There should have been one difference detected (in a stored proc that needed to be updated in my project). However, the schema compare did not detect this difference. After a bit of snooping I think I've discovered the following: When a schema compare is done and the target is a project, the compare does not compare the actual source files in the project but uses the design time database. In theory, the design time database should match exactly the source files in the project. However, somehow, in my case, this isn't true. I have a stored proc in my project that is older than the version in the design time database. My questions are this. ...Show All

• SQL Server Flat File With Fixed Length Header and No Delimeter

  Hi, I'm trying to extract data from a Flat File which is as fixed length as they come. The file has a header, which simply contains the number of records in the file, followed by the records, with no header delimeter (No CR/LF, nothing). For example a file would look like the following: 00000003Name1Address1Name2Address2Name3Address3 So this has 3 records (indicated by the first 8 characters), each consisting of a Name and Address. I can't see a way to extract the data using a flat file connection, unless we add a delimeter for the header (not possible at this stage). Am I wrong Any suggestions on possible solution would be much appreciated - I'm thinking Ill have to write a script to parse the fil ...Show All

• Software Development for Windows Vista Can't stop or start service from client app ("access is denied")

  Hi, Quick question for all you Vista gurus out there. We have a service (running as SYSTEM) and we need to be able to stop and start it from our client application, which is running as a standard user. Is this possible Our app was designed originally to run as administrator, but in order to get Vista certification we can't have it demand administrator access ( ) so I'm trying to get it to run with the "asInvoker" access instead. But when I do that it can't access the service via the ServiceController. When we call serviceController.Stop() we get "InvalidOperationException: cannot open service on computer '.' --> Win32Exception: access is denied". The "Stop()" method is calling the "GetServiceHand ...Show All

• Windows Forms SplitContainer Panel MinSize Defect?

  I have a vertical split SplitContainer inside the top panel of a horizontal split SplitContainer and am trying to set the panel2 min size for it. I'm getting the following designer error: SplitterDistance must be between Panel1MinSize and Width - Panel2MinSize. This is somewhat confusing first of all, since the change was made in the designer. In the first instance therefore, I'm assuming this is a bug in the designer. The logic of the error message is that SplitterDistance should be between 0 and 560 minus 243 i.e. 317 which at 311 it is. Has anyone else come across this or have a workaround // // splitContainer2 // this .splitContainer2.Dock = System.Windows.Forms. DockStyle .Fill; this .splitC ...Show All

• SQL Server how do I get the value of a DEFAULT

  Hi We have a default defined in our database CREATE DEFAULT [ schema_name . ] default _name AS constant_expression [ ; ] How can I ge the value of the constant using SQL Also - anyone know why this is going to be removed from a future version of SQL - we use it for partitioning with replicated clients (long story) - but every table has one column which is bound to this default. We find it *very* handy. Ta Bruce SELECT d .* FROM sys.default_constraints as d JOIN sys.objects as o ON o . object_id = d . parent_object_id JOIN sys.columns as c ON c . object_id = o . object_id AND c . column_id = d . parent_column_id JOIN sys.schemas as s ON s . ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mesh and alpha blending.

  Hi, I am a new user of DirectX and have now been faced with the problem of drawing my semi transparent mesh triangles from back to front in order to obtain correct alpha blending. I use the drawprimitives command when drawing the triangles in the various meshes I have. Does anyone have some useful hints on how to draw the triangles correcly when operating with triangles in meshes ...Show All

• Visual Basic Coding Listbox Puzzle

  I want to display a list of employees (by employee number) that have performance results >90 in certain jobs. some employees may appear more than once on the list. I need a good solution that will indicate who is the top performer - who appears most. I'm thinking about using a list box and add emp# to the list - how do I figure out which emp # appears most on the list I didn't want to use a database.... any ideas, codes on using a listbox There are over 30,000 emp #. Job transactions may be in the millions. Thanks. well you could but maybe inefficient. from what I understand, you want people returned who have a criteria of a perf result of > valueX. This is achieved using th ...Show All

• SQL Server Error message "Interface not registered"

  Hi  I got the following error message when I make a new integration service project  Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered". Can someone help Me Hi, I have the exact same problem but it is when I try to burn a cd using Win Media Player 10. I tried registering the .dll's, but since I don't have the SQL 2005 installed in my machine, the regsvr32 msxml6.dll gives me the same error message. I see that this forum is mainly for SQL but if anybody knows what I can do, it would be appreciated. Thanks, Jason ...Show All

• Visual Studio Express Editions Limitations of Visual C++ Express Edition

  I have created a very simple C++ hello world program, and it seems that VC++ EE will compile the program, but it's not able to create a .exe that I can execute from the command line. Is it correct that VC++ EE cannot create .exe files and that you have to buy something from Microsoft in order to be able to create them woodland30033 wrote: Dennis, thanks for your reply, but I have created a simple Hello World program that does not use "stdafx.h" or the pre-compiled header and when I take the .exe to another Windows box, it does not work. Pre-compiled headers should not have anything to do with it, although you should use a project that doesn't have them. I suspect that the projec ...Show All

• Windows Forms How to get a enumeration of all textbox or other input fields

  I want to disable or make all input field read at runtime... What is the best way THANKS Peter foreach ( Control c in controlcol) {        if (c is TextBox )        {          (( TextBox )c).ReadOnly = !enable;          (( TextBox )c).ForeColor = System . Drawing . SystemColors . WindowText;       else            c.Enabled = enable; } ...Show All

• Visual Studio Team System High Execution Times ASP.net

  Hi, I am performaing a load test on one asp.net application. In the results I see the execution time counter of ASP.NET to be very high(100 sec) . When I check the sql profiler, there was nothing wrong. Also the request wait times were also high. Other observations, The CPU's of web server and sql are not the bottlenecks. What could be the reason of having high execution times Thanks. When I ran the webtest, the response time of one page is near 9 sec and the sum of response times of all pages in the webtest is 15 seconds. ...Show All