Andre de Castro's Q&A profile

• SQL Server SQL Server 2005 Express remote access?

  I am currently using a Microsoft Access (MDB) for my application. But I am looking at allowing other users on the network access the same database -- I know a Microsoft Access database is not the best solutuon for this enviroment. I'd like to use SQL Server 2005 Express in this case. I am very fimilular with SQL Server 2000 Std/Ent editions. My question is, can I use the free SQL Server 2005 Express edition and allow remote users to connect to that database Or  is it supposed to only be used as a local database accessed by only the machine it's installed on   Thanks, Jason Hello,  I am in a similar ...Show All

• Visual Studio Adding code lines to a VS 2005 source code file

  I need to add some code lines to an existing source code file (.cs or .vb) in VS 2005. I'm writing a VSPackage that has to do this. Which is the better way to do this - I add code lines directly in the source file as text - I get the code dom graph and I add the code lines adding instruction statement to it and then serializing it again. - other... Any hints Thanks the code dom lets visual studio worry about language syntax and positioning, but doesn't do a good job of covering things that are different between languages or new in vs '05 (for example - i haven't found a way to use t ...Show All

• Visual C# Sending message to remote computer by MSMQ

  Hi all, I want to send a message by MessageQueue.Send(), but the Queue is in a remote computer. Is it possible, I'm a client in a network , I want to use MSMQ of another client in the network. Regards... Hello Aidy, Thats true, if I give the machineName\QueueName it should work. But when I try to do that I am getting the following error " A workgroup installation computer does not support the operation" Can you please help. regards Scienty protected void SendMessage( object sender, EventArgs e) { MessageQueue MyMessageQ; Message MyMessage; try { MyMessageQ = new MessageQueue("ServerName\NewMs ...Show All

• Visual Studio alternating table row colour

  Hi, the title says it all... how do I alternate the row colour using the Table control in an RDLC I'm using VS 2005. I can see the properties for the Detail row but there doesn't seem to be anything there to alternate colour. regards JOel Use this expression to alternate row colors in detail row on the color property =iif(RowNumber(Nothing) mod 2, "#e8e8c9", "White") ...Show All

• SQL Server SSIS Connection to Oracle view

  Hi I have a number of scripts that run against an oracle server to retreive data to manipulate before populating a sqlserver database. I am connecting using an Odbc connection and using the DataReader Source to read from the Oracle table. It all seems to work ok. When I have tried to extract data from an Oracle view in the same way it doesn't seem to work. The error message mentioned the PrimeOutput() method and error code 0xC02090F5. The view is very big so is it possible that the connection simply timed out Any ideas Thanks B Hai, I am getting error while using Odbc drivers inserting data i ...Show All

• Windows Forms BackgroundWorker IsRunning Property?

  I'm trying to use the BackgroundWorker class and wanted to find out if my instance was currently busy.  I was hoping for a IsRunning or similar type of property.  But none exists.  Using reflector I saw that a private field exists called isRunning.  It would be nice if this flag was made available to users in a property. -Robert ...Show All

• Visual Studio Team System Vssconverter migration on Dual Server setup question

  I have successfully run a  VSSConverter Analysis on the VSS branch I want to import into TFS. No when I try and run the VssConverter Migrate command, I'm getting the following error: Initializing... TF60022:  Unable to connect to Microsoft SQL Server. In the settings.xml I have specified the AppServer name when it asks for the TeamFoundationServer name in the 'Settings' section. Where do I need to specify the DataServer name VSSConverter requires either SQLExpress or SQL Server for migration. By default it looks for SQL Express which is installed with VS 2005 in default configuration. for overriding the default yo ...Show All

• SQL Server Lookup Transformation: How can I join tables in different databases

  I want to join tables that reside in different databases (same instance).  The Lookup object only lets me select from one data source.  Is there anyway to lookup using more than one data source   I can write a SQL query to lookup across databases. Is this a feature that is being added to future releases I appreciate your help -Marcus What about MS Access using DAO In DAO you use something like this. CDaoRecordset rset(&db); rset.Open(dbOpenSnapshot, SQLquery, dbReadOnly); This does not allow for binding to more than one database at the time. Therefore, how can you do a join query betwe ...Show All

• Visual Studio Team System Unable to connect to BIS service

  Hi When I try to connect to Team Foundation Server I receive an error message: Unable to connect to BIS service Cannot connect to domain <domain name>. Projects for <domain name> not retrieved. Can You help me Thanks Arthooix Thank you Buck for your answer. yes I am running as TFSSETUP account and i still cant find a solution to this problem. I was able to connect to the server before but not to the default website. now i cant connect to the server, i can access the default website but not the team foundation server website which is http://localhost:8080  because when i try to access th ...Show All

• Visual Basic CLR error: 80004005

  I am using Visual Studio 2005 on Windows Server 2003. All service packs are installed. I first had this problem when trying to distribute an application for testing so I then created a simple application to try and narrow down the problem but to no avail... I create a simple Windows Application that has a single form with a single button on it that, when clicked, shows a messagebox with the words 'Hello World'. I compile it and run it fine but when I install it on another PC I get the following error on startup: CLR error: 80004005. The PC it is compiled on is a Windows Server 2003 with all service packs installed. .NET framework ve ...Show All

• SQL Server Connection Reset by Remote Host Error

  I am running some pretty large reports and am running into a problem with executing the reports. We are executing the reports from an IIS ASP.NET thread, which makes a call to the reporting service web service using the published render method. It works for reports that are less than 2k pages, but larger reports run for 30 minutes and then stop. So why are they stopping  Is it the thread  IIS  Reporting services  This is the error I get back: The underlying connection was closed: Could not establish secure channel for SSL/TLS.   at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequ ...Show All

• Visual Studio Express Editions Setting the Version Information in the exe file

  I am currently using the express edition of Visual C++ 2005. Is there any way of setting the version number, description, company, etc. that appear in the Version tab of the properties dialog of the exe There doesn't appear to be a resource editor in the express edition. Is there an alternative or would I need to upgrade to the full Visual Studio to do this Mog0 Yes,That is the correct way. I did it but was not getting the group name. I found the following sol. In .NET this is the AssemblyTitle. If you already have run the executable, then modify the EXE will not modify the group name. That's because ...Show All

• .NET Development connection to access db

  HI people, i have visual studio B2. i try to connect to a access data base with control bidingsource but after i select witch table i want i’ve get this error: "Some updating commands could not be generatied automatically. The error message was: ERROR [HYC00] [Microsoft] [ODBC Access Driver] Optional Feature not implemented" Any sugestions Thanks Yupypt I think you have problem with "UPDATE Qurey". You have to be carefull with updating the PK Field. Anyways, as we cant see any code and the Table specaification it would be hard to know why this getting this error. Please, post some related code a ...Show All

• SQL Server Checksum Transformation

  An updated version of the Checksum Transformation has finally made it out into the big wide world. Checksum Transformation ( http://www.sqlis.com/default.aspx 21 ) I have no real numbers on how unique it is, only my testing, which seemed rather good. It uses the .Net Hash function (C#), and the internals of that are not documented. Feel free to try it. Using an Int makes it easier to combine multiple columns, where as most other methods would produce a very large value, or just not be capable of handling multiple values. Darren ...Show All

• SQL Server DTSProperty.GetValue

  Hi,    Seems a pretty straightforward problem however, I have now spent some time on it. I have a DTSProperty object and want to get its value. I am able to get all the other attributes like Name, Type just fine. The GetValue method on the DTSProperty class takes a object and returns a object. If I want to get a value of the current property what do I pass to GetValue I have something like foreach ( DtsProperty property in controlFlow.Properties) {    string propName = property.Name;    //I want to do this     if(property.Get)       property.GetValue( ) // ...Show All