Omnicoder's Q&A profile

• SQL Server SQL Server Management Studio Express: Missing DataBases from VWD Project

  LOST DATA BASES I appear to be doing something stupid! I created a VWD express project that contains a database. In VWD the DB application works fine. I can see all my tables. VWD stores the DB in the applications area of MY DOCUMENTS in a project folder under “SQL SERVER Management Studio Express”. However, when I run the SQL Server Management Studio Express, I get a instance of the “(computer_name)SQL\express” that contains the System DB, but not the DB that I developed in VWD. After investigating I found the SQL DB for the Studio Express under MY COMPUTER, “Microsoft SQL Server” in a subfolder under "MSSQL" folder. Mi ...Show All

• SQL Server CTP June Dev.Edition:TCP/IP protocol is disabled at default

  I have tested Developer Edition CTP June but when I connect to remote SQL Server, " A connection was successfully established with the server, but then an error occurred during the pre-login handshake." error occured. I find out TCP/IP protocol is disabled at default at CTP June. When you meet with same situation, try enable TCP/IP protocol being enabled on "SQL Server Configration Manager" It's bug or by design Regards Hajime Gondo This is in fact by design. As part of only making available services that you need we are defaulting the Developer Edition to not listen on TCP/IP. -Euan ...Show All

• .NET Development Data adapter problem

  I have followed the EXACT instructions on using the queries generated when dragging tables onto a form and having VS2005 auto create all bindings and queries. I have also followed the exact instructions on updating a data adapter from the dataset that is holding (successfully I may add) using the generated "update" query. Even when following all of the instructions from the very first step I still cannot get the data to write to the actual sql table. I have used the databindingnavigator buttons, etc. I am about to give up. I am a very avid VB6 programmer and trying to learn VB2005. PLEASE HELP! I have tried for a week. Ever ...Show All

• Software Development for Windows Vista Bug? InvokeWorkFlow activity used with Sequential Workflow hosted in Console App

  I've been experimenting with InvokeWorkFlow activity and found what I think might be a bug with the logic in hosting code for the console app.  In the Main method, the WF runtime is instantiated and the started passing in the type for WorkFlow1.  Before it starts the workflow however it wires up a handler for the WorkflowCompleted event that when called sets a AutoResetEvent which the main thread uses to terminate the WF runtime and end the app.  So here's the problem.  I have a workflow that uses InvokeWorkflow activities to invoke 3 separate workflows that I want to run asynchronously.  However, after calling the ...Show All

• SQL Server Refresh the properties of as server

  I need to check if a server is running and then start the server if it is not running.  I am having trouble with the ServiceState never updating.  Ie... after I start the service I cannot check if its actually running using ServiceState. In the following example I start a server that is stopped wait 30 seconds and then display its ServiceState it is allways comming back as stopped even when I know the service is running.  If I make a new service object and set it to the server the server state property will correctly return running.  I am baffled by this any ideas on this   Dim myComp As New Managed ...Show All

• Visual Basic Getting the machine name using VBA

  I am using VBA for Excel. I have a secondary spreadsheet that is opened at the workbook_open event of a primary spreadsheet.  This secondary spreadsheet is in a different location, dependent on whether I'm using my desktop machine or my laptop.  Currently, I have to adjust the secondary spreadsheet's pathway manually.  I want to do this automatically based on the machine name where the primary spreadsheet is being opened (or where Excel is currently running).  Is there a way to read the system information from the current machine, get the machine's name, and then determine which path to use Thanks. ...Show All

• SQL Server CTE Vs Temp Table in Yukon

  Hi All, I would like to know which gives better performance: CTE or Temporary Table Thanks, Suresh I wanted to add another information here. When I replaced Temporary Tables with CTE in my query, it took more execution time. For ex., the query using Temp Table took 1 min 5 secs. The query using CTE took 4 mins. The no. of records hold by temp table in my query is apprx. 44000. Why CTE is slower Suresh ...Show All

• SQL Server SMO licensing model.

  Hi, What's is the SMO licensing model For example, if I build an application which will use SMO to get database objects schema, shall the end user buy any license for that Assume that the end user already has SQL server's license. Thanks! Regards Frances Hi As far as I know, redistribution of the SMO runtimes are free. I'm building a little SMO based app (for C# experience) , and nobody sued me yet ...Show All

• Visual C++ int thisarray[19][14] in a class derived from cobject

  I'm using VC++ 6.0 sp6 and I'm trying to create a class:public CObject If I declare an int array it crashes the wiz created SDI program, am I forced to use MFC CArray or CList What causes this Thanks in adv.!! I think I see the problem, I was thinking [19][14] meant [0..19][0..14] and really it means 19 elements for [0..18] and 14 elements for [0..13] I was trying to initialize the array to all 0s and it looks as if that was killing the program, thanks. ...Show All

• Visual Studio Team System Slightly annoying source control issue.

  Let's say you have a website and a library in your solution, the website references the library, and the solution is under team system's source control.  Whenever someone builds the solution, the referenced library assembly is updated in the website's Bin directory.  The issue is that these files under the Bin directory are marked as pending checkins upon change.  Is there a way to have the website's Bin directory ignored completely This is an issue we're discussing with the VS team.  This happens with SourceSafe as well with TFS. After building the libraries and ending up with the pending adds for the binaries, und ...Show All

• SQL Server Column Sorting

  I want to be able to allow a user of a report to sort the records returnedc in a table control based on the column heading they select. ie say the report returns a list of properties as row headings then a list of cost categories as column headings with cost values as the data.  I want the user to be able to click on a column heading say a cost castegory of 'Cleaning' i then want the report to order the properties by 'Cleaning Value' Is that possoble cheers.... anyone... CTP - Community Technology Preview. It's a post-Beta release of the new Reporting Services 2005 due out this year. More inform ...Show All

• Visual C# Visual C# installation problems inside Visual Studio 2005

  Recently installed MS SQL Server 2005 on a brand new machine, it came with Visual Studio 2005. I checked all options I could see to install everything (nad have since tried to rerun setup a few times to check if there were any installation options overlooked). However it does not seem to have installed Visual C# support, when I try to open a C# project this is the error message received The application for project ........ filename.csproj is not installed Make sure the application for the project type (.csproj) is installed. I've seen a few posts for this error message in the forums and I've followed them all to the letter but witho ...Show All

• Visual Basic ListView flickering

  Hello all I have a listview that I am adding image thumbnails to from a directory on disk. Because the directory has several hundred image files, I am using the .Refresh() method to show the thumbnails being added real-time (otherwise the application will take several seconds before it displays all the thumbs at once, not what I want) but the problem is there is way too much flicker everytime the listview is refreshed. Any suggestions Thanks. NRF What version of .Net are you using If its .Net 2.0 you can use the BackgroundWorker Component to load and add the thumbnails to the listview, that way your ui t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Making Background for a 3D game

  Hello guys, I'm making a 3D game...well with a static CAMERA view...it would be in SPACE...and there's no movement on Z buffer, though its 3D. But I would like to ask you for some suggestions how I should implement background stuff into this. Well, presently I am doing it like: I create a mesh(QUAD) in 3ds max and implement it into game as a sprite and set its Z position so it is further than other objects. But the problem is that I would like to have it USER-changeable - I mean...User can toggle between FullScreen/ windowed and switch resolutions and some other Dx stuff - so there is the problem. I suppose, it would be better ...Show All

• Architecture Advantages of OOP ?

  Hello, Im a fun of OOP designs. I design my bussiness classes when I start a new project. Then maybe I will write mapper classes for bussiness classes to map DB tables or using an O/RM tool or an ODBMS . Think that this project is big one and it has long deadline. You will develop it 2 or 3 years. Requirements will be changed. To develop this project with OOP designs and n-Tier application design is good idea. But I am asking myself this question "Why am I choosing this long way ". I think the advantages of OOP are re-usable and flexible (when there is a new requirement). OOP makes less code behind user-interface. But I dont un ...Show All