Danny_FADBA's Q&A profile

• SQL Server User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails

  Problem: I am trying to create an asp.net website with integrated windows authentication to access SQL databases. IIS resides on WinXP and SQL Server on Win2000 SRV. Both are in the same NT Domain. IIS and SQL Server cannot reside on the same machine and a stand alone web server is ideal as the website needs to access multiple SQL Servers. IIS is set to Integrated Windows Authentication. The machine running IIS & the SQL Server are set to be "trusted for delegation" in active directory. The domain user accounts that will be accessing the databases are not marked as "Account is sensitive and cannot be delegated". The connection string that the web app uses to connect to SQL database is: "Data Source=PWSSQ ...Show All

• Visual Studio Express Editions Crystal report with Visual Basic 2005 Express Edition

  Can any one help me to use the crystal report in vb 2005 express edition which doesn't have crystal report as the template The good news: You can use crystal reports with Visual Basic Express The Bad news: There are serious limitations with what you can do!!!! The details: I am writting an app that creates monthly reports of sales for all customers of a specific type. I basically runs in batch and spits out a pdf format of a report showing the details for each customers monthly transactions, yearly totals, contanct info etc. Although I havent finished yet I can create the reports I want with out too much difficulty. BUT I cant seem to view the reports in a "CrystalReportVie ...Show All

• SQL Server Get Sql Documenter

  I need to see a total outline of my relationships on my sql database. Something besides database diagram. I need something like Microsoft access Documenter. I want to be able to print out a complete definition of the relationships. HEllllllllllllPPPPPPPPPP!!!!!!!! You could try SchemaToDoc ( http://www.schematodoc.com ). It creates a Word document that includes info about your database - primary keys, fields (type, size, nullable, defaults), indexes, check constraints, foreign keys, triggers, views, stored procedures, and extended properties. It also includes an interface that lets you annotate your tables and fields. ...Show All

• SQL Server job running SSIS package keeps failing but the SSIS package by itself runs perfectly fine

  Hey, I've a few jobs which call SSIS packages. If I run the SSIS package, it runs fine but if I try to run the job which calls this package, it fails. Can someone help me troubleshoot this issue None of my jobs that call an SSIS package work. All of them fail. Thank you Tej I have the same problem. Except that I have had these packages working prior to this failure. I tried re-installing the SQL Server 200 DTS Designer components as suggested in the article, but to no avail. Same result. I will be very interested if you get any helpful responses. ...Show All

• .NET Development XmlElement.SelectSingleNode Issue

  All, I have the following xml file, this was generated by the .NET disco.exe utility. < xml version="1.0" encoding="utf-8" > < discovery xmlns:xsd =" http://www.w3.org/2001/XMLSchema " xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " xmlns =" http://schemas.xmlsoap.org/disco/ "> < contractRef ref =" http://sps2003:81/Services/AdGroupsList/AdGroupsList.asmx wsdl " docRef =" http://sps2003:81/Services/AdGroupsList/AdGroupsList.asmx " xmlns =" http://schemas.xmlsoap.org/disco/scl/ " /> < soap address =" http://sps2003:81/Services/AdGroupsList/AdGroupsList.asmx " xmlns:q1 =" http://tempuri.org/ " binding ...Show All

• Visual Studio Express Editions delay loop / wait / timer

  I need to make a sub containing a delay loop, or the old wait command. basical to pause the app while a function is completing. some things I am trying out take a while to complete, a second or 2, and the app moves on changing forms etc before its done. I have been looking over the microsfts timer pages and I cant seem to get the knack of it. I wish they would fix all those broken links to examples and more indepth help files :( I dont want to stop the whole app, so sleep would not work. I at least it appears sleep would stop all the app functions. I cant find an samples on the forum/web except old vb 4 or 5 or VBA stuff. any help appreciated. a link to a tutorial etc or advise on best way to handle paus ...Show All

• Visual Studio Tools for Office Word Automation and Default Window Position

  Is there a way to tell Word automation object not to save the current window position when Quit() is called Basically, I'm trying to reuse Word Spellchecker in my project. So I assign the Top property of the automation object to -3000 to move it off the screen. Then set the Visible to False so it won't show up on the taskbar. However, when the automation object if finally closed and released. The last location is saved as the default starting position for standalone Word application which happens to be off the screen. You mean the Word window. Yeah, I ended up doing that now. I'm saving the current value of the Top property then re-assign it back before closing. However, you will actually see the ...Show All

• SQL Server Database restore speed

  This problem isn't specific to SQL Server, but because of the size of the files I deal with with SQL Server, it is the place I notice it more often, and hopefully one of you has, too. If I am restoring a database (or simply copying a huge file) that takes more than a couple of minutes, I find, by watching the network bandwidth, that after a couple of minutes, the data rate cuts on half and stays that way for the rest of the restore (or copy). If I have a Gb/s connection, maybe I start at 240Mb/s and then drop off to 120MB/s. If I have a 100Mb/s connection, maybe I start at 70Mb/s and drop to 30-40MB/s. It is fairly consistant in how long before the drop and in the magnatude of the drop (approximately 50%). The network staff have no c ...Show All

• Software Development for Windows Vista SavePolicyLevel throws PolicyException Policy Level 'Machine' could not be saved

  Framework 2.0, Vista, VB.net 2005 On a Vista box, I can add a code group at the machine level through the .NET Framework 2.0 Configuration tool manually if I'm an administrator. I don't have to be the local administrator or a domain administrator. However if I'm running a program that adds the code group using SavePolicyLevel, I get a PolicyException. Here's sample code: ''' Dim objLevel As IEnumerator Dim objPermissionSet As PermissionSet Dim objMembership As IMembershipCondition Dim objPolicy As PolicyStatement Dim objMachinePolicyLevel As PolicyLevel objLevel = System.Security.SecurityManager.PolicyHierarchy While objLevel.MoveNext If CType(objLevel.Current, PolicyLevel).Label.ToUpper = "MACHINE" Then objMach ...Show All

• Windows Forms Populate combobox with datatable column names

  I thought I could do this on my own but after 24 hours across 3 days of working on it I need to ask for help.... I am connecting to an Oracle database, pulling in data into a datatable1 (using tableadapter1 and bindingsource1) and filling a datagridview1. I am trying to populate a combobox with the field names of the datatable1. I have a textbox that will take a SQL query and a button2 that will push the query to the datatable1. The combobox will be used to complete the "SELECT" option in the textbox1. So, the textbox1 will have this "SELECT 'insert column names from combobox1 here' FROM datatable1" Here is my code. The commented out code is what I have tried and failed. I would appreciate any help on this. :&l ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Dispose

  Hello, I've noticed that apart from the top-level "using" statement, the example code never calls Dispose on anything. Is that something we should care about Does it cause unmanaged resource leaks What resources get disposed for us Thanks, Peter Regarding the third rule; If someone writes a method which returns an object which implements IDisposable, you should call it. If wierd things happen when you call it, then the factory which gave you the instance is incorrectly written. You cannot write and expose methods which rely on a specific pattern for it to work properly. It's ok if it is an internal method to do that, but all public methods which returns an object which implements IDisposable has to counter for that fac ...Show All

• Visual Basic add jpgs

  i have jpegs as well as .dat files in a folder called 'data' and i want to include all these in my project which i converted to vb 2005 from vb6, however, i cannot find how to publish them using the wizard; i.e i cant find any options to include these files! (i'm very new to vb.net - only been using it a few days!) From the Project menu...Add Existing Items...All Files... And then select the files you would like to add to the project...You can also create a Subfolder to place all of these files... HTH ...Show All

• Windows Forms Auto Generated Columns

  This feature of the DataGridView is really starting to piss me off, I optimize the positioning, labels and other aspects of my DataGridView, run it to make sure everything is ok, and when I come back to it the thing has added back 20 new unformatted columns that are exactly the same as the ones I already had. How can I disable this 'feature' I think I figured it out. You simply don't use a datamember on the binding source. For some reason if you set the datamember to an empty string, and the dataSource to another bindingSource or the dataSet, then it doesn't automatically generate those columns. What an F-In Pain in the F-In A. God Damn it! It took me over a month to figure that *** out. ...Show All

• Windows Forms ListView doest not display data when setting its HeaderColumns programatically

  hi all, I have a problem with my ListView object..... .... actually it was working fine but i wanted to change the font ot its header cells as i want.... .. i did so by setting the following property lvData.OwnerDraw = true //lvData in the ListView object i also consumed the DrawColumnHeader() event of lvData to set the header info as follows.. private void lvData_DrawColumnHeader(object sender, DrawListViewColumnHeaderEventArgs e) { using (StringFormat format = new StringFormat()) { format.Alignment= StringAlignment.Center; using(Font myFont= new Font("Verdana",10, FontStyle.Bold )) { e.Graphics.DrawString(e.Header.Text, myFont, Brushes.Gray,e.Bounds, format); } } } the problem is that althoug ...Show All

• SQL Server error in access report manager

  I am able to access report server and view the reports on my machine but when i access the report manager it gives error " The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version " Is the service running is the database in a normal state Which Reporting Services version are you using Did you change the compatibility mode Was it a clean install of reporting services You see, that you will have provide more information to let us help you. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All