ramk's Q&A profile
SQL Server Table Variables in Stored Procedure
I am using a table variable inside a stored procedure that I am trying to execute from an OLE Datasource task in IS. I know there was a problem doing this in DTS, which would result in an Invalid Pointer error. I am not getting that error, but I am getting an error that says "[OLE DB Source [55]] Error: A rowset based on the SQL command was not returned by the OLE DB provider." The stored procedure runs fine on it's own. Any thoughts No answers for you, but I'm experiencing the same issue. Stored proc returns a recordset from a table variable and works fine on its own. When ...Show All
Smart Device Development How to add my customized device emulator in Device Emulator Manager?
It's a great feature that device emulator support synchronizing with ActiveSync, however, this feature is only supported in Device Emulator Manager. I cannot cradle/uncradle any customized device emulator because it is not listed in Device Emulator Manager. Is there any approach for me to add my device emulator in the Device Emulator Manager so it can synchronize with ActiveSync The list of emulators that the manager shows comes from two places: 1) From the list of running emulators on your machine. 2) From Visual Studio's ConMan. You can add new emulator instances to the list from V ...Show All
Visual Basic PictureBox
I draw some objects (such as line,rectangle,text,...) with methods drawline,drawrectangle,drawstring,... (graphics namespace) on a picture box. but these objects are clearing when the picturebox moves out of screen and enter to screen or the form minimizes and the restore. i sove this problem with .AutoDraw=True in VB6 but i dont know how can i fix problem in VB.NET2005 You should handle the OnPaint event and draw your lines direct onto the screen, otherwise you could draw them on a bitmap and pass that to the picture control. ...Show All
Visual Studio Team System error "attempting to perform the undo operation" when using relative paths
We are studying how to put our current code into Team Foundation Server source control, but face a problem with each C++ project. The problem is related to the fact that a solution contains source files that are 'higher' in the directory tree than the project file. So, say thay the project file is this: C:\WS\Projects\CPPProjectForTFSBug\CPPProjectForTFSBug\CPPProjectForTFSBug.vcproj The problem occurs if it contains this file: ..\..\..\Components\CPPProject2.cpp which is absolute: c:\WS\Components\Component1.cpp Then, this bizar error message occurs: On the screen: Error 1 error(s) encountered attempting to pe ...Show All
Visual Studio Express Editions Code Request
Is there a code to send information that is typed into a text box by the user to your email thanks http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=227937&SiteID=1 ...Show All
SQL Server Cannot Load SQLSpars.dll
Hello, I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one: Setup Failed: Could not load SQLSpars.dll Why would this happen I see this message after beginning the SQL Server 2005 Standard setup and making my installation selections and beginning the install. The process stops after about 30 seconds, and displays the above message. My machine is running Windows XP SP2. Any ideas Thank you, Jon500 A few customers have reported this issue but we haven't tracked down the bug or a workaround ...Show All
.NET Development Unwanted promotion using TransactionScope
Hi, I wanted to test System.Transaction and using TransactionScope. So I wrote a little factory class which has very basic CRUD functionality. One of it's methods is CreateName: public static Name CreateName( string nameValue) { using ( SqlConnection connection = new SqlConnection( Properties. Settings .Default.TestDB)) { return CreateName(nameValue, connection); } } private static Name CreateName( string nameValue, SqlConnection connection) { Name name = new Name (nameValue); ...Show All
SQL Server Basic authentication.
The documentation for Analysis Services seems to suggest that windows authentication is no longer the only way of accessing AS. I'm trying to confirm whether or not it is possible to login to AS with basic authentication. If so, what are the constraints (eg is this possible only via IIS). I'd also like to find out if http access is restricted to enterprise edition only like it was in AS2000, or has the scope been widened in AS2005. Thanks, Terry. Yes, http/https connectivity will be available in AS2005 standard edition. Adrian Dumitrascu. ...Show All
Windows Forms How to get the textbox value of other form
With VB 6 there was no problem getting a value of the control on other form. Now I failed to do it. I think the following simple code should work but VB.NET won't get me the value. I have a textbox1 on a form FrmA and I need the value of the textbox1 to use as a parameter of a query on a form FrmB. When the FrmB loads ...Show All
Visual C++ CRect is weirdly designed...
CRect rect (1, 1, 4, 4); (1,1) being the (x,y) starting position of the rectangle (4,4) being its ending position. Quiz : what will return rect.Width() and rect.Height() 4 you bet No, it's 3 !!! How come a so simple object can be so weirdly designed Thanks Ronald. The link shows anyway that this continuous approach of a rectangle brings some confusion among graphics programmers ; but, at least, it can be legitimated thanks to contiunous mathematics... 0 1 2 3 4 5 |---| ---|---|--- |---|--- In a discrete wor ...Show All
Visual Studio 2008 (Pre-release) Deriving from a window
Hi All, How can derive a new window from an existing window in wpf. I have tried code like the following: < Mapping XmlNamespace="local" ClrNamespace="Ui" Assembly="Ui" > < local:BaseWnd x:Class ="Ui.DerivedWindow" xmlns ="http://schemas.microsoft.com/winfx/avalon/2005" xmlns:x ="http://schemas.microsoft.com/winfx/xaml/2005" xmlns:local ="local" > </ local:BaseWnd > It just gives me an error stating that BaseWnd is an unknown tag in local. Of course I derived DerivedWindow from BaseWnd in the source file. ...Show All
Software Development for Windows Vista WINDOWS VISTA connection BUGS...
Vista "SUCKS" i can't connect to the internet... I reinstalled Vista 2ice and no dice... The fist time i downgraged windows back to media center and worked like a charm then Vista on top.. again... NO Dice dowgraded to windows pro and connection works like a charm again. back do vista then i entered all ips manually no luck... i didnt fell like reinstalling windows again so i went into linux in order to go on the internet and to find a solution... checked many forums on the net and MANY!!! people are havein this problem.. some fixed by entering manually the ip and dns, some reinstalled windows and it worked... plenty were screwed and none of ...Show All
.NET Development More Table Adapter problems.
I have run the Update method of my table adapter ( see previous posts ) and now a new error presents itself. The error states : Update requires a valid UpdateCommand when passed DataRow Collection with modified rows. I chose generat INSERT DELETE UPDATE methods when I created the dataset. Why am I getting this error This is the line of code (in red) that fails: public virtual int Update( CellcastBackEndDataSet . tblShiftDataTable dataTable) { return this .Adapter.Update(dataTable); } Thanks Thanks I have a similar problem, but my table has all the proerties set for all the comm ...Show All
Visual Studio 2008 (Pre-release) z-order in XAML?
Hi, is there any way to change Z-Order in XAML It would be really helpful as not removing and adding items in code Greetings I have a couple of images in a Listbox (bind from dataset) where i have swapped the regular itemspanelfor a wrapPanel instead. With the help of triggers I managed to change the zIndex for the image thats for examples is mouseover and the result is that the image in focus is on top of the others... < Style TargetType = " {x:Type ListBoxItem} " > < Style.Triggers > < Trigger Property = " IsMouseOver " Value = " True " > < Setter Property = " ...Show All
.NET Development Creating a temporary Directory
I want to create a random temporary folder in C#. Is there an easy way to do this using any.Net Library I don't want to use the FileSystemObject and I want to avoid implementing my own function. Do you have a sample code you can share Thanks! Arturo Thank you for your answer! GetRandomFileName will work. I am not sure how I missed that. This is the code that works like GetTempFileName, but instead creates a directory, public string GetTempDirectory() { string path = Path .GetRandomFileName(); Directory .CreateDirectory( Path .Combine( Path .GetTempPath(), path)); return path; ...Show All
