silkkeng's Q&A profile
Commerce Server CS 2007 Starter Site - stored procedure 'dbo.inv_CheckInventory' doesn't exist
Downloaded CS2007-StarterSite-En.exe and installed successfully. However, when I attempt to add a product to my cart, an unhandled exception occurs: Component Execution failed for component[0x2] hr: 0x80131509 ProgID: Commerce.CheckInventory The stored procedure 'dbo.inv_CheckInventory' doesn't exist. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Component Execution failed for component[0x2] hr: 0x80131509 ProgID: Commerce.CheckInventory The stored procedure 'dbo.inv_CheckInventory' doesn't exist. Source Error: Line 152: ...Show All
SQL Server SQL EXPRESS TIMEOUT
The default is sest to 15 seconds that of course is no good because it takes more than that to attact the damm database though is very small. Does any one know how to modify the connection timeout I'd try including it on the Connection String but no luck. it looks like it detaches the database after a period of inactivity. If anyone knows anything about please let me know THANKS See the problem does not occurr at the ADO nor the queries i run. It acctually happens before any code I wrote runs, it happens at LOGIN. I use the Login controll from VisualStudio 2005, this control sets it self and there are no properties as far as connections The only connection property can ser prior running any code ...Show All
SQL Server SS 2005 Management Studio Installation
I have installed the Standard Edition of SQL Server 2005 and am using with VS 2005. The Management Studio module apparently did not install; it is unavailable from Start>All Programs>SQL Server 2005. I also do not find it in my directory tree at Program Files>Microsoft SQL Server>90>Tools>Binn>VSShell>Common7>IDE. I think I'm missing some step in the install process. Could use some guidance/help. i experience this one before. I installed the database engine and the sql server 2005 client tools but i wasn't able to see the sql server management studio. The only time i was able to run management studio was when i installed every component of sql server ...Show All
Visual Studio Team System Discrepancy when files are deleted
If I delete a folder than is the local path for a node under source control, it still shows up in the Source Control Explorer that the folder still exists and is the latest version. I even restart VS.NET 2005 and it still shows up in this way. How can I fix this discrepancy When you Get files into your local cache (local PC), the TFVC server keeps track of the files and versions that you have retrieved. If you physically remove the files from the local drive, TFVC doesn't know that they are gone. If you delete the files from Source Control Explorer and then do a check-in to commit the delete, the files are removed from TFVC and from your local drive. The important thing to remember about TFVC is that it wants to control the files ...Show All
Visual Studio Team System Question about Third Party binaries
What is the best way to incorporate our third party binaries into Team System In the past we used to have a "$\Binaries\ThirdParties" folder that all of our projects referenced from Source Safe. Is there a better way to do this in team systems Jonny, you can store binaries like in VSS and where you store your common binaries depends on your process. We store common binaries in a separate folder in source control like you suggest and reference it there. ...Show All
Windows Forms Windows Installer XML (Wix) Toolset
Anybody use Wix for setup and deployment I can't remove the COM+ object when I uninstall the application so that it fails to re-install the application when it checks that the COM+ object already exists. Anybody could show me how to deal with COM+ object using Wix There's a Wix mailing list at Sourceforge.net you could post this to, wix-users. http://sourceforge.net/mail/ group_id=105970 ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Where is the download?
It is 12:48 pm here (GMT + 1)... in Nuku'alofa (GMT + 13) it is tomorrow... So where the hell is my download link :-D It's just about 12:30 AM, my guess is you'll still have to wait several more hours, probably at least 8 and a half since the workday starts for most people in the US around 9 AM. Even then I don't expect to see it until later in the afternoon Pacific time. ...Show All
Visual Basic How to include a *.chm file in my publication?
Hi guys, How do I include the *.chm file in my application so that it can be published along with the other resource files I tried a lot but couldnt do it. I want to include my help.chm file which is in a directory to be included in my publication and after I publish and run setup, the help.chm file should be in a directory that I specify. how do i do that For that matter, how do you include any file into your publication and specify where it installs after setup I tried the ClickOnce method but couldnt get heads or tails of it. Really appreciate your help. Arun. I build my chm files from what looks like an html web. I use either html workshop or actually I prefer FAR to build the files. T ...Show All
Windows Live Developer Forums VEMap.AttachEvent("oncontextmenu", function) firing twice
I am trying to add a pushpin to the map by right clicking on it. I am using AttachEvent with oncontextmenu event. I notice the event fires twice for any function. Am i doing something wrong Here is the code sample. (the map is created as a response to a XHR request) var VEControls = Class.create(); VEControls.prototype = { initialize: function(){ var url = "/maps/defaultLatLong"; var opt = { // Use GET method: 'get', // Handle successful response onSuccess: function(req) { var latLong = req.responseText.parseJSON(); if(latLong){ map = new VEMap('mapHolder'); map.LoadMap(new VELatLong(latLong["lat"], latLong["long"]), 15 ,'r' ,false); map.AttachEvent("oncontextmenu" ...Show All
SQL Server MSSQL 2000 -> 2005 - Schema stuff?
Hi All, I imported a database backup with no problems. I can view the data using the Studio. However, I noticed that all the tables are now pre-appended with a Schema name. This also applies to Views. How do I get 'rid' of this as my application doesn't know about the Schema and claims that it can't find the Tables and Objects I'm referenceing in the web.config. Thanks, -Alon While schemas are new in SQL 2005, SQL 2000 had the same basic idea (at least as far as calling the objects). In SQL 2000 objects had owners, and these were prefixed infront of the table name. In most cases dbo was the owner. Take the application account that is logging into the database. Change it's default schema to the schema t ...Show All
Windows Forms VB.NET 2.0 - Splash screen closing event?
I have a built in splash screen, and I set a handler as such: If Not My .Application.SplashScreen Is Nothing Then AddHandler My .Application.SplashScreen.Deactivate, AddressOf SplashScreen1_Deactivate End If 'And here is the sub Private Sub SplashScreen1_Deactivate( ByVal sender As Object , ByVal e As System.EventArgs) MsgBox(Threading.Thread.CurrentThread.Name) End Sub This event fires, but fires in the splash screen thread, not the main program thread. How can I detect when the splash screen closes so I can run a sub to process stuff Thanks, Rick I would have thought that it would be better to use the Sub Main() and control t ...Show All
Windows Forms Webbrowser Help needed
This Script i found on msdn site is meant to update the url in the textbox u put a url in to i got it to work in visual basic but it won't work in c# and its the right code update: also the enter button when pressed is mean to take u to the url but dosen't work either. [code] // Navigates to the URL in the address box when // the ENTER key is pressed while the ToolStripTextBox has focus. private void txtURL_KeyDown( object sender, KeyEventArgs e) { if (e.KeyCode == Keys .Enter) { Navigate(txtURL.Text); } } // Navigates to the URL in the address box when // the Go button is clicked. private void cmdGo_Click( object sender, EventArgs e) { Navigate(txtURL.Text); ...Show All
SQL Server capture delta
how can I capture delta in SQL Server 2005 to refresh base tables in a data warehouse Well, you'll have to stage your data from run to run and then compare changes from your staged table and your source table using a variety of SSIS tasks. Or, you have an update flag in your source table that is set to yes everytime the data is updated/inserted. Then in SSIS, you can just pull those records where the update flag is set to yes. There are several ways to accomplish what you desire. ...Show All
Visual Studio How can I change a project item image in Solution Explorer?
How can I change a project item image in Solution Explorer in VS 8.0 AddIn For example for cpp item or h. thx Hi Sergey, Unfortunately, there is no way to do this from an addin. The icon image displayed by the Solution Explorer, is done through the project system's implementation of IVsHierarchy::GetProperty. In some instances the project system may defer to use the icon associated with the file type, but in other instances (such as the C++ project system) it may just use a static image from it's own resources. The only way to provide your own set of images for project items, would be to implement your own custom project type with the Visual Studio SDK. There are a number of samples in the SDK (such as Figs, MyC, Project, and t ...Show All
Visual Studio Team System Modifying VSConsoleOutput.xsl so that line numbers work in VS.NET
I run FxCop as part of my project build, and I like how the output can be turned into warnings in the Visual Studio.NET Error List window. The one thing that annoyed me was that even though most warnings have a line number, you couldn't double-click on the warning to jump to the offending line in the code. I discovered that if you edit the VSConsoleOutput.xsl file so that adds a column value, then Visual Studio can jump to the code ok. FxCop doesn't output a column value, so I just set it to "1". eg. edit the .xsl file and replace (<xsl:value-of select="@Line"/>) with (<xsl:value-of select="@Line"/>,1) Maybe that change could be made to the original .xsl file too. -dave ...Show All
