webbsk's Q&A profile
SQL Server Embedded code: what's the trick?
I am trying to put some embedded Visual Basic code into my report (RS 2005), using the "Code" section in the report properties. Here's the function I'm trying to use: Public Shared Function ReportTotal(ByVal IsUnitCost As Boolean,ByVal TotalDirectCosts As Double, ByVal SalaryBenefitsTotal As Double, ByVal IndirectRate As Double, ByVal SS_Screened As Integer, ByVal UnitRate As Double) As Double If IsUnitCost Then Return SS_Screened * UnitRate Else Return TotalDirectCosts + SalaryBenefitsTotal * IndirectRate End If End Function Supposedly, after entering this you can access it in the expression for a field by typing the following: =Code.ReportTotal(... parameters ...) However, when I try this, "Report ...Show All
Visual Studio Team System TFS puts the files an which path?
TFS puts the documents files an which path i can't find anywhere or it puts the all documents in the Sqlserver database A related question. It looks like the path part of the table only allows 254 characters. Does this mean that I can't have folders nesting deeper than the level at which the full path length gets to 254 characters This seems like a serious limitation. ...Show All
Visual Studio 2008 (Pre-release) DLINQ question
I just finished watching the "The LINQ Framework What's New in the May CTP" presented by Luca Bolognese. The video discusses DLINQ. question #1 I am a student and just starting to learn stored procedure of SQL. Correct me if i am wrong but my interpratation to the demo is that this DLINQ prevents you from creating sql stored procedure and your database query will mix up on your c# code or the business logic of the program. is that manner ideal would it be better if the sql code or the dlinq code is in a separated file and not mixed up with the business logic code quetion #2 would this DLINQ work with other database like MySQL, Oracle, etc this is my first time i have seen a video of LINQ. please correct me if i am wrong with my interpre ...Show All
SQL Server Is SQL 2000 32 bit supported
Hello All, I need to know if SQL 2000 32 bit is supported on a Windows 2003 64 bit on a x86 processor server. The server is clustered. I wasn't aware you can install 64bit OS on an x86 machine, that just doesn't sound right. Regardless, SQL 2000 (32-bit) cannot be installed on 64-bit OS. However SQL 2005 (32-bit) is allowed to be installed on 64-bit OS. Someone can correct me if I'm wrong. ...Show All
Visual Basic ERROR: Unrecoverable build error when building Setup project in VS.Net 2005
Hello, Somebody, please help me out, I got "Unrecoverable build error" when building setup project. I try the solution in http://support.microsoft.com/kb/329214/EN-US/ but did not work out. I am totally stuck. Please, your any information, solution will be very much appreciated. Thanks! Yi-an Thanks a lot buddy. I had wasted my evening and though i would have to reinstall windows before i wll get this thing workable.. but u saved a lot of time ... cheers sambhav ...Show All
Visual Studio Team System How to import work item's custom fields to TFS
Hello! I created new work item type. There are a lot of custom fields in the new work item type. Now I would like to import several thousand work items from excel to TFS. I tried to make XLS file by invoking “Open selection in Microsoft Excel”, fill that file with my data and Publish Changes. But XLS file doesn’t contain my custom fields so I can’t import my data to TFS. Is it possible to import work items with custom fields to TFS May be it is possible to develop some plug-ins to TFS to solve my problem Thanks in advance, Pavel Hi Pavel, You can use the Choose Columns button in Excel to get the columns you want. Also, you can modify your query in Team Explore ...Show All
Visual FoxPro date question
Hi, Someone knows if there is a function or something like that in fox 7 to calculate the difference between two dates. Thanks, Hi. VFP return the difference in days: x={^2007-02-27} y={^2007-02-20} x-y && 7 Does this respond your question or do you need to obtain another result ...Show All
SQL Server NTEXT special character "SQUARE" appearing where a return should be. How do I fix this?
I had to import some FileMaker Data into SQL Server 2005 and in the resume field a "SQUARE" special character is appearing everyplace that a return should be. It has really messed up the formatting. I know how to use the updatetext in a cursor to replace the special character but I don't know what to replace the "SQUARE" special character with so the text is displaying a new line rather then this "SQUARE" character. Any help would be appreicated. Try replacing it with char(13) + char(10): replace(resumetext, char(1),char(13) + char(10)) This works: declare @test nvarchar(100) set @test = 'this is the character' + char(1) + 'this is a different line' select replace(@test, char(1),char( ...Show All
.NET Development HttpWebRequest Post problem
I have a "The underlying connection was closed: The connection was closed unexpectedly" error when trying to POST using HttpWebRequest. There's a GET prior to this call that works fine. I have done quite a bit of web research and all of the following have been tried: request.KeepAlive = false; request.ProtocolVersion = HttpVersion.Version10; System.Net. ServicePointManager .Expect100Continue = false ; request.PreAuthenticate = true ; Install WindowsServer2003-KB898708-x86-enu.exe on IIS Server. Here's the part of the Trace with the HTTP POST, maybe something here will help: System.Net Verbose: 0 : [3628] WebRequest::Create( http://w2k3pdwads01/access/oblix/apps/webgate/bin/webga ...Show All
SQL Server Any ideas how to connect to an Informix DB?
I need to use the an OLE DB Provider to create a Linked Server using a ODBC-Connection (Informix). I know that I cannot see many things in the Providers drop-down list. Has anyone created a linked server like this one I mean SQL 2005 (Standard Edition) x64 and Informix. 10x in advance. Of course I'll provide any useful news as soon as they will arive. I want this solved and shared with the rest of us, so we don't have to be at Microsoft's mercy; or any other giant for that matter ...Show All
.NET Development Request.form array does not contain an entry for a dynamically created input element
This seems like an easy yes/no question in terms of whether or not I should be able to do this. I'm really hoping the answer isn't "no", but due to empirical evidence I've lost some hope. Is it not possible to submit, via a named input, data to the Request.form array if the input was dynamically created by JavaScript on the client My submitted named inputs which were created by the script are not showing up in the submitted data. ...Show All
SQL Server drop user
Hi, I have a user in my SQL server 2005 database sys.sysusers table with following values. I am unable to delete this user and unable to create a user with this same user name. Please tell some one what is status=16 and issqluser=0 status 16 ame \CMSXXCMSTESTER roles NULL altuid 5 hasdbaccess 0 islogin 1 isntname 0 isntgroup 0 isntuser ...Show All
.NET Development i nead some help pleaseeeeeeeeeeeeee
i was contacted by some one on my messanger list and thay admited t me thay have a program that will block ppl frome getting into any msn site including messenger and chats and groops. thay admited to blocking a few ppl i know i went to them and asked if any probs and yes there was exactly what i was told would happen. is there any way i can get some help to stop this and get there abilty to go to msn sites back for them. please help. im afraid these forums are for software development only. Whilst we appreciate your efforts to stop these activities, the best place would be to ask here: http://support.live.com get in touch with the support goes for MSN/Live and they should be able to help you furth ...Show All
Visual Basic limiting key stroke
hello, i would like to limit my keystroke, heres what i used on my vb6, can i have any suggestion about transferring it into .net code Private Sub Amount_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case 110, 190 Dim count As Integer For count = 1 To Len(Amount.Text) If Mid(Amount.Text, count, 1) = "." Then Amount.Locked = True End If Next Case 48 To 57, 96 To 105, 8, 46 If Amount.Text = "0" Then Amount.Text = "" End If Amount.Locked = False Case Else Amount.Locked = True End Select End Sub thanks hello sir, i am trying to disable non numeric keys. in doing so, i also ...Show All
.NET Development ASPNET user rights
I am having trouble getting my WebService working with Wse3. The problem is that the ws dosn't provide any security header in the response to the client. Both Client og WS is runniing on my local computer, Xp Pro with IIS installed. I am using IIS to host the WS This is from my OutPutTrace file (just some of it.) <faultstring>Microsoft.Web.Services3.Security.SecurityFault: The security token could not be authenticated or authorized ---> System.Security.SecurityException: WSE3003: The certificate's trust chain could not be verified. Please check if the certificate has been properly installed in the Trusted People Certificate store. Or you might want to set allowTestRoot configuration section to true if this is a test certif ...Show All