brandontyler's Q&A profile

• SQL Server Does Windows 2000 Professional supporte native HTTP access???

  I'm trying to create a new webservice by sql 2005. My operational system is a windows 2000 professional, but when I try to create a endpoint, I've got the follow message error: Msg 7812, Level 16, State 1, Line 1 The endpoint 'RetornarUsuarios' has been established in metadata, but HTTP listening has not been enabled because HTTP support did not start successfully. Verify that the operating system supports native HTTP access. Check the SQL Server error log for any errors while starting HTTP support. Msg 7807, Level 16, State 1, Line 1 An error ('0x80004005') occurred while attempting to register the endpoint 'RetornarUsuarios'. ...Show All

• .NET Development How to serialize an object wich is marked as non-serializable ?

  Hi, I'd like to serialize/deserialize (xml or soap) an object wich is not serializable. I don't have sources of the object. I tried to declare a new serializable class, who inherits from the object class, but it doesn't work. Is there any other way to "record" an object (properties & values) Thanks Vikram, I tried using surrogate but there's an error "The method or operation is not implemented." when i call serialize method. It works with simple objects (like array os string) but not with more complex objects. When it doesn't work, " GetObjectData" method is called, else, it's never called. Apparen ...Show All

• Visual Studio Unable to Insert Chart Problem

  Hello All:  I am using Crystal Reports With VS 2003 everything works ok with the exception that I can't Insert a Chart into the report. When I try inserting the chart using the Chart Expert The Ok button is always disabled. No error messages or anything appears and all other report functions work correctly. Any Ideas TIA Desdacato Hi Keith: Thanks, I figured it out it was my error I forgot to add the fields to the Show Value(s) list on the chart expert... color me embarrased! Thanks Much Desdecato ...Show All

• SQL Server Extracting the parameter values

  I have a report application where I am using Microsoft AxBrowser and url acess to view the reports. I have a report with multivalued parameter. I need to extract the user selected parameter value for that rpeort for some other purpose. How to extract the parameter value Please help Do you have access to the cookies collection of the AxBrowser control If so, then you can try to get the RS session ID and call the SOAP API GetExecutionInfo() on that session. It will return the effective parameters for the current session. Assuming you haven't changed them then it should be the parameters that were used to ...Show All

• SQL Server Cannot insert explicit value for identity column

  I am writing a program to import data across from one database to another. I need to be able to make it use the current ID numbers or else the relations will be broken. I keep getting: Cannot insert explicit value for identity column in table 'mytable' when IDENTITY_INSERT is set to OFF. I have opened up SQL Server Management Studio created a new query with: SET IDENTITY_INSERT [BMSSUNRISE] . [dbo] . [SystemInventory] ON GO this results in success but the program still fails, I have tested the Insert SQL statement in the SQL Studio tool and included the above line in front of it and it works. MY QUESTION, how do I get ...Show All

• .NET Development Multiple Inserts into Sql Server.

  Is there any way to insert multiple rows into sql server table in single query or single round trip to the server Thanks. Yes...as no one has mentioned, use a cursor: USE pubs GO DECLARE get_price CURSOR FOR SELECT price FROM titles OPEN get_price FETCH NEXT FROM get_price WHILE @@FETCH_STATUS = 0 FETCH NEXT FROM get_price CLOSE get_price DEALLOCATE get_price Adamus ...Show All

• Visual Basic MultiSelect List Boxes

  I have created a form with three multi-select list boxes and hidden  boxes to house the selections. I would like help with code that would allow me to sum each hidden box then multiply the sums by each other to get an answer when the "calculate" button is clicked Here's an example with 2 listboxes with objects loaded into each of them.   When you click the button it will calculate the total of all the selected values in both listboxes. If you have databound items then you could total up the .SelectedValue properties. Hope this helps.   Public Class Form1     Pri ...Show All

• Visual Studio MSDN Library - Empty Content Pane (VS NET 2003 integrated)

  Problem: Msdn library document explorer opens but the content pane is empty or the content pane don’t display anyting about VS 2005 documentation (other topics such SQL Server 2005 are displaied) if opened from within VS 2005. Context: I have installed MSDN Library for VS 2005 on a Network share in wich System and Me have Full Control permissions. Tanks for any help Jony Hello, I have the same problem , MSDN opens with all panes empty. MSDN version is january 2005 , and is integrated with Visual Studio NET 2003. The operating system is Windows XP Professional with Service Pack 2. MS ...Show All

• Visual FoxPro Need help on a small open table code

  Hi, I m trying to make a general opentable function that I will use with all my apps in the future. Now I need someone to explain to me a few things to see things more clear. Here is my code: function OPENTABLE(TABLENAME)  LOCAL TABLETOOPEN *Ok this is just a full path I make for the dbf file. I do not know if it the right way.what it gives is  eg. c:\program files\my app\data\mytable.dbf  TABLETOOPEN=TOSTRING(checkpathforslash(GETCONFIGVALUE("DBF_PATH"),.t.))+TOSTRING(RTRIM(LTRIM(TABLENAME)))   IF !USED(TABLETOOPEN)   USE (TABLETOOPEN) IN 0 SHARED    RETURN .t.   ELSE    RETUR ...Show All

• SQL Server how to do equivalent of an outer join

  In the db, I have two tables - testcases and testresults. Test results have a field called testcaseid that corresponds to the id field in the testcases table. Not all test cases have results in the testresults table. Tests results have a field called "resultvalue" that can be "pass" or "fail". Test cases have a field called "area" that categories the feature the case belongs to. I want a pivot that shows, per area, per test case, how many failing results, how many passing results, or if the case does not have any results. I am used to doing this with an outer join in SQL. I cannot figure out how ...Show All

• .NET Development Code when called from procedures but not when called from button events!

  I have what I consider a weird problem.   I have two procedures, <scrsave> and <scrcopy>.   They run perfectly when I call then from button events as I did during debugging.   Now when I try the same procedures by calling them from code rather than button events they seem to not work.   The first saves a screen shot to a picture box while the second copies a portion of the screen shot to another picture box.   I can call the first from the form load event but that is the only code call I can make to either procedure.   The second picture box is visible on my form and when I run the code I can ...Show All

• Visual Basic StreamReader

  Hello, I’m trying to create a program will supply information for variables from a text file, so that as the possibilities change, a simple text file will need to be amended, rather than rewriting the original code. I am reading about FileStream and StreamReader, which seem like just the ticket. For instance, if I wanted to populate a TextBox with items I wrote in a text file, such as: Tom Mike Jim Jean I threw together a sub like this: ------------------------------ Private Sub Button6_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click Dim objF ...Show All

• Visual Basic Starting phase 2, need some advice

  Greetings, I am a relative beginner with programming (took a class six years ago, don’t remember much), and I am delving into a “file managing” program for my family’s business. Today I finished phase 1 (of 3). Before I get started on phase 2, I could use some advice. In our business, we receive files (from our clients), each in their own distinct folder, uploaded to our FTP server, located in our office. Each client has their own (password protected) space on the server, and they could upload most any time of the day or night. Phase 2 of my programming venture is to have my software “sweep” each clients designated f ...Show All

• SQL Server SQL Server 2005 Success Audits

  Hello: I know several folks have already posted this issue and resolution along with it in this forum but none of that worked for me. When I start SQL 2005 management studio on my client machine and as soon as I connect to my development server, it creates success audit logs in Eventviewer/Security with events 538, 540 and 576 repetively every few seconds until I close my connection to deevelopment server from SQL Management Studio. I had the same problem when I had SQL2000 on the same server and I was able to resolve it by unchecking "Server state polling" checkbox under tools/options in SQL 2000 Enterprise manager. Ca ...Show All

• Visual Studio Tools for Office Deploying VSTO Word Project: could not find or load customization assembly

  Hello! I developed a custom task pane with VSTO for a Word2003 report and now I would like to enable access for my clients to this document. I copied the document to a server folder in my intranet and tried opening it, but I got the following error:: "The customization assembly could not be found or could not be loaded" "The customization does not have the required permissions to execute." Therefore, I need to grant access to a server folder where the document and the assembly will be located. I checked http://msdn2.microsoft.com/library/k64zb6we(en-us,vs.80).aspx and followed the "How to: Grant Permissions to Folders and Assemblies" pr ...Show All