Cyberpro60's Q&A profile
SQL Server SQL Cluster Connection issues
We have a cluster that keeps experiencing intermittent connection problems. Everything from replication falling over (and working perfectly when started again) to SSIS packages failing (and working perfectly when restarted again). Errors messages vary but all pretty much have the same in common - no connection. Eg. TCP Provider: The specified network name is no longer available;Connection may not be configured correctly etc. We have another cluster setup in pretty much the same way, with pretty much the same processes, also replicating.This cluster never has issues. The ssis packages are run from a different server connecting to the clusters, and the distributor both clusters use is also on another server. This seems to be, in my ...Show All
Visual Basic Leave Event
i cant seem to work out how to do this I am in textbox5 and on the leave event i want to have textbox1 to 4 leave events to be proformed and still be able to click into one of those textboxs in textbox5 click on textbox1 TextBox5_leaves(-------)handles textbox5.leave code leave textbox 1-4 end sub Textbox1_leaves(------) handles textbox1.leave, textbox2.leave, textbox3.leave, textbox4.leave code to preformed on the textbox five leave for each textbox end sub textbox1 has focus this works but i am getting this error the sender is set to nothing in the texbox1_leave any troughts System.NullReferenceException was unhandled Message="Object reference not set to an instanc ...Show All
.NET Development XUpdate using C# help
Dear All, I couldn't find any way to update XML doument using XUpdate returned. Please advice if the .NET framework contains any namespaces or classes to work with XUpdate documents If XUpdate refers to http://xmldb-org.sourceforge.net/xupdate/ then I don't think the .NET framework has support for that. .NET has support for XSLT and XPath 1.0 however. ...Show All
Visual Studio Team System Strange checkin policy error
I have setup a code analysis checkin policy on a Team project, I have a solution where I have migrated code analysis settings so I know they are as stringent as the checkin policy and a build of that solution has succeeded. However when I make a change to one of the projects in my solution and try and checkin after a successful build I get the following policy error: TF10139:The following policies have not been satisfied Internal error in Ensures that code analysis is run with a predefined set of rules This project that is having problems is one where I have significantly changed the contents of the .csproj file as it is in msbuild format. However the IDE build reports no problems. Any ideas I'm ...Show All
SQL Server Search a date with using like
Hi guys. First of all im new to t-sql . Im getting confused on how to retrive a set of dates from a table. The script bellow shows what im trying to do. DECLARE @dd nvarchar(7) SET @dd = '%2004' SELECT * FROM tb_Dates WHERE (dt_datetime LIKE @dd) N.B dt_datetime is of type Date/time What im a doing wrong as im not getting any results when runing this scripts. Thanks and sorry for wasting ur time Matt Matt: If you are trying to find dates in the year 2004, Try: select * from tb_dates where dt_datetime >= '1/1/2004' and dt_datetime < '1/1/2005' Dave ...Show All
SQL Server problem with varchar and nvarchar datatype in linked server
Hi, I am updating a remote table using linked server in sql server 2005. but in case of varchar and nvarchar i am getting an error : "OLE DB provider "SQLNCLI" for linked server "LinkedServer1" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Msg 16955, Level 16, State 2, Line 1 Could not create an acceptable cursor." thanks in advance. Thanks & Regards Pintu Pintu, I had a similar problem with deleting rows through a linked sever from SQL Server 2005. I tried from SQL Server 2000 and got a slightly different error :- "The provider could not support a row lookup ...Show All
.NET Development How can I disconnect Wireless Network Connection?
Hello, I have started to develop a network application which will run on the notebooks.I need to disconnect the Wireless Network Connection when the user simply press a button. I searched on the internet but could not find a solution using c# or vb.net. How can I do it using .net framework (2.0) classes. Do I have to use API Thanks in advance. Oceaner. 1 Confussion, I dont know is if there is something special with Wireless connection (Coz have never used and dont know how to manage such connections) or not but what I'm going to write has worked for Dial up, DSL and GPRS connections so I hope this will work for you too. Here: http://www.codeproject.com/Purgatory/rasdemo.asp df=100& ...Show All
Visual Studio 2008 (Pre-release) Can a MessageContract be used with some other parameter in an Operation Contract?
I tried using a string type with message contract, I am getting the following error. MessageContract parameters must be either a single input parameter or a return value. Is there any other way to use other types with MessageContract Thanks Sangeetha S So you're using a msgcontract attributed object as well as a string parameter for the operation Something like this: [OperationContract(Name = "ThisIsASimpleCallUsingMessageContract", Action = "urn:MessageContractTest/SimpleMessageContractCall", ReplyAction = "urn:MessageContractTest/SimpleMessageContractCallResponse")] ResponseMsg1 SimpleMessageContractCall(RequestMsg1 input, string blah); If yo ...Show All
.NET Development The request was aborted: The request was canceled. While using WebClient
Hello All, We have a chunk of code that uploads a file to one of our IIS servers each night. It has worked fine for months until yesterday where it now errors and says "The request was aborted: The request was canceled." Since we have not changed any code we are a bit confused as to why this doesn't work anymore. We are using the webclient object and doing an async call to upload the file. See the source code below. Can anyone shed light on this or help me understand what to look for Thanks. public void UploadFile() { m_UploadClient.UploadProgressChanged += new UploadProgressChangedEventHandler (UploadProgressCallback); m_UploadClient.UploadFileCompleted += new UploadFileCompletedEventHandler (Uploa ...Show All
Visual Studio Express Editions VB Express and SQL question...
Hi, I am a new programmer and so I was following a guided tour about creating my first database from this address... http://msdn2.microsoft.com/en-us/library/6147aah4(VS.80).aspx The directions say this: "In Solution Explorer , select the FirstDatabase.mdf node" but the firstdatabase.mdf isn't there. I followed all of the directions to the letter. I tried looking inother places but with no luck. Can anyone give me some pointers please Open a cmd window (MS-Dos Window) If the prompt doesn't say C:\ enter in cd .. until it does. Then enter DIR/S FirstDatabase.mdf and let me know what it says. ...Show All
SharePoint Products and Technologies ---Create a Portal Site Error. Help me---
Hello! There is a problem when I try to create Create a Portal Site. Wednesday, 21 February 2007 10:59:50 Log file opened. 10:59:50 Starting portal creation for 'Drozd'. 10:59:51 Enter PortalInstaller.Install 10:59:51 Beginning Microsoft.SharePoint.Portal.Install.c installer (Progress: 0) 10:59:51 Retrieving identity for application pool 'MSSharePointPortalAppPool'. 10:59:51 Application pool identity is 'SPS\SPSUser'. 10:59:51 Application pool name is 'MSSharePointPortalAppPool'. 10:59:51 Site database server is 'FIG'. 10:59:51 Service database server is 'FIG'. 10:59:51 Unique database root name is 'Drozd1'. 10:59:51 Enter CreateTeamSite 10:59:51 Virtual server Uri is 'http://fig/' 10:59:51 Creating SPGlobalAdmin object. 10:59:51 Op ...Show All
SQL Server problems displaying images
Hi I have a query that returns a companyname eg. "ACD". This info is then saved in a parameter. On the logo (which depends on company), I use this parameter value to the pick up the right picture like this: =Parameter!.company.Value &"_logo.jpg" The image is there on the server an the path is correct, but the image is not displayed! What is wrong Hi, Under what account does your reporting services run Have you checked that the account has the correct permissions to browse to the location. You can test it by setting a static image on your report and set its url to the location you want. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All
.NET Development Specific Paragraph Matching with Inner Matches
Let's say that I have a bunch of input strings as such: ----------------------- blah blah blah Attendees: Mr. Jones Alfred Mrs. Smith John Mr. Black Peter Mr. White Arnold blah blah blah ------------------ And I want to extract the last names of the attendees (i.e., in the above regex, I want four matches: Jones, Smith, Black, White) If a string does not have the "Attendees:" keyword, then I don't care about that message at all. Likewise, I don't care about people's names if they don't follow the "Attendees:" keyword. For example, in the two following input strings, "Chump" should not be returned: --------------------- blah blah blah Losers: Mr. Chump Chimp Mr. Chump Chimp blah blah blah ---------------- ...Show All
Visual Studio Express Editions Linking between two simultanious tasks in the memory
Okay, I'm using Visual Basic Express, and I'm trying to link two different projects together, but I want them to be both running independantly from each other in the memory. The reason is so that I can do hard-drive accessing with one application, and everything else with another application, so that the "everything else" application does not have to wait for data from the hard drive. The second it needs it, it's already loaded. So the "hard drive accessing" project would load several files into a buffer, and have them ready as soon as the other project needs that data. And it would maintain that buffer, and try to stay 5 files ahead of the other project. But the key that unlocks the door on the whole idea is, to multi- ...Show All
Visual C++ Static constructor in .lib not executed
I have a mixed .exe that uses a static native .lib, VS2005 SP1 I've found that in some cpp files that are part of the lib the constructors of global objects are not called. I've never before noticed the problem on the main .exe so perhaps is something connected to linking with the lib file. The only way I've managed to have the constructor of the global object be called is to add a global function (say "void DummyFunction() {}") in the cpp file that gets directly called by the exe. When doing this the cpp file global object constructor gets correctly called before any code starts to execute (and thus before the dummy call is executed). It seems like if no function in the cpp file is directly called by the exe the code in the cp ...Show All
