YMaod's Q&A profile

• SQL Server DBCC MemoryStatus dump and help 'Insufficient memory'

  Hey guys. Today morning at about 9:58am I had an insufficient memory exception in SQL. I've reserved 12gb memory for my SQL server. I've pasted below the dbcc MemoryStatus dump gotten from SQL log. It also gave me a BPool::Map: No remappable address found My SQL Server version is 8.00.2148. Enterprise Ed. Can you see any problems in the below pasted log 2006-08-09 09:58:11.63 spid175 BPool::Map: no remappable address found. 2006-08-09 09:58:11.69 spid101 Buffer Distribution: Stolen=156843 Free=1634 Procedures=17623 Inram=0 Dirty=108669 Kept=0 I/O=0, Latched=1220, Other=1286875 2006-08-09 09:58:11.69 spid101 Buffer Counts: Commited=1572864 Target=1572864 Hashed=1396751 InternalReservation=510 ExternalReservation=130 Min Free=15 ...Show All

• Visual Studio Express Editions error connecting to database

  I am using VC# Express and trying to connect to a SQL 2000 database. The error message when I compile the application is as follows: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Is there anyway to connect to SQL 2000 with VC# Express or is this a waste of my time. using System; using System.Data; //ADO.NET namespace using System.Data.SqlClient; //Use SQL Server data provider namespace using System.Collections.Generic; using System.Text; namespace Da ...Show All

• Windows Forms INI files

  Hey, I searched MSDN for this but I could not find anything on it... How do you have the program recongnize a .ini file I have called it load.ini and this is what it is inside of it: [firstload] firsttime = 1 I am trying to make it so that in the Private Sub Form_Load it will look for the ini file and read it, is firsttime = 1 then it is going to open up a dialog, otherwise it will do nothing, I can do all of that, I just need to know how to have it find the ini file... I placed the ini file in the project's folder... Thanks :) you are better of storing such configuration in an xml file - xml is pretty much a replacement of ini configuration files, and is much better to navigate/find the n ...Show All

• SQL Server FYI: Using Try's with Finally

  Within my script component I was having some difficulty getting nested Exceptions to bubble out of the script component logic. The symptom appears when you get an ex.message of "Object reference not set to an instance of an object." As soon as I removed the Finally section my message (or the actual Exception object) was properly passed to the caller. I've only done minimal work with Try/Catch/Finally structures. Is this normal Thanks, Jeff Tolman E&M Electric Hey Jason, No, I'm always passing on the exception. The problem comes when there is a Finally section after the Catch. The message that I throw up to the caller does not make it and shows up as the "Object reference no ...Show All

• .NET Development Uploading DIME attachments from client to server

  Hi, Just learning about web services so I'm kind of a newbie. All of the expamples using DIME I have seen so far (both online and in a book) have been examples of downloading attachments from server to client. Can anyone point me to a good code example of using DIME to send attachments from client to server Thanks in advance for your help. -Mark Use this code ws.MyWS myWS = new ws.MyWS(); System.IO.MemoryStream ms = new System.IO.MemoryStream(); Microsoft.Web.Services2.Dime.DimeAttachment dm = new Microsoft.Web.Services2.Dime.DimeAttachment("image/jpeg",Microsoft.Web.Services2.Dime.TypeFormat.MediaType,ms); myWS .RequestSoapContext.Attachments.Add(dm); myWS .UploadFile(key, filename);   ...Show All

• Visual Studio Express Editions Using variabl as variabl to get text as variabl

  I want to do this. Get the symbol from var1but , I don't have 1 at var. symbol is to equal what is shown on text1 I have letter text2=symbol Well its hard to write down. I have string that has the variabl i need. Like say its posable as so. Sub func( ByVal var As String ) Dim text As String = var.Text Dim symbol As String = a & 1.Text End Sub Looks like you should be able to change all the 'if' stuff and letters to: My .Computer.Audio.Play(folder & sound & ".wav" , AudioPlayMode.Background) ...Show All

• Visual C++ What is SET and how is it used on COM in VC++ environment.

  Hi All. I am working on creating COM DLL's on VC++. I want to know what is a SET,why is it used and how is it used in COM. Can any one guide me. Thanks in Advance If you are aware of the use of other STL containers then, the use of "set" no difficult at all. You may want to take a look at this article http://cplus.about.com/od/stltutorial/l/aa120103b.htm However if you are not familiar with STL containers you'll have to read a fundamental tutorial on STL which you'll find here: http://www.codeproject.com/vcpp/stl/stlintroduction.asp ...Show All

• Software Development for Windows Vista UI Automation events

  hi, Is UI Automation possible for any application .. I tried the delegates based on patterns & events on IE 6.0 xp . SP2 .. It more or less works .. But when i tried on Outlook Express with same delegates .. Many delegates doesn't response .. Selection Pattern , ToggleSatepatterns etc... Plz let me know issue .. sorry for my english.. Thanks & Regards sachin K. You should find UISpy.exe in the \bin folder of your SDK installation. Documentation is under .NET Framework Development / Tools / Development Tools. The FocusChanged event is global because it is a system event. Individual UI elements do not raise this event.  UI Automation support for Excel is, unfortunately, limited at present. ...Show All

• SQL Server SQL Server Management Studio Express - cannot find SQLEditors.DLL

  In SSMS Express, after right-clicking on a table and then clicking on "Open Table" or "Modify", this error was displayed: " The system cannot find the file specified Microsoft.SqlServer.Express.SQLEditors" . This file does exist and is in the same directory as SSMSEE.EXE (C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE). Other context menu items "Script table as" and "Properties" work fine. I did not try the other context menu items. Is this something that is fixable Version Numbers: Microsoft SQL Server Management Studio Express 9.00.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 ...Show All

• .NET Development Return XML Document using a DataSet?

  I have a question about returning an XmlDocument using a Dataset. I seem to be having problems converting it. For eg: public XmlDocument displayXml() { // coding for the DB connection DataSet ds = new DataSet(); ds = generateDataSet(); // another function that returns a dataset; //returns ds after my required process XmlDocument xd = new XmlDocument(); return xd.LoadXml(ds.GetXml()); } This code returns an error: Cannot implicitly convert type 'void' to System.Xml.XmlDocument Please let me know as to where I am going wrong and also if there is a better way to do it You might like to modify last line of your code and return xd instead. XmlDocum ...Show All

• SQL Server Script length limitation?

  Hi, The answer to my question may depend on both the sql server engine and the data provider; I do not know enough about the internal goings on to judge this. Thus, I should mention that we are connecting to SQL Server 2000, from an ASP.NET 1.1 application using the SqlClient provider. First a short introduction to my scenario: We have an application that needs to support exporting and importing data between different instances of the database (in a disconnected manner). This has been implemented in such a way that the export generates sql, which is then simply executed on the importing side. (It wasn't me! I'm fully aware of a number of reasons why this solution isn't any good, but this is what I have to work with.)  This is do ...Show All

• Software Development for Windows Vista Urgent WF Question - "Instance operation is not valid on workflow runtime thread"

  I really appreciate if you can help with this urgent question, it is really hindering my project progress. Basically, I am trying the change the Workflow when I get some Tracking Event while the WF is running. Basically I have a custom Tracking Service in the Send( TrackingRecord record) method I am trying to change the running instance but I get this error "Instance operation is not valid on workflow runtime thread"! Could please advice if there is any workaround to force the change of the running Workflow in response to a Tracking Event My scenario is that want to change the running WF in response to receiving UserTrackingRecord , any help is highly appreciated Note that I have tried  something like System.Threading.ThreadPool. ...Show All

• Visual Basic open a form with only systray icon

  Hello, how do i open a form so the form does not show and only an icon appears in systray I know how to make the icon but everytime I do this the form appears. I want to make the form only appear when I right click on the icon and say "appear". Thanks! Hi, I have the same problem that u have.Can you please tell me the procedure u followed. First of all my Problem is : I have only one form but im using sc_minimize if I set showintaskbar to false it wont work.But i dont want to display my application in takbar.I want to display in systray. Than you. ...Show All

• Visual Basic Is there a means of getting the SECTOR size of a Drive? I Need File STORAGE size

  As a little exercise as an old timer VB6 guy learning vb 2005, I am trying to create a program that will calculate the sum of the sizes of files in a directory. The fileinfo.length attribute returns the length of the DATA in a file. What I want (and imagine I will have to calculate) is the storage requirement. For example, the file sample.txt contains 96 bytes of data, however, I can observe the file properties with the file explorer and see that 4096 bytes have been allocated. That would tell me that file space is allocated in units of 4096. I cannot find anything in the disk properties via the file explorer that shows the 'Allocatable Disk Unit' (ADU) size So... what I am looking for is a means to retrieve the 'ADU' so that I c ...Show All

• Smart Device Development Windows Mobile 5.0 USB driver development

  For my master thesis, I need to develop software that controls a medical implant over a USB link. This USB link requires 1 control transfer (the standard one required by the USB standard) and bulk transfer. In order to do this I need to develop a USB driver to communicate with the implant. Up until now my experience developing for windows mobile: NUL, my experience for developing drivers: NUL. Ofcourse I've already done alot of reading, and on the msdn website I only find some information about developing a USB driver, and there it states I need the platform builder.. which is not free. After what I read about the platform builder, it just configures a whole new windows Mobile, but that's not really needed is it I have a certain PD ...Show All