version2's Q&A profile

• SQL Server SQL Mobile query hangs PPC 2003 device

  I've written a query to pull data from a SQL Mobile database which seems to completely hang the device when I run it (I waited several minutes before warm-starting). Yes, it's a bit complex, but it works fine on the desktop version--completes pretty much instantly. Are there any limits to SQL Mobile that might prevent me from writing such a query There are not very many records in any of the tables (all are <20, except one which is ~2500). Here is the query: ------------------------------------code--------------------------- SELECT oi . ProductID , g . GenusName , Species . SpeciesName , f . FormName , f . Abbr , sz . Sizes ...Show All

• Visual C++ Can C++ develop web-based applications?

  Hi, All New to C++ programming. and have put resource in C++ and VC books and time learning it. But now I was told that C++ can not develop web based apllications. Is this true or some extensions of C++ can go around this limit I need develop a web-based database, so the users can input company names, location, phone numbers. etc. and the users can have a full text search on this database. Do I have to learn C# and and SQL to do this Thanks. You need to learn SQL no matter what. You can write web apps using VBscript and C++, that's call ASP. It really sucks. You should learn C# and ASP. ...Show All

• Visual Studio Team System Remote access to Team Foundation Work Item Tracking

  Hi, We have a TFS server in our corporate Intranet. We have to give access to external person to WI tracking, reports and Sharepoint portal of TFS. How do we go about it Is there any proxy setup to be done Or should it be given through DMZ/VPN - if so what can be connectivity issues in it Note: We don't want to give access to source control to external people. This is a very urgent requirement. Responses will be very helpful and highly appreciated. Thanks, Saurabh Hi, It seems that a VPN access is actually the only way to access WIT from extranet. Rob Caron is actually aking for ...Show All

• Windows Forms Get current line in a textbox

  I'm writing a C# windows form. How can I get the text on the current line Simply put, you cannot. The Windows Forms TextBox control just doesn't supply this information. You can get the information using Win32 API calls, however, by calling the SendMessage API function to get the current line and its contents, but it's going to be ug ...Show All

• Visual FoxPro DO FORM does not work in exec (for me)

  I have close to 50 clauses, it turns out, DO FORM in my application. They all work perfectly well in interactive mode with the browser but do not work at all in exec after I built it. By "do not work" I mean that I do not even get an error message. Those statements are completely ignored. What I've done so far is trying to find a formula under which I could call outside forms. As I mentioned, when a statement DO FORM <formName> is placed inside a method it does not work. I tried to place them in a prg file--the same negative effect. Or rather no effect. The next trick was to invoke a form in my startup (main) prg file a ...Show All

• SQL Server Create File Option In File Connection Manager

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the properties that you could want to change; often I need to change the same property in the same way each time (for example I'd like to set the Batch Size for a OLE DB destination to 1000 instead than 0 ...Show All

• Visual C# Anti-view source code

  Dear all, I'm using a software that can view source code from .exe and .dll file (only for .Net Framework support files). It's security problem. Everyone can know my programming idea. So, I wonder to know how to hide code! Someone help me! Thanhks! If doing that gives you a security problem, then you inherently have a security problem. If your app is only secure when people don't know what it's doing (as opposed to not knowing a private key of some sort) then your app isn't secure. Obfuscators can help to protect your code, but you really shouldn't be relying on "security through obscurity". Jon ...Show All

• Visual Basic What's the Difference between Visual Basic Express and Visual Basic 2005

  Are there more commands   Faster compiling   Faster code I read that Visual Studio 2005 also has a 64bit compiler... does that include Visual Basic 2005 I understand that VB wasn't going 64bit - but that's a shame because MS is pushing us to move to 64bit.  Well, we certainly need the compilers for it, don't we I think those are a list of features... but I take it that it might also offer some additional commands to support those features. Thanks. ...Show All

• Windows Forms How do I Logical AND two strings

  I'm trying to create a search engine that checks for wild chracters and I'm stuck in performing a logical AND operation. I'm first converting to two strings to two integers by using the int myFirstWord = int.Parse(string1) // I'm getting input string not in correct format exception// int mySecondWord = int.Parse(string2 then anding them together: int andResult = myFirstWord & mySecondWord; I already tried different ways of doing this to no avail. Does anyone out there knows how to I'm just guessing but it sounds like you want to do a text search on a numeric ID field. If this is true, you should creat ...Show All

• Visual Studio Team System VS2005 Can't Connect to Team Foundation Server (RC)

  We've setup tfs on a windows 2003 sp1 server. We also have another windows 2003 sp1 server on which we have visual studio and installed the tfs explorer. We are able to connect via VS2005 to tfs from that 2nd server with no problems. However, on two windows XP laptops, we are unable to connect to the tfs server. When you attempt to add the server, it hangs for a long time and then you get the generic error that tfs could not be contacted - TFS31002. No audits are recorded on either the tfs server's event log or on the laptops that indicate the reason for the problem. The laptops are otherwise able to access the windows 2003 serve ...Show All

• Visual Basic Stupid Question

  In VB 6 I could set all my database connections pretty easy at runtime so they would be in app.path "path". VS2005 is a little weirder...... SPAth = System.Windows.Forms.Application.StartupPath and it returns the debug folder.....no problem right When I install this will it be smart enough Database connections.....when made with the designer....are they ALSO smart enough to transform themseves with the installer so that the program dumps them into the App.Path directory or do I need to set them at run time Thanks Thanks for the help.........I figured this was going to suck! Great development platform............... ...Show All

• Visual Studio Problem with AppDomain in an VS2005 add-in.

  I'm developing a VS2005 plugin that would allow user to right-click on a project and choose "Synchronize with toolbox" to put all controls containing in that project to a toolbox. In order to do it, the plugin compiles the project, loads compiled assembly, iterates through all types in it and puts controls into a toolbox. It works fine, but at the end of this excersise the assembly gets loaded into VS2005 process space, which prevents the studio from building that project after that. The obvious solution to that problem is to create an AppDomain, do all the dirty work there and unload it. Here comes the problem - I get InvalidCastException w ...Show All

• SQL Server Report performance

  Real quick I have multiple reports that use the same headers say Topic 1 and Topic 2 The body of the reports will have 0-50 records and 2-15 columns. These reports will be run many times concurrently. My question is which is more efficent 1. Open connection Call sp to returns Topic 1 and Topic 2 for report header Close connection Open Connection Call sp to return the report body data 2. Open connection Call sp to return the report body data as well as 2 addition text fields of char(50) and use FIRST to extract headers Close connection For 2, you'd have the 2 add ...Show All

• SQL Server Disappering users

  Hello. I have an SQL 2000 OLAP (SP4) project with lots of dimensions, mesures, cubes, roles and users. Everything was fine for a year till yesterday. I've added a user (did it time to time before) to a role. As I process the cube the user was removed from the role. Now I can not add anyone. Am planning to remove everyone and add again. But also scared of adding nobody forever. Help. Thanks. I wonder if perhaps one or more of the users in some of the roles are no longer valid in the domain I would suggest making a backup of your database and then perhaps by removing the roles and re-adding the (valid) users you'll get back to a g ...Show All

• Software Development for Windows Vista State persistence in long running transactions

  Hi To All, In a long running transaction or human-centric workflow scenarios, Does WWF behave similar to BTS with respect to dyhydration and rehydration Specifically, i am looking for answer whether WWF persists its state into a SQL Server database. If so, does it depend entirely on SQL Server or will it be possible to configure and use any other DB for persistence If it is not so (by keeping the state within its process), Is this really scalable   Thanks, Ganesan Krishnamurthy. Yes, out of the box, WF comes with a sql persistence service, but you'll need to add it in code (WorkflowRuntime.AddService) o ...Show All