JDHDevelopement's Q&A profile

• SQL Server SQL SERVER 2005 DATABASE MIRRORING for large number of databases

  I am trying to enable database mirroring for 100 database. It goes error free till 59 databases (some times 60 databases) with the status (principal, synchronized) on principal. on the 60th or 61st database it gave the status (principal, disconnected). Also mirror starts acting abnormal. connection to mirror starts to give connection timeout and it is not enabling database mirroring on any more databases. I have SQL SERVER 2005 Enterprise with SP1 on the servers. witness is not included yet. these are my test servers... i have more than 500 databases on my production servers. principal and mirror both are using port 5022 for ENDPOINT communication. All of the databases are critical and all must be included in the Database Mirroring. s ...Show All

• Visual Studio Express Editions Windows TCP/IP Protocol and Connectivity Utilities

  Looking to set up smtp service for email on the intranet and not use external pop3/smtp account. ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_vbcode/html/76b7fa90-4907-4fb5-a9a6-4d772b19e850.htm Windows XP Professional SP2 http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/iiiisin2.mspx mfr=true “ Before you install IIS, you need to install the Windows TCP/IP Protocol and Connectivity Utilities.” “ For more information on Windows TCP/IP Protocol and Connectivity Utilities, DNS, or NTFS security, see your Windows XP Professional online documentation.” Could not locate information. Microsoft support Knowledge Data base yeilds no results on “ Windows TCP/IP Protocol and Connect ...Show All

• Visual FoxPro reading a directory for a existing files

  hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle i've tried it but it seems that is not working... i have vfp 7.0 so with that code i get the number of the files in the directory how can i get then filename thanks a lot its really a big help! novelle ...Show All

• Windows Forms Shortcut checking installation...

  I have a slight issue with the deployment of my app. There are two problems that I have come across which involve the same issue. I am using the AppUpdater component and I have built the initial 1.0.0.0 folder into my setup project. I have created a link to AppStart.exe. Everything was running smoothly. Then I came across two issues. Firstly, a client had a application crash due to buggy programming on my part. In order to get out of this, the client had to shutdown the machine. Upon rebooting, the application would no longer launch from the shortcut and required the original msi file. Going to the actual application folder and launching AppStart.exe was fine. Just the shortcuts were not working. Secondly, now the app is being tes ...Show All

• Smart Device Development EVC 4 socket help

  Hi, I'm trying to implement socket into my pocket pc 2003 application. I compiled the program successfully but when executing, I'm getting some errors regarding the socket. The codes related to socket and the errors are given below. void CDirectDlg::OnTimer(UINT nIDEvent) { int sd; struct sockaddr_in myaddr; int clconnect; sd = socket(PF_INET,SOCK_STREAM,0); if(sd==INVALID_SOCKET) { MessageBox(L"Socket not connected",L"ERROR",MB_OK); } else { myaddr.sin_family=AF_INET; myaddr.sin_port = 1; myaddr.sin_addr.s_addr = inet_addr("152.226.238.139"); clconnect = connect(sd,(SOCKADDR *)&myaddr,sizeof(SOCKADDR_IN)); if(clconnect = SOCKET_ERROR) { MessageBox(L"Unable to connect to IP", ...Show All

• SQL Server Merge Join vs. Lookup vs. Custom Script - which is fastest?

  Very often we have 50'000+ rows which you need to pull values from different source (e.g. CityNames from citycode in Excel file). Currently we are using Lookup - but the questions is which of those 3 options is best in performance wise Crispin wrote: Do a fair comparison though. Either change your query to cache the rows from SQL or disable caching on the lookup. Oranges != Apples. A non cached lookup will be expremely slow as was your script component. It would be best to try to replicate full caching in the script component. The purpose of the exercise was to see which was faster. So, we know how fast (and legitimately so) the lookup component was, now how fast can we get the script component to process The ...Show All

• SQL Server Newbie question(Select from xml table in sql db)

  I am new to this having XML in your db. I am having trouble getting data out of the tables. Eg: Table Fruit Name e.g. Pear FruitInfo e.g. <fruitconfiguration createby="Foobar" colour="green"><BaseFruit BaseFruitname="Apple"><Fruitflavour flavour="good"/></BaseFruit ></fruitconfiguration> /Table I of course want to get the data from the table. The result I want is: Pear Foobar Green Apple good Any help would be appreciated What do you really want Obtain any attribute or specific attribute Do you want one row in result set per row in Fruit table or data from each attribute in new row ...Show All

• .NET Development How to measure http request time in multithreads

  Hi. I'm using C# and .Net 2.0 And visual studio 2005. I want to create a "load test" tool for my web server. the tool should open a few threads, and each thread will post http request, and download the response. My problem is that I want to messure the time it takes for each thread. As I see it I have to lock the thread before i take the time, and release the lock after i recieve my response and stop taking time. The problem is that If I'll do that, I will not have a few requests simultaneously on my server. The code I used is: lock ( new Object ()) { reqTime = System. DateTime .Now; response = ( HttpWebResponse )request.GetResponse(); sr = new StreamReader (response.GetResponseStream(), System.Text ...Show All

• Visual Studio Express Editions Treeview and Imagelist Problem

  I am trying to use a treeview and imagelist. I added 3 images to the imagelist. I have set the treeview's imagelist property to the imagelist I added to the form. Here is some sample code for when I programmatically add nodes to the treeview. nd = TreeView1.TopNode.Nodes.Add("", reader.ReadString, 0) Then I tried: nd.SelectedImageIndex = 1 I keep getting the following error, and it never points to the offending line of code. "An error occurred creating the form. See Exception.InnerException for details. The error is: Index was outside the bounds of the array." a couple more things to check bud....1) What version of the imagelist are you using. You can check this by right clicking the ...Show All

• Visual Studio Express Editions Picture Viewer

  I now have the Thumbnail Control working, after my last post it's a control that is fully independent, all you need on the form is a PictureBox, Panel and Button in the Buttons click event you place one line of code ShowThumbs.GenThumbs(DirectCast(pnlThumbs, ScrollableControl)) and that's it. So why am I here well it's because when the thumbs load they take a long time first each picbox loads in the panel one at a time then the pictures load.This isn't bad for a few Images but if there are 100 Images! What I want is to create the thumbs quicker. Any Ideas If you want to see the code let me know and I will post it. It's a pain isn't it. What I did was store them in a "thumbs" folder once they ...Show All

• Visual Studio 2008 (Pre-release) Root object(class) in Domain Object Model

  I have a question, the question is: In the ADO.NET vNext Entity Data Framework how do I solve the problem of having a root object in my domain model Let's say in my domain object model I have to have a root class from where every other class will be inherited. Obviously the root class does not need to be persisted, it simply adds some behavior to all the objects that I am going to use in my application. While playing with the August CTP, I noticed that I could not make this work. Maybe I'm missing something. Maybe there are ways to get around this problem, can anyone please shed some lights on it What you can do is define an Entity Type in your Entity Model (in the CSDL file) and declare al ...Show All

• SQL Server SSIS Logging to Flat File Destination

  Hi I am trying to use a conditional split task so that I can check for specific fields. If the value doesn't exist I am piping the records to a derived field task, where I add an error. I then try to send these records to a flat file destination so that I can keep track of them. However, when I execute the SSIS data flow task I get the following error [Log Invalid Records [5496]] Warning: The process cannot access the file because it is being used by another process. This file isn't being used by any other process as far as I can tell, and the only process using it is the SSIS task trying to write to it. If anyone has any ideas, then I would really really appreciate it Thanks Darrell Jam ...Show All

• Visual C# Can anyone give me an answer to this?

  Your program will be fed 800 distinct numbers from of a range of 8001 to 9000. You need to store these in-memory and then print. How would you do it Thinking of an array of ints Well, that would need around (4 x 800 = 3200) bytes. Can you reduce the required memory further (by more than 20 times) Regards Mani Thanks for the answer Anomolous There is a bitarray class which does the job cleanly By the way, I could also have boolean array if system stores bool as bits. Does bool take one bit Regards Mani ...Show All

• Smart Device Development CeFindFirstFile using VB6

  Ok, my first Smart Device project and I've come to a bit of a standstill, trying to find out what files are on the device. Tried the CeFindAllFiles, but from what I have read I don't think it will function in VB6. So, on to CeFindFirstFile and and CeFindNextFile. It all looks so easy. I'm confused as to how you set up the returning information. I keep seeing references to 'CE_FIND_DATA', but what is that all about If anyone has an example or ideas it would be appreciated. Bert I would suggest you spend some time reading about the documentation & associated data types returned by the call. There is clearly type mismatch issue i.e. you're not using what is being returned. Manav ...Show All

• Microsoft ISV Community Center Forums Worksheet.Copy causes execution to stop

  Hi I am experiencing an odd behaviour from my VBA code in Excel. I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way. My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing. <CODE> On Error GoTo ERROR: Worksheets(SN_MonthYearAct).Copy After:=Worksheets(Worksheet.Count) .... ERROR: MsgBox(Err.Description) </CODE> The variable SN_MonthYearAct is a constant containing the string "MonthYear Act", and a sheet with this name does exist. Worksheet.Count returns currently 8, and there are 8 sheets in the workbook. I have trie ...Show All