SimonS_'s Q&A profile

• Visual Basic Index out of Bounds??/

  hey people, I have the following code for my windows form, however I keep getting out of bounds array exception..where is this exception coming from Private Sub Bt_Procurar_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles Bt_Procurar.Click Dim frm_erro As Frm_Config Dim configFile As File Dim fWrite As StreamWriter Dim fReader As StreamReader Try OpenFileDialog1.ShowDialog() OpenFileDialog1.OpenFile() Catch ex As Exception 'Error_Config.GetError(frm_erro) Throw ex End Try End Sub Hi, the error is probably caused by  OpenFileDialog1.OpenFile() line, when user presses cancel in th ...Show All

• Visual Studio 2008 (Pre-release) Memory Issues

  Hi everyone!!! I have develop a service the acts as a bussiness layer, I never noticed that it consumes a large memory amount, but I was testing with a little concurrent client number (12) not too much, well 2 o 3 hours later I have seen one of my nightmares comes true: the service process grown up to 900MB!!! Yes belive me!! Well first at all I think: "I'm really a bad programmer and I'm not using well the Framework, let's review the code", I found 2 or 3 issues but nothing critical, then I tried again and guess what The same result, I was investgating the memory issues debugging with windbg and I noticed that no a lot of objects where maked to get collected, specially wcf related objects, and well the GC is working but real ...Show All

• SQL Server Package fails but single Task ends with success

  Hi I've created a simple package that contains only one task that is an execute sql task. When I run only this single task from Business Intelligence development studio it runs successfully. But when I run the whole package (also from Business intlligence studio), the package fails. The data source I access is ODBC. I'm sure the real reason for the error is the bad ODBC driver of the data source but this can't be changed. So I need to know what is different from running only a task in a package to running the whole package. If I knew that I might be able to adjust some setting and make it work. Any help welcome. I had a similar probem the other day. all the individual steps would run ok in visual ...Show All

• .NET Development SQL Server 7 & vs2005 pro

  When using ASP.net, and a gridview, it does not have SQL Server 7 available as one of the database options (only 2000 or 2005). Several tutorials I am working with show it as being available. Did I botch the installation or is there a setting I missed Thanks, Silver I need to explain better I guess. I have VS 2005 Pro with SQL 2005 Developer Edition. My company still uses SQL Server 7 for all their database stuff (they still have alot of vb6 code that is active). I am trying to setup a dataconnection that will connect to it from ASP to populate a gridview. It is not part of my dataconnections list (when I choose sql Server only 2000 & 2005 come up as supported), but I have seen it in other tutor ...Show All

• Visual Studio Reportviewer print dialog problem

  My .NET version 2 application creates reports by calling a method from a dll (which I also wrote) which displays a form containing a user control which in turn contains a ReportViewer. I set the viewer's .ReportPath, .BindingSource, and .DataSource properties and call the .RefreshReport method. The viewer displays the report correctly. When I click the viewer's Print button, the Print dialog correctly appears, but I have to click the dialog's Print button twice to actually send the report to the printer. What could be causing this This should not be the case. I have contacted one of our support escalation engineers about this and he will contact you directly. I just need either your support case numb ...Show All

• SQL Server sqlxmlbulkload problem with schema

  <xsd:element name="current-conditions" sql:is-constant="1"> <xsd:complexType> <xsd:sequence> <xsd:element name="date" type="xsd:string" sql:mapped="false"/> <xsd:element name="time" type="xsd:string" sql:mapped="false"/> <xsd:element name="reporting-station" sql:relation="weather"> <xsd:complexType> <xsd:sequence> <xsd:element name="city" type="xsd:string" sql:mapped="true"/> <xsd:element name="state" type="xsd:string" sql:mapped="true"/> <xsd:element name="temperature" type="xsd:str ...Show All

• SQL Server how to extract username and password from ftp connection manager?

  Hi, I would like to know how to programmatically extract username and password from an ftp connection manager. Thanks. I got this code but I want to get the values of every available property in a connection manager. Please help. Thanks! For Each connMgr In myConns Dim connProperties As DtsProperties = connMgr.Properties Dim connProp As DtsProperty For Each connProp In connProperties MsgBox(connProp.Name) Next Next this is where i got the code. I do not know how to extract the value from the properties. there is no ".value" from intellisense. ...Show All

• SQL Server Error on Attaching Database

  When attaching a database that was detached from another SQL Server instance. I got the error message below: Error 602: Could not find row in sysindexes for database ID 25, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.  i am using SQL Server 2000 Thanks and Regards It sounds like you mainly want to perform maintenance or troubleshoot your sql server 2005 database and then send it back to your webhost that will run in it production.  With this in mind I would recommend the following options: 1. Download the SQL Server 2005 Express Edition with Advanced Tools.   It includes the sql management studio which you can use to attach, detach, and manipulate your sql 2005 databases.  ...Show All

• Windows Forms Using Spy++ to Assist with Automated Testing

  Hello: I can't tell you how glad I am to know that there are so many Spy++ enthusiasts out there. I only discovered the tool last night, and thought it was truly awesome that the tool detected an app that I was debugging from VSTS (which is incredible, by the way). Anyway, I started the app, and intentionally caused an error, which in turn, launched a MessageBox. Spy++ was able to detect both my app, and the error message (MessageBox). How can I now use information supplied by Spy++ to simulate clicking the OK button on the MessageBox Wish to do automated testing and I am pulling scenarios from a database, so that I can test numerous inputs at once. The messageboxes popup by design. I don't wish to suppress them ...Show All

• SQL Server Computed column formulae...2000 vs 2005

  My head hurts! I have a wicked database upgrade mechanism that works broadly like this: Master database schema is scanned into an object model then saved to an XML file. Sometime later...XML file is loaded back into object model and target database schema is scanned into another instance of this object model CompareSchemas routine takes both object models as input, compares them, and outputs a collection of Actions needed to bring the target in line with the master i.e. it works out all the DDL statements necessary to synchronize the database structure. My problem is that I need to have this working seamlessly between 2000 and 2005 - our master development is still in SQL Server 2000 and will be until all our customers ha ...Show All

• Visual C++ a++++;

  hi i hav this problem. int a; a++++; gives an error.. ' operator ' needs l-value but ++++a; compiles properly. plz help me... I hope you're not actually writing code this way! If you need to increment the value by two, just say "a+=2;". The difference between ++X and X++ is that in the former X is incremented before the evaluation of the rest of the line, while in the latter it's evaluated afterward. "++++a" is evaluated as "++(++a)". I'm not sure how "a++++" would be evaluated, and I suspect the compiler feels the same way. ...Show All

• Visual Studio Team System Do not call overridable methods in constructors

  In the sample code I am getting the above mentioned error. public abstract class Element { public abstract void SetBoundingRect(); } public abstract class LineBase : Element { public override void SetBoundingRect() { //Set the bounding rect here } } public class LineGeometry : LineBase { public LineGeometry() { this .SetBoundingRect(); //Error here } } public class LineToolpath : LineBase { public LineToolpath() { this .SetBoundingRect(); //Error here } } As you can see I am not calling any vir ...Show All

• SQL Server Live Webcast tomorrow Essential Team System for Database Developers

  Live Webcast tomorrow Essential Team System for Database Developers 1 PM Central time 12/28 https://www.clicktoattend.com/invitation.aspx code=112602 ...Show All

• Visual Studio 2008 (Pre-release) How should I use LINQ?

  Since LINQ is a new project I don't think this question has been asnwered anywhere yet - what will be an appropriate use of it, especially in multi-tiered environmnet What applications or scenarios will be especially benefitical for LINQ I played with BLINQ - very impressive. It would have been much harder to do this kind of app by pulling the data from SQL system catalog... Are there any examples like that Any architecture guidance coming up Thanks, -Stan LINQ is simply Language Integrated Query. The SQL stuff is just one (rather noticeable) application of it. It's intended to be applicable toward the problems developers face querying any data store, such as AD/LDAP, WMI, Regis ...Show All

• SQL Server How client program get the events?

  I know SQL 2005 notification service can send email, file, HTTP protocol to inform the client program the events. 1) How to implement the HTTP solution My client program is Java or MFC. A sample is really appreciate. 2) If TCP socket could be listened for the events too Thanks a lot. I don't have or even know of an example where the end subscriber is a client application (although that is a commonly asked question in the forum/newsgroup). You'll need to create a custom delivery channel to provide this functionality. You may also want to check out Query Notifications, as that technology may also suit your needs. HTH... Joe ...Show All