hchavali's Q&A profile

• SQL Server Migrating from SQL Server 2005 to SQL Server 2000

  I have to 2 database server, one is running in SQL Server 2005 and the other one is SQL Server 2000. Now, I want to transfer my database from SQL Server 2005 to SQL SERVER 2000 and gives error. Any solution Thanks Ronie What do you mean by "I want to transfer", how are you tring to accomplish that HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Creating an Expression to Modify a Date Field

  In my Derived Column Transformation Editor I have something like this: DAY([Schedule]) + MONTH([Schedule]) + YEAR([Schedule]) where [Schedule] is a database timestamp field from a OLEDB Datasource. I want to produce a string something like: "DD/MM/YYYY" using the expression above, I get something really wierd like "1905-07-21 00:00:00" Help much appreciated! I ended up with this. Thanks for the great help! RIGHT("0" + (DT_WSTR,2)DAY(Schedule),2) + "/" + RIGHT("0" + (DT_WSTR,2)MONTH(Schedule),2) + "/" + RIGHT("0" + (DT_WSTR,4)YEAR(Schedule),4) ...Show All

• Smart Device Development Exiting the application

  Hello, I have developed an application in C# for the Symbol MC1000 handheld scanner (pocket pc) but due to the fact that it uses certain memory resources of the handheld, the handheld crashes at some point stating that not enough memory is available. Thus I would like to release/close/exit or something else from my application after a certain number of scans, so as to release all of the resources that it was holding. The only way that I know is to warm boot the device which works fine. Teh problem is that because I use the application sometimes less and sometimes more before I warm boot the device, the application crashes at different scann numbers (e.g sometimes at 100 scans and others at 200). Any suggestions Regards, John. ...Show All

• .NET Development SoapHttpClientProtocol slower in .net framework 2.0 than .net framework1.1?

  I have update my web client from .net framework1.1 to .net framework2.0. When i call same service function from same server , i find the 2.0 client version is slower than 1.1 client version. I list the client test code here, it is very sample: public string wsDoTest(int nIn) { object[] results = this.Invoke("wsDoTest", new object[] { nIn}); return ((string)(results[0])); } I run this method 100 times. Both client and server are windowsXP(sp2), server uses Tomcat+axis(write in java), And result is: version1.1 client: about 2 seconds version2.0 client: about 20 seconds Why Can anyone give me some ideas It is possible that proxy is getting into the picture. Then the automatic dectection also could ...Show All

• Visual Studio Menu item in Debug menu?

  Hi, I've looked in all the ctc files of the inc folder but I cannot find the correct group id for the debug/window menu. Thanks for your help, Charles Hi "cverdon", You are correct that these are not defined in the current SDK, and this is, unfortunately, a bug. These files will be included in the November 2006 CTP of Visual Studio SDK V4 which will ship in about 1 month. In the meantime, if this is blocking you, please contact me via http://blogs.msdn.com/aaronmar and I'll see if it would be possible to privately ship you these files out of band. (It may not be though....I'll need to get approval from the right folks inside Microsoft). Thanks, Aaron Marten ...Show All

• .NET Development How do i use the Typed dataset i created?

  i created a new Typed dataset by these steps : 1. Added new item (XMLSchema) called XMlSchema1. 2. dragged a table to the xsd screen which created a dataset automatically. 3. called the dataset "ProductsDataSet" but how do i use it in the book i read i just write : ProductsDataSet pDataSet = new ProductsDataSet(); (SqlDataAdapter)sqlDAdapter).Fill(pDataSet.Products); but the compiler tells me that he can't find any 'ProductsDataSet', why Why can't he find it (the XmlSchema1.xsd is in the same namespace as the code i wrote). (In the book it is written to check the "GenerateDataSet" , i don't have that kind of property. typically the xsd file name is your DATSET name and the objects wi ...Show All

• Community Chat A Novel Approach to Exception Handling

  My question is related to C# and other .NET languages; it affects one important shortcoming of exception handling, which we have today. There is a problem connected with .NET exception handling strategy, it has an effect on the reliability of managed code. In one sentence, the question is: Why C# does not have any defense against The Side Effect of Unexpected Exceptions The phenomenon of implicit interruption of code flow (without an explicit throw statement) can take place when some of the lower layers throw unexpected exceptions and some of the upper layers handle such cases as normal. As a result, some data in the program may become inconsistent and further execution in such states may cause abnormal things. So, to termin ...Show All

• Visual FoxPro VFP Bug... Or is it a feature?

  Hi all; In a grid's AfterRowColChange I have the following: if CertainCondition this.AllowCellSelection = .T else this.AllowCellSelection = .F. endif This is basically to implement a 'when' for the record the user is in. I have noticed that in some cases the AfterRowColChange won't fire. I have used ReadOnly (Instead of AllowCellSelection) and it works fine. Aleniko Aleniko wrote: Don't want to sound like Monti Paython but... No it doesn't... But readonly works fine. I did not make this statement without testing it If this is not the case for you, comething else is going on. ...Show All

• Software Development for Windows Vista How to get(set) cursor position in my service before logon?

  Hello, I noticed that an interactive service cannot run in vista any more. This issue is good to security, but bad news for me using an interactive service. My service is simple and needs only 2 functions - one is getting cursor position and the other is setting cursor position. These 2 functions can be implemented through one other user application after user logon. But before user logon, how can I do this job Thank you in advance. Sweating Egg;; Hello SucceedEgg, Actually I think I misread your question, you are wanting to get the cursor position before the user has even logged in. Which means there is no user session. Let me look into this a bit further, this might ...Show All

• Visual Studio Express Editions Text replace with File IO of binary/text data

  Perhaps not the appropriate forum, but..... I have a need to replace text in a file with new text. The files may or may not be text files in the sense that there may not be "lines" and they may not contain printable characters. I tried the StreamReader and StreamWriter approach and the String.Replace method. It works well, except that not all the file contents gets preserved. Three bytes at the start of the file are omitted. These occur just before the CRLF characters. Can I read the file in a binary way and then use the equivalent to the String.Replace The input will no longer be a string I must say...I'm not pleased with being sent to newsgroups to ask these questions. The forum format for discourse has ...Show All

• Visual C# Edit a string?

  I would like to edit a string but I am having a little bit of trouble doing it. For example: string Mystring = "test\r\n"; I would like the string just to read "test". how can i cut the last 4 chars off Try String's Trim() method which will remove any leading or trailing whitespace characters. MyString = MyString.Trim(); ...Show All

• Commerce Server Failed to retrieve the AzMan Scope

  After adding some new catalogs and kategories i get an error that i presume relates to azmanager not knowing the permissions to the new catalogs. anyone got some ideers to how i correct this. I have added all relevant users to an active directory user group and added that usergroup to the catalog admin group in the azmanager. Event Type: Error Event Source: Commerce Server Web Services Event Category: None Event ID: 1 Date: 19-01-2007 Time: 10:15:09 User: N/A Computer: PS-COMDEV-PH Description: An exception occurred in the 'CatalogWebService' Web service. Exception details follow: Microsoft.CommerceServer.Catalog.Internal.ScopeDoesNotExistException: Failed to retrieve the AzMan Scope named CatalogScope_husholdning. ---> System.Run ...Show All

• Visual Studio Express Editions Installation Trouble

  I have a few problems while installing Visual Basic Express Normal Download I click download on the page, save it to my desktop, I run it but then it all disappears. It is still running but it isnt doing anything Manual Download I use Isohunter I download the IMG file and all is going well untill after I extract it; there is no setup.exe icon Does anybody know the source of these problems thanks I don'tn know why that happens but id rather you burn the IMG or ISO onto a CD and once you slot the CD in, it should auto start the VB Express Setup and its smooth sailing from there. It may also be an issue with isohunter try using another ISO extracter. hope this helped kasmatt ...Show All

• .NET Development question regarding .net installation

  Every time I attempt to install .net framework 3.0 on my machine it gives me this error in the middle of the installation . Error occured during setup, setup is removing all installed files. The error logs give me this. 01/19/07,00:29:37] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603 [01/19/07,00:31:06] WapUI: [2] DepCheck indicates Windows Communication Foundation is not installed. [01/19/07,00:31:06] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0 was not attempted to be installed. What can I do There are a couple of additional logs that can be used to troubleshoot Windows Communication Foundati ...Show All

• SharePoint Products and Technologies View Sharepoint data within CRM

  I currently have large WSS site that I am deploying for a client. This site is a single level site that will house hundreds of folders. These folders and files within these folders will be indexed with keywords and Titles. We are also creating an additional column called ID. This field will be a decimal number that we use to identify document type in a folder. (i.e. NDA files will be stored with 207.1 demical ID) This is so we can align Sharepoint will current business processes. We also use Microsoft CRM 3.0. Our goal is to view Sharepoint search results within CRM iFrames. We want to create iFrames within CRM that will display the Document Libraries on the WSS site. For Example: If I am using CRM and I navigate to the accounts section ...Show All