calbear's Q&A profile

• SQL Server trigger question

  I have the need to use triggers in my database, but am a little foggy on something that reading the official msdn help did not quite clarify. If for example there is a trigger which is triggered when a certain record is updated (DDL ) Is it possible to see what the values were before and after the update I need to create a trail of updates such that the information can be rolled back if need be. Any help with this would be greatly appreciated. Thank you :) PS. If anyone notices that this is a re-post from another forum .... I put the other one in the wrong place accidentally :( ...Show All

• Visual Basic i need help! please someone help!!

  hey guys, i'm doing a project that requires me to build an application with a database. i need to gather information from the database to use with the applicaiton. for eg.. a login page. and the application will look for the appropriate userId and passWord from the database. can someone give me some starters as to how to do it. it has been a frustrating 2 weeks trying to do sumthing. i've tried table adapters, functions and everything but i just can't get it to work. THANK YOU VERY VERY MUCH!! mel There are several things you need to realise 1 - the people helping you do so for free 2 - writing software is an engineering discipline - if you feel that it's nonsense, perhaps that means you're trying t ...Show All

• SQL Server Basic SQL: Multiple AND/OR nightmare in SELECT statement

  This is more of a basic SQL question rather than anything specific for T-SQL, but I assume someone here can help me... I have a problem with properly combining a lot of AND and ORs in a SELECT statement in a stored procedure in order to get the desired results. The problem is that I want to have all results that fullfill all of the supplie d conditions: InstitutionCode, CollectionCode, ScientificName, Locality (unless they are null, hence 'coalesce') and the Parentid, that can be in one of eight columns. SELECT * FROM QueryView WHERE InstitutionCode = COALESCE(@museum, InstitutionCode) AND CollectionCode = COALESCE(@collection, CollectionCode) AND ScientificName LIKE '%' + @binomen + '%' AND Locality LIKE ' ...Show All

• .NET Development How to accessSQL server 2005 through internet ?

  How can I access my Microsoft SQL Server 2005 through internet For example, I set up a Microsoft SQL Server in one of computers of my company, and every computer in my company has its own IP .They are in the same workgroup. Now, there is no problem with database access with another computer in my company. Can anyone tell my how to access it through a computer out of my company (using DNS) Thanks It is not possible in general and it is not advisable. If you need to open up the SQL computer, you need to allow the TCP ports through whcih you communicate with the sql server. Possible, but I doubt any sensible network adminitrator would allow you a direct connection to a sql server machine ...Show All

• Visual C# RadioButton

  I have 2 radioButton "Woman and Man" and I want that these go to my data base... I create array string and stay: string sex = "'" + "radiobutton..text" + "'"; string [] text = new string [2]; text[0] = radioButton1.Text; text[1] = radioButton2.Text; But I when a debug my code I see a error: What the lines not is like the rows. Thank you a lot!!!! again Okay.. now I had more a problem I did it and my code stayed: //cria-se um novo comando mysql MySqlCommand com = new MySqlCommand(); try { com.Connection = Conexao_mysql(); StringBuilder query = new StringBuilder(); query.Append("INSERT INTO "); query.Append(tab ...Show All

• Visual Studio Team System Is there a possibilty of setting up branch inheritance in TFS?

  Hello, Scenario: Single product with approximately 80 projects. The product has a new version released once a year with about 35 service packs for each version sprinkled throughout the year. About 3 versions are supported concurrently at any given time. Current Setup: A new release mandates a new branch in SourceSafe. We share everything and then branch whatever needs modifying in the new version. The reason for the share is that changes to the earlier version are almost always needed in the new version and thus a share reduces the amount of merging necessary. Question: I look at this as a form of branch inheritance. My new version keeps automatically inheriting changes from earlier versions unless I make a new-version-on ...Show All

• Windows Forms Show data from ms access in a textBox

  Hi there, I need your help with something you may find easy but it isn't for me, sadly. I need to show data from my MS Access database into several textBox-es just showing no modifing. I have a sample from my program : OleDbCommand nameCmnd = new OleDbCommand("SELECT name from Customer WHERE customerID = "+ enteredID, myConn); OleDbDataAdapter nameAdapter = new OleDbDataAdapter(nameCmnd); DataSet dsName = new DataSet(); nameAdapter.SelectCommmand = nameCmnd; nameAdapter.Fill(dsName); I try this: nameTextBox.Text = dsName.ToString(); but its wrong! And I have to do the above for every customer details such as name, mobile number, home number ..etc So you can see I need a solution plzz. ...Show All

• .NET Development Validating Xml document, XmlReader reports only one error at a time

  Hi, I've swapped from the deprecated XmlValidatingReader to XmlReader.Create(...) On validating an Xml document, I now receive one error at a time in my ValidationEventHandler, and no line number, line position information. When I used XmlValidatingReader I could validate an Xml document and get all errors reported in one go with line number and line position info. How do I get the same behaviour as before Ken Hi I do not throw an exception in the ValidationEventHandler, I collect the e.Message and set a valid flag so that I can report any validation errors, after validation is complete. Ken ...Show All

• Windows Live Developer Forums ActiveX

  So just to clarify, in the activity window for bot development, no ActiveX is allowed whatsoever Is this just for the competition or in general If for the first, how can I get this enabled for my bot Riaan London ...Show All

• .NET Development WCF Client Behind ISA Proxy Server: HTTP Error 407

  Situation: We have to connect to a 3rd party XML Web Service outside our LAN by adding a WCF Service Reference to a simple console application Problem: When attempting to invoke any of the generated client class methods, we recieve the following error: "The remote server returned an unexpected response: (407) Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy service is denied. )." In old style ASMX Web Reference: TheServiceWse client = new TheServiceWse(); client. Proxy = new System . Net . WebProxy( "ISA Server Name" , 800 ); client . Proxy . Credentials = System . Net . CredentialCache . DefaultCredentials; Where clie ...Show All

• SQL Server Force View || Create View Accessing view that has not been created yet?

  Hello All. Does Sql 2005 support forced-later-compliation Which is to say, can I create a view that access another view which has not been created yet e.g. "Create Force View Foo" in Oracle. Thanks, Steve You can only do that for stored procedures. This is known and filed in the BOL under "Deferred Name Resolution". HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions Using Visual Basic Express 2005 and Crystal Reports XI Release 2 Together

  Win XP SP2, VB Express 2005, Crystal Reports XI Release 2 (full registered version). I have installed VB Express 2005. I then upgraded Crystal XI to Release 2 and installed. I added the CrystalReportViewer to the vb toolbox. I have the following references in my project: CrystalDecisions.CrystalReports.Engine, .ReportSource, .Shared, .Web, .Windows.Forms All are of .NET type and version 11.5.3700.0 When I put the CrystalReportViewer onto a form from the toolbox, the crviewer does not go onto the form itself but it goes down below the form (where the mainmenu or process components would reside). This means that I cannot resize the viewer myself on the form. After I set up the code and run the report, the parameter di ...Show All

• SQL Server Error Locating Server/Instance Specified from ASP.NET site

  I'm currently learning my way around with SQL Server 2005 and asp.net 2.0, and for this I wrote a little site that uses SQL Server for it's backend. I developed it on my laptop, and it works great, until I deployed the website to my test server, so it's visible to the outside world. The instance I try to access any page that invokes the database, I get the following error: 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). The server doesn't differ much from my laptop setup, except t ...Show All

• Software Development for Windows Vista DragDrop operation behaviour is changed in Vista

  Hi, In Vista dragdrop operation cannot be set to move. (i.e. DROPEFFECT_MOVE ) when UAC (user account control) is set to "on" If I set the drag drop operation to move then the drag drop operation prompts me stating "You will net to provide admnistrative permissions" and when accepted it confirms the action and I see a progress bar, but even after that the dragdrop operation is not succesful. If I set the dragdrop operation to copy everything works fine. Can someone tell me how to go forward. Thanks, Arun can you explain more about the origin of the drag operation, for example what process is originating this, is that process running at an elevated privlage le ...Show All

• Visual Studio 2008 (Pre-release) Cant' get past Connection Limit of 10 on Windows Server 2003

  We're having trouble getting past the 10 connection limit. A simple NetTcpBinding service will accept exactly 10 client connections but no more. This is using WCF RC1 on Windows Server 2003 Standard. We've set the binding's MaxConnections property to 1000. What else is needed to enable more than 10 clients to simultaneously connect to a service David Pallmann Architectural Consultant Neudesic I found the answer: in addition to setting your binding's MaxConnections setting to a reasonable value, you also have to override the default throttling settings of your ServiceHost to get more than 10 connections. David ...Show All