xshua's Q&A profile

• SQL Server How many SQL Server Liscences ???

  We need to know how many SQL Server Liscences we require. We have 2 SQL database users (user_app, user_web: one for our application and one for web access) There will be around 4 windows logon users using the application and about 50 people using via the web. Do we need 2 liscences, one for user_app, and user_web or more i hope not 54 lol!!! Just wondering what is the cheapest set of liscencing we require for SQL Server 2000 The deal with Web Licences is that you will either have to name the individual users who will access the application and therefore the SQL Server (multiplexing) or buy a processor license. If only your internal employees will access the database and you already covered them with the appropiate l ...Show All

• Software Development for Windows Vista Power icon problem

  Hello, I've just installed the Windows Vista Beta 2 (Build 5384) and so far so good, except for one thing: somehow i can't activate the option to show the power icon on the "notification are" of the "taskbar". When i go to the properties of the "taskbar", and then go to the "notification area" options, i'm allowed to select to always show the clock, volume and network icons, but not the power icon. Do you know what can i do to fix this problem Because of this problem, i never know when the battery is low. Thanks for your help!! Mike-- Do you see a battery icon in the system tray Even if you have multiple batteries, you will only see a single icon in the ...Show All

• Windows Forms OverDrawing Custom Inherited Controls

  Hi, Using VB.NET. I'm a beginner so please be gentle..  I am trying to overdraw most of the windows controls, including Listbox among others, so that they have a solid 3 pixel border. Currently I am doing this by creating a customcontrol inheriting from the specific windows control i.e. CustomListBox, inherits ListBox. CustomTextBox inherits TextBox.. etc.. then handling the WndProc and looking for the WM_Paint message.  ...Show All

• SQL Server InfoPath 2007 and endpoint yielding HTTP authentication failed.

  I created a HelloWorld like example using InforPath 2007 and endpoint with SQL Server 2005. Very simple example. I created a stored procedure that took in one parameter, a datetime field. This parameter is then inserted into a db table that has two columns, an id column and a datetime column. I took the store procedure just discribed to create an endpoint. Cool. The WSDL is showing, I'm feeling good. I go to InfoPath and make it so that submit a datetime to the webmethod associated with the endpoint. The data table shows one more row has been added and it is the datetime I sent from InfoPath. YEA!! I go to the Event View and see that I have an error message. The message is HTTP authenticaiton failed. [CLIENT: 10.8.2.26]. Bummer! ...Show All

• Visual Studio Team System TSD306: Can not resolve the ambiguity between...

  I have many these warnings. See examples of code for which the warnings occures: ----------------------------------------------------------- create function dbo.FLT_F_GetFilter (@xmlDocID int) returns @result table ( number int not null, type varchar(20) not null, ColumnName sysname null, Operation nvarchar(40) null, ProcedureName sysname null, Value varchar(7000) not null ) as begin insert into @result select F.number, F.type, RTC.[Name], FOT.[Name], RTC.ProcedureName, F.Value from openxml(@xmlDocID, 'Items/Item', 3) with ( number int, type varchar(20), ColumnName uniqueidentifier, Operation uniqueidentifier, Value varchar(7000) ) F left join dbo.ResultTypeColumns RTC on RTC.ResultTypeColumnID = F.ColumnName ...Show All

• Visual Studio Express Editions Must be non-Negative and less than the size of the collection

  Hi All, I need help with the code below. I keep getting this error when I run this code. "Index was out of range. Must be non-Negative and less than the size of the collection Parameter name: Index" This is the code I am running Private Sub tsbtnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tsbtnSave.Click objData = New DALBase Dim iv As New OracleParameter Dim oraConnect As New OracleConnection("Data Source=DEVELOPM; User id=VS_DEVELOPER; Password=f00tball;") Dim myCMD As New OracleCommand("Weblogica_Systems.Insert_Daily_Sales", oraConnect) Dim Val_1 As String Dim Val_2 As String Try oraConnect.Open() dgvSalesDetails = New ...Show All

• Visual Studio Tools for Office Hyperlink in Excel Not Displaying Properly

  I am using VB..Net 2005 and Excel 2007. When adding a hyperlink to an Excel spreadsheet, everything works properly, except that the text in the cell is supposed to say "My Link". Instead, it says "Sheet1!B4". The link works properly, but the text that is displayed is wrong. Does anyone have any ideas Here is the line of code that I'm using. Thanks. Globals.ThisAddIn.Application.ActiveSheet.hyperlinks.add(anchor:=myAnchor, Address:= "" , subAddress:=subAddress, textToDisplay:= "My Link" ) I noticed in my original code where I was using Globals.ThisAddIn.Application.ActiveSheet.hyperlinks.add(anchor:=anchor, address:=address, subAddress:=subAddress, te ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX windowed mode. Other applications become sluggish?

  I have a problem with other applications becoming sluggish after running my Direct3D 9 windowed application for some time. The slugginess won't go away even if I minimize my application. If I terminate the application, everything is fine again. It also takes some running time before this behaviour appears. I only perform redrawing of my GUI internally, and as long as the user don't interact with the interface, redrawing simply means copying from the backbuffer to the frontbuffer. At this point, I'm not accessing any textures or 3D resources other than the backbuffer. All redrawing is event driven, from the WindProc function. I don't have any animations or timer based drawing, only event driven. As an example. I'm having the application ...Show All

• SQL Server Creating a dynamic excel file

  Is it possible that i can create a dynamic excel file (destination) ex, i want to create a Dyanamic Excel destination file with a filename base on the date this will run on jobs. Is this possible 11172006.xls, 11182006.xls Jaegd, Not sure if that will work. I am working on a similar problem now. I am trying to load the contents of a table into an Excel file every week with a datestamp in the filename. I've tried a few approaches but haven't found a good solution yet. But here's what I found so far. 1. The first approach was to dynamically configure the connection string or filename property of the excel connection to generate a unique name every week. In design time, you will have no pr ...Show All

• Visual Studio Web Site Projects hosted on Sharepoint 2007

  I'm not sure if this is the correct forum, but I am trying to host web site development projects (which require 'Frontpage Server Extensions') in a Sharepoint 2007 environment. Is this possible If so, does it require a special add-in to Visual Studio (Currently, when I try to connect to a site hosted within a Sharepoint 2007 'web application' I get the error "The version of Windows SharePoint Services running on the server is more recent than the version of Sharepoint Designer you are using".) Any ideas what I'm doing wrong 100 views and not a single response Are there that many of you that want an answer to this, or did this issue go away with the SharePoint RTM ...Show All

• Visual Studio Unable to debug Stored procedure using Visual Studio

  Hi, What is the procedure to enable SQL Server Debugging I have the following apps. installed in my PC: IDE: VISUAL STUDIO 2005 With SP1 Beta, DB: SQL Server 2005 Developer Editon The problem is, after setting up my connection and sucessfully opening it and started my debugging procedure by right clicking onto the opened stored procedure, i don't see the 'Step Into' button to add my break points. So, i was wondering maybe the debugging function is not enabled. Thanks. Dencio, You need at least the PRO version of Visual Studio 2005 in order to debug stored procedures. Which SKU do you have Azeem Khan Visual Studio Debugger. ...Show All

• .NET Development Encrypting custom configuration section

  I wrote a conventional custom configuration section; I created a custom section handler that extends ConfigurationSection, a collection class that extends ConfigurationElementCollection, and an element class that extends ConfigurationElement. All worked well. I was even pleasantly surprised to see that my custom section inherited the configSource attribute: that I could extend my custom section out to a separate configuration file. This is especially nice since I deploy my solution to different environments (IT, UAT, Prod) and my values change with the environment. Abstracting those values out to a separate config file makes it easier to accommodate for the environment. Now, I want to encrypt my section using the aspnet_regiis utility. To ...Show All

• Visual Studio 2008 (Pre-release) Condition for EventTrigger

  Hi guys, Is there any possibility to put condition for EventTrigger as I can do for DataTrigger. <DataTrigger Binding="{Binding Source={StaticResource AnimationStateKey}, Path=Animate, Mode=TwoWay}" Value="1"> <DataTrigger.EnterActions> <BeginStoryboard> <Storyboard> <DoubleAnimation Storyboard.TargetName="ListBoxScaleTransform" Storyboard.TargetProperty="ScaleX" From="1" To="2" Duration="0:0:0.5" /> </Storyboard> </BeginStoryboard> </DataTrigger.EnterActions> </DataTrigger> I have some variable in code which I'd like to check before I start the storyboard on routed event <Window x: ...Show All

• Software Development for Windows Vista Registry entries for TimeZoneInformation are no longer correct

  The registry values for the current time zone in Vista appear to be incorrect (or no longer supported). We rely on being able to get the name of the currently selected time zone from the registry, but it appears to be incorrect in the RC1 and RC2 builds of Vista. The registry key on 2003R2 is: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation "StandardName"="Pacific Standard Time" "DaylightName"="Pacific Daylight Time" The two values here are not working correctly with Vista (we rely on StandardName). The registry key on Vista is: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation "StandardName"="@tzre ...Show All

• SQL Server how to user sql xml

  hi, I am new to sql xml, how to get start ...Show All