EWoodruff's Q&A profile

• Visual C++ using the NtFrsApiEnumBackupRestoreSets

  I am trying to a Locating SYSVOL by using the NtFrsApiEnumBackupRestoreSets function but I can’t find the header that NtFrsApiEnumBackupRestoreSets declared in, to include it in my project, also I can’t find the function parameter declaration for this function. I send to ask how I can use this function and in which OS this function supported and where I can get the Function header and DLL Hello Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 . For issues such as these please use the newsgroups at http://msdn.microsoft.com/newsgroups . ...Show All

• SQL Server Output 10 rows

  Hi! I am a newbie, need to make a report with only 10 rows, and not the whole result. How do I actually specify the output as 10 rows Thank you so much in advance! Thank you som much! SELECT TOP 10 SUM(cd.price) as Sales, ... gave me a list of the most sold CD's + sales figures. How if I want a list including numbers (1 Elton John, 2 Madonna 3, 4, 5, 6, 7,8,9,10etc) How do I make a list and a sequence of numbers on a report Moreover I wonder how to define sales per age-groups I have a file "age" of customers, need to create groups(<16, 16-20, 21-30 etc) and select sales per group. How do I do this ...Show All

• SQL Server Multi-value parameter cannot be passed to SQL where clause (Oracle db)

  Greetings!! I have a problem with SSRS 2005 (simple rdl) on Oracle10g environment. PROBLEM Definition We have multi-valued list box , the selected values of which are being passed as parameters to Oracle 10g (back-end) from the report. I want to be able to pass these values as "WHERE......IN" clause in the main query in SSRS dataset window responsible for loading report. However, when I do that it throws error. I have tried all possible combinations i.e using IN operator with '@', ':' , '&' . Now when I did the same with SQL server as back end; it worked. Can you please help with the exact syntax of executing this successfully Sample Query used in sample SSRS data-set when SQL server ...Show All

• SQL Server Dynamic report with several datasources

  Hello, I am currently working with SQL 2005 Reporting Services and MS Visual studio 2005. In my SQL server I have data about organizations, so that each organization's data is stored in an individual database. In addition, the number of organizations/databases is variable. I know the number of organizations and the name of each one (that it agrees with the name of its database) because there is a database (organizationsDB) with a table (organizationsTB) containing the list of the organizations. So, It would be possible to create a report containing a summary of each organization .... for example a table in which each row contains data of each organization. Could you give me any ideas Thanks in advance! ...Show All

• SQL Server Help with optimizing query

  if I have the following tables: Table Customer_tbl cust_id as int (PK), ... Table Item_tbl item_id as int (PK), ... Table Selected_Items_tbl selected_item_id as int (PK), cust_id as int (FK), item_id as int (FK), ... ------- With the following query: select cust_ID from selected_items_tbl WHERE item_id in (1, 2, n) GROUP BY cust_id, item_id HAVING cust_id in (select cust_id from selected_items_tbl where item_id = 1) AND cust_id in (select cust_id from selected_items_tbl where item_id = 2) AND cust_id in (select cust_id from selected_items_tbl where item_id = n) ------- Each of these tables has other items included. Selected_Items_tbl holds zero to many of the items from the item_tbl for each customer. If I ...Show All

• SQL Server Error in sending mails !

  I am trying to send email thro DTS using Activex Script. Here is the code : ' ********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() const SMTP_SERVER = "MPBAKOREX01.corp.mphasis.com" set iMsg = CreateObject("CDO.Message") set iConf = CreateObject("CDO.Configuration") Set Flds = iConf.Fields With Flds .Item(" http://schemas.microsoft.com/cdo/configuration/sendusing ") = cdoSendUsingPickup .Item(" http://schemas.microsoft.com/cdo/configuration/smtpserver ") = SMTP_SERVER .Item(" http://schemas.microsoft.com/cdo/configura ...Show All

• Visual Studio Express Editions How to do a function if a mouse button is clicked

  i want to make a bar that when i click and move the mouse (while the left mouse button is still depressed) the form moves with it but as soon as the left mouse if let go (unclicked) then the form will stop. so far i have this: Private Sub MoveBar_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles MoveBar.MouseMove If Windows.Forms.MouseButtons.Left Then Me.Location = e.Location Else End If but the problem is that "Windows.Forms.MouseButtons.Left" this piece of code askes the program whether a left mouse button exists, not whether its clicked......can anyone help please! Thanks heaps to anyone whome can help me, even in the slightest. Josef Stalin if (e.MouseButton = ...Show All

• .NET Development WHERE Statement Fails. WHY!

  Private Function Check() 'CheckX10Alerts(ByVal X10_RecvCMD As String, ByVal sndDeviceAddress As String, ByVal typEvent As String) 'Prepare to look for matching alert database Dim int As Int32 bolAlertsEnabled = True If bolAlertsEnabled = True Then Using connection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Dot_Net_Projects\Visual_Basic\aiHome\Website\App_Data\aiHome.mdb;") Dim command As New OleDbCommand("SELECT strMedium, sndDeviceAddress, typEvent FROM x10_Triggers WHERE strMedium = AND sndDeviceAddress = AND typEvent = ", connection) command.Parameters.Add(strName, OleDbType.Char, 150).Value = "Movement - Front Porch" command.Paramet ...Show All

• Visual Studio Team System Error in Team Explorer

  We've got a number of projects defined in our TF system, but on one the Documents folder refuses to expand. The project in question is very new - in fact, there has only been one document change at this time. There's a little red "x" on the folder and no documents or sub-folders are listed. Refreshing the view doesn't change anything and right-clicking the folder does not open a context menu. I've done some searching and come up with this thread which describes similar problem symptoms, but the cause is not permissions related. My account is set as a project administrator on the site and the project. https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=183669&SiteID=1 The project portal works fine. I can access all ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Extremely low Framerate

  I am getting a very very slow Framerate. I will post the code of my Engine component. It's a GameComponent added to the main component through the Designer. public partial class Engine : Microsoft.Xna.Framework.GameComponent { public Engine() { InitializeComponent(); } public override void Start() { CompiledEffect compiledEffect = Effect.CompileEffectFromFile("Resources/Simple.fx", null, null, CompilerOptions.None, TargetPlatform.Windows); effect = new Effect(graphics.GraphicsDevice, compiledEffect.GetShaderCode(), CompilerOptions.None, null); graphics.GraphicsDevice.RenderState.CullMode = CullMode.CullClockwiseFace; graphics.GraphicsDevice.RenderState.SourceBlend = Blend.Sour ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Sphere mapping

  In mdx 1.1, you can enable automatic generation of sphere mapped texture coordinates with: this._device.TextureState[this._stage].TextureCoordinateIndex = 0x00040000; Is there an xna equivalent Or do you have to do it manually This doesn't appear to do it: this._game.GraphicsComponent.GraphicsDevice.SamplerStates[this._stage].ElementIndex = 0x00040000; The ZMan wrote up a really good C#/MDX tutorial on mapping spheres (and other objects) here: http://msdn.microsoft.com/coding4fun/zman/zmanTextures3/default.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. About the fate of DirectX?

  Hi, I'm new here =) Hopefully I'm not asking a question that's been asked a million times before. =) I think I must be missing something important. I read the XNA FAQ, and it sounds to me like they've already deprecated Managed DirectX... does that mean that XNA has/will entirely replace DirectX If I want to write a program using DirectX in .NET, would this then mean that my program will need to be rewritten using XNA in the coming months And what about users who need the common graphics API provided by DirectX but don't have Shader support in their video cards Just curious, because that FAQ about Managed DirectX being deprecated alarmed me a bit (for the reasons expressed above) Depends on the game. If you want to write 360 games ...Show All

• SQL Server DB Maintenance Plan

  I have a SQL 2000 server that has a small but very important database (about 5GB). The current maintenance plan does trans logs every hour and full every day. Currently they are to file on the same drive array. I would like to send them to a share on another server just to be really safe. Would it be better to 1. Redirect the maintenance plan so that trans logs and backups go directly to the share or 2. Keep the maintenance plan back ups to the current location and write a script that runs every hour and copies the .bak files to the share. Also, since the database is so small should I just do full backups every hour instead of transaction Thanks for the tip regarding backup types. What about getting the backups off ...Show All

• Visual Studio Team System Can we insert an image in a new bug without having to insert a File Attachment?

  Hello all! Simple question here...we currently find bugs in our application. We take a printscreen, then paste it in Snagit then use image effects on the printscreen. We then paste that image inside a WORD document with some repro-steps and what not... Then we open VSTS and create a new bug. After entering a bunch of fields, we click on the "File Attachment" TAB and attach the current WORD document. This process is nice and clean but it isn't effective enough. Would it be possible to directly paste that image inside the "Detailed Description and Histpry" field of the "Summary" TAB Would such a thing be fesable Is there an add-on somewhere that would allow me t ...Show All

• SQL Server Report code and dataset question

  I have a strange (maybe not too strange) problem. I have data populating a report and everything is fine. This table also references another table where there might be zero to several prefixes associated with the name. If I have one row from the main table, but there are three prefixes that have to be concatenated to the beginning of the Name field (like a one to many situation), what would be the easiest way to do this I thought of doing a separate Report code and I have the following: Function addPrefix(byval current as string, newToAdd as string) as string dim deg as string deg = current + " " + newToAdd return deg End Function In the text box, I have it referencing it's own value. So the textboxes express ...Show All