VBAddict's Q&A profile

• SQL Server Unable to install SQL Server 2005 SP2 - Unexpected error (error 1635)

  I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0 MSI (c) (74:68) [16:05:42:635]: ******* RunEngine: ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI ...Show All

• Visual FoxPro How to create a Word document?

  I wish to convert a memo field into a Word format document. I searched around and found this: oWord=CreateObject("word.application") oWord.Documents.Open("c:\test.doc") oWord.ActiveDocument.Range.Start=0 oword.ActiveDocument.Range.End=0 oWord.ActiveDocument.Range.Text="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" oWord.Documents.Save() It works if the test.doc is already there. How do I create the file using VFP code because the file name should be created by the user himself. Thanks. Hi. Instead of .Open you should use: oWord. NewDocument.Add ("c:\test.doc") Obviously you should replace "c:\test.doc" per a variable th ...Show All

• Visual Studio Team System Moving a dual server instance to new hardware

  I'm in the middle of moving a dual server instance of tfs to a couple of test machines. We've successfully installed the tfs dual server setup to the app and data tiers, and restored the databases from the live instance to the test setup. I'm just in the final stages of the move and am hesitant to run the tfsadminutil activateat command because of the prompt i receive. It asks me to make sure the old app tier has stopped the tfs service before running the command. My question is this. By running the command on the new server, will it in any way affect the old instance. The reasons; I have a live instance running on 2 machines, and I want to do some testing in a staging environment, so I need to live instance to be available after I do th ...Show All

• .NET Development How to get .Net 3.0 to work with VS2005?

  I am running WinXP SP2. I downloaded and then tried running the .Net 3.0 redist package from this location: http://www.microsoft.com/downloads/thankyou.aspx familyId=10cc340b-f857-4a14-83f5-25634c3bf043&displayLang=en It bombs every time with a generic failure message. All I want to do is ty to get .Net 3.0 to work with VS2005 (not Orcas) and do some work with WCF. I'm seeing quite a few posts on the confusion of what exaclty to install. I'm not sure why this has to be so complicated, especially if .Net 3.0 is supposed to have been released. Can anyone point me to a clear series of steps of what to download, and where it can be found Have a look at this thread. http://forums.microsoft.com/forums/ShowPost.aspx PostID=1083382 ...Show All

• Connected Services Framework I m getting an error while invoking the webservice available in session.

  I have replicated the syncsessioninitiator(sample distributed by CSF) in my project. I am trying to use a web service which is functional n is running fine. I am getting the following error in CSF <wsu:Timestamp wsu:Id="Timestamp-656e90be-b4d0-4a74-b403-879907c289a8"> <wsu:Created>2006-09-20T13:20:46Z</wsu:Created> <wsu:Expires>2006-09-20T13:25:46Z</wsu:Expires> </wsu:Timestamp> </wsse:Security> </env:Header> <env:Body> <env:Fault> <env:Code> <env:Value>env:Sender</env:Value> <env:Subcode> <env:Value xmlns:prefix0=" http://Microsoft/ConnectedServices/2006/06/Session/">prefix0:2000 ...Show All

• SQL Server How to modify column in a table with replication?

  Dear all I have a problem about replication, so I want to modify some columns in a table, but my database using replicate. How to do it Please solution. Thank. PC Kaveesin. If you are using SQL 2005, you can directly use 'ALTER TABLE ALTER COLUMN..." to modify column at publisher. The changes will be propagated to the subscribers. For more info, please take a look at http://msdn2.microsoft.com/en-us/library/ms151870.aspx . Peng ...Show All

• .NET Development Port Binding and Intercepts

  I have attempted asking this question all over, and none of the responses I’ve gotten have proven to be helpful. I’ve created a listener and client in c# along with its related DLL. I’ve gotten the port to bind and the listener works fine with the client. My question is this – Logically, if you bind a port, you should be able, under some sort of event triggered, to intercept a soap request before it is dispatched to it’s relative service call, and after it has been dispatched to that service call , i.e. Before the request is carried out and after it has been carried out, but before the response is sent. I would expect some sort of OnBeforeDispatch event and OnAfterDispatch event, or something of that nature. My reason fo ...Show All

• Visual Basic Form show unrequested

  To get some experience using VBE, I converted a simple program I once made for myself(VB5). It's a birthday calendar, using a VB5 commandbutton for each day of the year, i found that VBE has great problems handling this many controls, it is slow, very slow and realy unworkable. Some where else in this forum I found that others with a lot of controls experience the same problems and there is no neat solution for it. In the mid 80's the basicinterpreter was quicker than this VBE with a machine that is 2000 times faster. Another problem I have is that the main(start) form of the program shows up unrequested. In the load section of the (start)form I show another form from which I normally select whether I show the (start)form or not. The se ...Show All

• Visual C# Management a binary data stream

  I have to download a set of binary records (S1) from a remote server. I do it easily. The problem comes up when I try to download a set of sets , so to speak in a loop. Processing a single set (essentially, this set ends up in a DataTable) is handled in a Thread . I use a demo that I've adjuted to my wrapper (app) and I really still do not understand how this thread is set up. There is no explicit Thread class instantiation in the code. Perhaps when a new Socket instance is created the thread is set up automatically, I do not know. Anyhow, downloading one DataTable causes no trouble. When I tried to automate process for many tables I ran into a problem. In a loop where the request is formulated there is a call to the routine that handle ...Show All

• Visual Studio Can't install, get error

  Using XP64 ver. 1069 Get an error that background intelligent transfer system is not enabled. I try the troubleshoot, but all settings match and diagnostic tools they say to use won't run, because errors say "for windows xp only" or "for other architecture" It is supposed to run on this version I according to the list I think. Thanks. Same error on my PC for >18months. I have tried all the fixes, but nothing works. I just can't turn BITS on. I am now beyond crazy! And have had no updates for >18months!! Your error code has a resolution in the microsoft help & support article ID 910337. There are lots of resolutions in this article My error code is 2147024891 (cf94). This fix did not help m ...Show All

• SQL Server Order By for DATENAME

  SELECT DATENAME(mm,w1.WorkoutDate) AS WorkoutMonth, DATEPART(yyyy,w1.WorkoutDate) AS WorkoutYear, Count(*) AS WorkoutDaysCount FROM Workout w1 WHERE w1.MemberID = @Memberid GROUP BY DATENAME(mm,w1.WorkoutDate),DATEPART(yyyy,w1.WorkoutDate) how do i implement order by in above query I want the result month & year wise. i'm using DATENAME function here. One more question. i have table named [WorkoutCount] with month,year and other columns. I'm storing month as integer. But when i retreive data i wanted charchter month like "April" instead of 5. How do i use DATENAME in this case or is there any alternate solution ...Show All

• .NET Development Can any one explain me more about Regular expressions in C#

  Hi all, Could any one explain me about Regular expressions in C#. I went through the Orielly book of C# programming, but I was totally confused. Can you qoute some examples and explain where the RegExp are used..... Thanks, suresh. Shorthand Character Classes \d matches a single character that is a digit, \w matches a "word character" (alphanumeric characters plus underscore), and \s matches a whitespace character (includes tabs and line breaks). The actual characters matched by the shorthands depends on the software you're using. Usually, non-English letters and numbers are included. ...Show All

• SQL Server Finding the Max Value

  I have a report that is grouped by week. The details of the week have the date, time interval (half hour), and the maximum value for that day. So in the example below I am showing the week of May 21st. Then I have all of the days of that week, sorted by date as requested, with the halfhour the maximum value occured in on that day. So Monday the 22nd has the maximum value for the week at 254 (and is highlighted in red). Where the are below, I need to display '1400' which is the interval, but have not yet been able to figure out how to do this. I tried the following expression: =iif(max(Fields!MaxValue.Value) = Fields!MaxValue.Value, Fields!Interva.Value, "X") but this only works if the first day is the maximum value. ...Show All

• Smart Device Development Shift Tab

  Hi, How can I make Shift+Tab (gives focus to the previous field) work in CF2 . Regards Mario Two questions: Which platform are you targeting: PocketPC/SmartPhone 2003, PocketPC/SmartPhone 2003SE, Windows Mobile 5.0 Which device are you targeting Thanks ...Show All

• Visual Studio Team System TFS (RTM) Setup Errors

  Hello All, I have tried unsuccessfully to install the Workgroup RTM of TFS over the last few weeks. I've seen a variety of errors and have rebuilt the W2K3 virtual server image a number of times. I have followed the installation guide (v60711) carefully with no luck. I have scanned the 2 log files and have found a few errors which I have seen posted in this forum before: System Error 0 while trying to start service "SPTimer". You might need to manually restart service. The Commandline '"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Bin\Stsadm.exe" ...' returned non-zero value: -2130246864 I would appreciate any ideas on this one. I can email the error logs if required. Than ...Show All