Matt Anderson's Q&A profile

• SQL Server Can't connect to the reports using Sybase

  We are new using RS at the office. We just installed it and it works just fine with the reports using SQL but it doesn't work with the ones using Sybase. I work developing software and i can do the deploy of the project, can see the preview reports, i even go to the server page and i see my reports there, it asks for the password and user name (as it should) but when i click on view report it starts showing the circle connecting to it but after a while it shows me this error: Error al procesar el informe. (rsProcessingAborted) Obtener ayuda en linea No se puede crear una conexion al origen de datos sicere. (rsErrorOpeningCon ...Show All

• Visual C++ How to Get SPY++ for desktop based application in vsts

  I am new to visual studio team system 2005 I want to install spy++ for windows application not remote spy I try hard but I do not reach to any result please help Info on getting the latest prerelease of VS2005 is at http://lab.msdn.microsoft.com/vs2005/get/ Note that for the RC builds of VSTS you'll have to be an MSDN subscriber. Thanks, -Ron ...Show All

• Windows Forms DataGrid Problem in Visual J#

  Hi, this is my problem. I have two datagrids, one gets populated with certain amounts of data from the database. Next what i want to do is have a button called "ADD" and when i click a row in the populated datagrid and press ADD I want it to populate the 2nd dataGrid with the selected row.  I have done similar stuff in VB.NET b ...Show All

• Microsoft ISV Community Center Forums ReadAll reading in first 254 characters only. Help

  I have been using this code for sometime under previous versions of MSWord. However, the ReadAll function does work properly in Word 2002 with VB 6.3. I try to read in all the text in a text file and it will only read in the first 254 characters. Any help will be greatly appreciated. The following is my code: Const ForReading = 1, TristateFalse = 0 Dim fs, f, ts ChangeFileOpenDirectory gTemp_Dir Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.getfile(gGMS_DataSource) If f.Size = 0 Then gsLetterText = "" Else Set ts = f.OpenAsTextStream(ForReading, TristateFalse) gsLetterText = t ...Show All

• Visual Studio Crystal 8.5 and VB6 runtime error

  Hi, I got two run-time errors when printing two different reports with subreport. The first error is: Run-time error '20544': Error in the File UNKNOWN.RPT: Access to report file denied. Another program may be using it. The second error is: Run-time error '20406': Unknown Subreport name Both report work fine but only fail to print in some cases and return the errors above. I am using Crystal Report 8.5 and Visual Basic 6.0. Can anyone tell me what is going on with the error Thanks ...Show All

• SQL Server jdbc driver getTables(String , String ,Sring ,String[] )can't get tables whose catalog is pure number

  i have a database named "1", then i want to get the tables which type is "TABLE" under this catalog but it can't be done. Check the kode: conn.setCatalog("\"1\""); DatabaseMetaData meta = conn.getMetaData(); ResultSet tables = meta.getTables( "\"1\"" , "dbo","ttt" , new String [] {"TABLE"}); if i change the last sentence to : ResultSet tables = meta.getTables( "1" , "dbo","ttt" , new String [] {"TABLE"}), it still can't be done. it work when "ResultSet tables = meta.getTables( null , "dbo&quo ...Show All

• .NET Development Itanium compiler error

  I am porting a C# project to 64 bit.  I successfully compiled in Whidbey using AnyCpu setting and ran the test client.  However, after I changed the compiler setting to Itanium and copied settings from AnyCpu, I got this error upon compiling: ------------------------------------------------------------------------------- C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\Microsoft.Common.targets(1500,9): error MSB3551: Unable to load referenced assembly "C:\Projects\...\bin\Itanium\Debug\MyClass.dll". Could not load file or assembly 'C:\Projects\...\bin\Itanium\Debug\MyClass.dll' or one of its dependencies. The system cannot f ...Show All

• Visual Basic how to declare a var in one form that can be shared from others?

  Hi, I need little help on how to declare a var in one form that can be shared from others. I have this code in my form1, but my form2 cannot access the variable connString. Did I declare the scope wrong or it was on the wrong place Thanks! Public Class myForm1 Public connString as string ="Data Source=xyz..." Private Sub Button1_Click(ByVal ...) Dim frm2 As New myForm1 frm2.Show() End Sub End Class I got "Name 'connString' is not decleared." Build error. The public connString is only valid inside of the form. A public variable inside a module wil ...Show All

• Visual C# Deep equivalence testing?

  Hi, hope you can help. If I create a class with some properties and fields and then instantiate two objects based on this class, I need some way of testing for equivalence. Since the == operator works on reference equivalence, this will not work for me. I need to do a field-by-field/property-by-property equivalence check. Ideally, this would be a deep test, recursively looking at sub-objects too. How is the best way to achieve this Thanks in advance, Sigol. The best way to do that is by overriding the Equals method for you class. You can overload the == operator. An example for overridi ...Show All

• Visual C# How to minus two days from now

  Dear All, I would like to know how to get the date for past two days in yyyymmdd format. Take for example , today is 20060201, how can I return two days date as 20060130 Please help Try the following: DateTime now = DateTime.Now; DateTime twoDaysAgo = now.AddDays(-2); Console.WriteLine(twoDaysAgo.ToString("yyyyMMdd")); ...Show All

• Visual Studio Express Editions 'Package failed to load' errors on first start of release version

  I got this error when starting the ide. I got the same errormessage several times for different packages when trying to click on any of the links in the workspace. The program also crashed on exit. I've tried the beta version earlier, but it didn't work correctly either (header files seemed to be missing from the installation). I've uninstalled all the beta stuff before installing the release version. my setup is win xp, english home edition, SP 2 with latest updates amd xp 2500+ nforce2 motherboard plenty of diskspace left, and 1 gb ram the installation goes fine with no warnings, but it obviously isn't installed correctly. I've been using ...Show All

• SQL Server DataTransfer Error

  I have written following lines of code, but when TransferData() method is called, it generates error "Property LoginSecure cannot be changed or read after a connection string has been set."  Can anybody help me Thanks in advance.... Code: //1. Create Transfer Object Transfer transObj = new Transfer (); //transObj=new Transfer(server.Databases[fromdatabasename]); transObj.DestinationLoginSecure = false ; transObj.DestinationLogin = "sa"; transObj.DestinationPassword = "test"; //Set Destination Server //Build a "serverConnection" with the information of the "sqlConnection" destS ...Show All

• Visual Basic Unable to find reference in VB.net 2005

  I have an app that that I have copied from a working example. The example has a reference to Microsoft.VisualBasic.Compatibility which evidently contains a type VB6. When I look in the old app I see the code refers to Microsoft.VisualBasic.Compatibility. The new app will not compile telling me that Error 1 Name 'VB6' is not declared... I have a reference to Microsoft.VisualBasic.Compatibility in the new project which I have added and deleted a few times to no avail. (Also tried cleaning and rebuilding the project) Any ideas Is there something else I need to do to make the reference active BTW I'm using someones else code that I do ...Show All

• Visual Studio Team System Team Suite 2005 + SQL SERVER 2005 + TEAM FOUNDATION SERVER on one machine?

  I have one spare computer with Windows Server 2003 Enterprise installed.  I would like to have both the Application Tier and Database Tier on this machine.  Is this possible   Can VS.NET Team Suite 2005 Beta 2 exist on the same machine as SQL Server 2005 Beta 2 Team Foundation Beta 2 I have not been able to successfully install all of these products on one machine.  I read somewhere that with Beta 1 the application tier and database tier must be separate, but is this still true for Beta 2 Any help is appreciated. This scenario is completely supported in Beta 2 if you use the April CTP of ...Show All

• .NET Development Syntax error in UPDATE statement

   Syntax error in UPDATE statement Hi I have a project managing user accounts, After the user entered his details a password is generated and updated to his record. Whole project worked perfect except when it comes to updating a record. Pasted below is thesection which is giving me troubel. The same SQL statement was pasted run from Access and updated the row perfectly. and when run from ASP.net [UPDATE Users SET Password = '63780' WHERE IDcard = '888M'] the following OleDbException was thrown:   Message "Syntax error in UPDATE statement."  ErrorCode -2147217900 Integer The code is pasted below. Can someone ...Show All