anita punjabi's Q&A profile

• Visual C++ Does ODBC handle with RDO resultset?

  Hi, recently I'm writing some VC++ application in which it needs to read the RDO resultset by ODBC APIs. Briefly I go in this way: create a RDO resultset first, get its ODBC statement handle, bind columns by SQLBindCol, then read data using SQLFetch. But it seems to me not to work. MSDN really says it's ok to handle RDO resultset with ODBC, but there is no example for me to refer to. Could someone take a look at this to see where I'm wrong It's appreciated that an example is given. Thanks, Haojun I'm not surprised you have trouble finding RDO samples. RDO was supplanted by ADO about, oh, 10 years ago. The number of failure modes reading data with the native ODBC API is very high, I'd strongly ...Show All

• Visual C# Problem: The breakpoint will not currently be hit. No symbols have been loaded for this document

  Hi, I've run into a problem that seems to defy a solution. Bottom line: When I'm attempting to debug with VS 2005, I cannot set an effective breakpoint in one of the source files. The breakpoint is the hollowed-out reddish/yellow circle, and VS says that the breakpoint won't work because the symbols are not loaded. I've found several discussions in this forum about this type of problem, but there's no concensus that I could find on how to solve the problem. Some background might be in order. I have been developing a "data binder" for use in a forms UI application that has multiple threads. There are three projects/classes in the solution, one for a test mainline, using forms, one for a general-purpose "dump" routi ...Show All

• Visual Basic Binding to a text box or label on a web page

  In 2003 you could bind a text box or label to a DB and pick the actual field in the DB record to bind to.  In 2005 the GUI doesn't seen to provide this.  Instead under Data there's an Expressions field where you pick the bindable field (I choose Text), expression type (ConnectionStrings) but not sure what to enter for the Expression Properties.  Any help would be appreciative. Thanks Hi Dgates123, You would to use an Architecture in Three Tiers. In page's event load you put code to assign your TextBox's text property. Later, when you press any button, your page do will postback. In your button's click event you put code to write Textbox's text property in your database. Good Co ...Show All

• Visual C# install application in other PC

  Hi I have finished to write my application in C# . I am using a database with Microsoft SQL Server 2005 for my application. I have publish my software but now i want to have another copy of my application in other PC. Do i need to install SQL Server in the other PC as well When i do it do i need to change some setting in my code like ConnectionString What is the best way of install application in this case Thanks a lot for your help. I do appreciate that. Best Regard Ha as we install normal software, there is no need of install DBMS like oracle or sqlserver separate from the others component. So what is the best way of install a software with a database to different machine Thanks a lot for your help ...Show All

• Microsoft ISV Community Center Forums Accessing Visual FoxPro data using VBA (Excel)

  I am trying to query some records from a FoxPro database in Excel using VBA. I am able to grab all the data I want, based on my criteria, except for the dates. I cannot query by dates. Could you please educate me as to how to query records from a FoxPro database file by date/time in VBA Thanks in advance. MPG. Hi, Have you tried wrapping the dates in # symbols, for example, WHERE [StartDate] = #19/01/04#. Also sometime databases, even if the date is stored in the format dd/mm/yyyy, require the queries date to be in the format mm/dd/yyyy. If neither of these work then also try treating dates as a string and query like this [StartDate] = '19/01/04', that might work but it depends on how FoxPro stores dates. ...Show All

• Software Development for Windows Vista Can't install VS6 SP6 or VB6 SP6 on Vista RTM (6.0.6000)

  Hi, I can't install SP 6 for Visual Studio 6, either the VB6 cutdown version, or the complete VS6 version. I have Vista Ultimate version 6.0.6000. This problem exists even if I "Run as administrator". I already have UAC off, and the problem exists whether I use Compatibility options or not. The process to follow to reproduce this problem is: Double-click Setupsp6.exe Click 'Continue' Click 'I agree' [ Very short time-period follows] Message box: "Visual Studio 6.0 Service Pack 6 Setup was not completed successfully." Click 'OK' Setup then finishes. SP6 is not installed. I have about 100 applications I must maintain and recompile periodically. I now cannot do that. Does it mean I have ...Show All

• .NET Development What are the differences between .NET Framework 3.0 RC1 and CTP ?

  Hi, I've found that there are 2 version ( ie: RC1 [20060901] / CTP [20060922] ) of .NET Framework 3.0 Runtime in MS Web Site, but what are the differences between them ... Thanks, Best Regards, Hi, Snotek: Thanks for your kindly help. Since the RC1 is posted on 20060901, and CTP is posted on 20060922, so I've some confuse that which version that I should take for MOSS2007 B2TR installation. Best Regards, ...Show All

• Smart Device Development compact framework error

  Hi, I am newbie. i have use OpenNetCF file watcher on specific folder its work fine...........in emulator. but when I deploy that application to my mobile... it give me the error it requires newer version of the Microsoft .NET Compact Framework........... CF 2.0 i think.... but i have develop all my Stuff in the older version of CF 1.0........ is their any dll of OpenNetCF for the Compact Framework 2.0 before... CF=Microsoft CompactFrame 1. I want to implement the FolderWatcher ........ is their any Built in API apart from OpenNetCF or OpenNetCF dll that support CF1.0 2. All my previous work in done on CF-1.0 if I install CF-2.0 is this cause any problem..... on my previous work. 3. From where i install CF-2.0 in my Device ...Show All

• SQL Server Can't install SQL Server Express

  Hi all, I've been trying all day to install SQL Server Express edition on my development machine, I 've uninstalled other Express Editions that I have previously installed, at least none show in add/remove programs. When i try to run the setup program i get the message that i have incompatible programs still installed. I don't know what they would be. None are listed in the program list as I have said. I tried to run the uninstallbeta program on the SQL Server Express page, but I keep getting an error that the "framedyn.dll" cannot be found, reinstalling the application may help! lol ! Any idea's Thanks in advance. You can also check out my last post in http://forums.microso ...Show All

• Visual Studio 2008 (Pre-release) Help getting Console Server program to update ListBox (WPF)

  I have a Console program for a Chat Server using Asynchronous Sockets , trying to get it to Read a .INI, which contains a list of names. Than have those names broadcasted to a ListBox on the ClientSide.. I know this has to do with the System.IO functionality for reading the File, but not sure how to send what the StreamReader has read to the ListBox on the ClientSide. Here is a Section of code out of a larger block i'm currently working with dont think this is correct thou:: else if (messageReceived.StartsWith( "[RL]" )) { StreamReader sr = File .OpenText( @"C:\roomlist.ini" ); while (sr.Peek() != -1) { string allRooms = "[RL][" ; allRooms += "]" ; B ...Show All

• Windows Forms Multi Select List Box

  I know this should be simple but I am new to C# and a DBA by day please don't hold this against me . Here is my question: I have a multi select list box in a windows form and I can't figure out how to get all the Select values so I can update the database. I can see them in the debugger and can obtain the value that was selected first but can't get the additional values. Below is the code which I am using in the selectionChanged event for this list box. Any guidance would be greatly appreciated if ( this .lb_availableLevels.Items.Count > 0){ if ( this .lb_availableLevels.SelectedItems.Count != 0){ for ( int i = 1; i <= count; i++ ){ label2.Text = this .lb_availableLevels.SelectedValue.ToString(); ...Show All

• Windows Forms BackgroundWorker

  I am not sure how I need to procede. I am using BackgroundWorkers to handle some long running tasks. I have a button that allows the user to stop the form. The stop button disposes of the timer. I use cancelasync with the BackgroundWorker, but the RunWorkerCompleted still fires. I tried using BackgroundWorker.CancellationPending to prevent the RunWorkerCompleted code from firing and it doesn't register that the BackgroundWorker has been cancelled. Is it possible to solve this problem The RunWorkerCompleted will still fire. Just use e.Cancelled to determine whether the run was cancelled. ...Show All

• Visual C# Interfaces oversold???

  First, I must admit that I am a C# novice and so I probably don’t have as much knowledge and experience on the subject of interface as most of you guys reading this post. After reading a few books on C# and interface design, I still can’t see and understand the real power of interface unless of course, we are talking about interfaces as a powerful concept in OOP ‘only’ and not as a powerful concept in the general sense. When I was first learning OOP I was quite suspicious about the ‘excellent features’ that OOP claims to be able to deliver to the world and I was right. For example, in reality OOP offers very little if any, code reuse. I am now having the same suspicion about interfaces even though I see a lot nice words used to d ...Show All

• Visual Studio Team System Building project which referring dlls from other project

  We have Framework which is used in several our Team Projects. Framework is a Team Project itself When I generated build for one of the client Team projects (and build files obviously belong to the this client Team Projects) looks like the Build engine is not aware of those referenced Framework DLLs. It tries to look for them in the client project root folder, can't find it and obviously fails to compile. This build is automatically generated with no targets added or removed so i would expect that this minimal build script would work but not. Any suggestions how I can fix it Can build pickup files from different Team Projects Getting files from multiple Team Projects is not supported out of the ...Show All

• Visual Studio Team System Recommend One Test Container/Project for Entire Solution?

  Hi,   I wanted to get some opinions on this approach.   I have a website project solution with a number of base class projects.  MS recommends one test project to a project.  However, my question is what about having one test project for the entire solution that will have unit tests for all the base projects   This test project and solution will be used in a Team Build.   What are the pro's and cons of this approach   Regards,   Mike Hello Mike, Both solutions are acceptable and we actually use both of them in different internal teams here at Microsoft. I think that the "1 test project per solution" works better when y ...Show All