Daniel Mesias's Q&A profile

• .NET Development Go Live

  I am wrapping up developing an ASP .Net application with the GoLive license.  Choosing ASP .Net 2.0 was an error in this case. The databinding in ASP .Net is significantly harder to work with for anything sufficiently complicated.  Its great for binding to single tables and modifying reference data, but you end up working around the formview when doing anything complicated.  Figuring out how to do this took a little while.  There is no option for doing the databinding the old way, at least not with the designers, so you basically have to figure ways around the form databinding.  Ultimately this made the app ...Show All

• SQL Server Upgrade Advisor Analysis Wizard Error

  Hi, Analysis Wizard Error: "SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor." Microsoft SQL Server 2005 Upgrade Advisor 9.00.2016.00 Microsoft SQL Server 2005 Upgrade Advisor Analysis Wizard 9.00.2016.00 Microsoft.SqlServer.AnalysisServices.UpgradeAdvisor.dll 9.00.2016.00 Microsoft.SqlServer.BestPracticesAnalyzer.UpgradeAdvisor.dll 9.00.2016.00 Microsoft.SqlServer.DTS.UpgradeAdvisor.dll 9.00.2016.00 Microsoft.SqlServer.NotificationServices.UpgradeAdvisor.dll 9.00.2016.00 Mi ...Show All

• .NET Development client side datatable select

  Hello, Is there a way to execute sql against a client side datatable object I have a client side datatable object (that was initially populated from backend sql server table) that contains CustId, StateId, CustTypeId. Is there a way to get a list of unique CustIds contained in my client side datatable object - in other words is there something I can do CLIENT SIDE that would equate with select distinct CustId from MyClientSideDatatableObject   Thanks for your help ..... gtr That all depends on what you mean my client - Windows, ASP.NET If you're referring to Windows, and the obj ...Show All

• SQL Server SSIS Programming Examples

  I have been creating SSIS packages programmatically and have run into somewhat of a dead end. I have found the examples provided with the SQL 2005 install very helpful, but they only cover setting up three tasks: Sort task, OleDB Source and a Flat File Destination. Does anyone have any examples or knows of examples of using the Merge Join task and the Conditional Split task I'm doing it all programmatically and so far I'm having trouble finding much in the way of documentation or examples. Any help would be great! Thanks, Mark I have been building packages programmatically, too. Sorry, b ...Show All

• SQL Server Problem installing SQL Server 2005 Express with Advance Services CTP

  Hi, I was unable to install the CTP version of SS Express Edition SP1 with Advance Services. The installation failed with the following error message: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. ------------------------------ However, I was able to install and run t ...Show All

• SQL Server adding a stored proc to a publication

  Hi I created a publication (merge anonymous via Web) - the subscriber already had the data, so there was no need to to initialize data and schema. The problem is when it comes to adding a new stored proc to the publication. I create the proc, add it as an article to the publication and recreate the snapshot ok, but then the synchronisation fails. I  presume this is because the stored proc does not exist at the subscriber. I bet it would work if I had initialized the schema and data, but due to the size of the data this is not practical. If I manually create the proc at the subscriber then it works fine - but this defeats the p ...Show All

• Software Development for Windows Vista Moving unstructured pieces of "work" in a workflow.

  In WF terms, what is the preferred method of attaching, persisting, and working with unstructured objects such as PDFs, image files, and objects that do not fit very well in a table or row I see basically how to work with messages and flow logic but would like someone to point me in the right direction for a discussion on working with unstructured data and large binary files that require processing, approval, etc.. In the past, it has simply been a pointer (\\server\share\queue1\myimage.jpg) to a file. I would guess that SharePoint would be overkill for this DeBug M approach has been the same as other ...Show All

• .NET Development FtpWebRequest

  .NET Framework 2.0 c#   I need to access a FTP Server. I'm using FTPWebRequest as described in visual studio 2005 documentation. Everything works fine except the following: 1) I dont know how to change de current working directory on the server to the parent directory 2) Why cant I do this, or why doesn't work In Internet explorer works! 3) how can I send some FTP low levels commands to the server using .net 2.0 ftp api. <some code...for FtpWebRequest> FtpWebRequest ....Create(" ftp://192.168.1.4/../ret "); thanks Jose Cruz You should set the Credentials property of FtpWebReq ...Show All

• Visual Studio Help, uninstalling beta 2

  i uninstalled vs2005 beta2, but unfortunately in the wrong order. now, the device emulator 1.0 beta 2 installed, but it is stuck. I can't uninstall it because it asks for an msi file. this file is on the beta 2 dvd, which I don't have anymore. could someone send me this msi file its in the \vs\arm folder on the beta 2 dvd thanks Try running msiinv.exe to get the product code. Then run msiexec /x {product code} That should remove it. You can get msiinv.exe from my blog: http://blogs.msdn.com/quanto/archive/2005/06/30/434388.aspx ...Show All

• .NET Development Transfering pointers to ActiveX from c# code

  Hi, I want to transfer pointer from managed code (C#) to unmanaged code. this pointer points to a struct I want to use. The Interop mechanism does not allow me to transfer a pointer but only reference to objects, which is no good for me. Can anyone please help Yaniv. Most of the time, you can use the IntPtr managed type for this. Make sure that you have applied any neccessary attributes to your managed struct to allow proper marshalling. If you need some specific help, you'll need to provide source code and let me know what ActiveX you are trying to call. ...Show All

• Visual Basic Visual Basic 2.0

  Greetings. I use Visual Basic 2.0 to teach my kids a bit of programming. I do have Visual Studio Express - but it won't run on all my school PC's - while VisBas2 is small and quick!! BUT it doesn't have any help files . . . . I want to keep showing these kids good coding but I haven't found anything as small and quick as VisBas2 . . . . with helpfiles! Any and all suggestions gratefully accepted! Cheers, David If VB Express is too big for ya (1.3Gb w/ help files) there is a non-microsoft product out there called KPL (kid's programming language): best off all - IT's FREE! http://www.kid ...Show All

• Visual Basic Displaying data from SQL Server stored procedure

  I have a practice app (windows form) in VB 2005 to help me learn the language. I have a data source connection to a SQL Server database that includes a stored proc ( usp_CrimRecTest ). It requires one parameter. I am attempting to retrieve first and last name based on info entered by the user and concatenated into an ID#. I created the data connection using a wizard and added it to the form by drag and drop. I set the databinding text and tag properties for the name fields to the corresponding name fields in the dataset. I have a button to get the name with this code behind it: Private Sub btnGetName_Click( ByVal sen ...Show All

• Visual Studio Tools for Office Why does the ContextSwitchDeadlock happens?

  I got following error in a very basic VSTO Excel Workbook project. My method responds to a hyperlink, sets some integer values in a 10x10 cells array; and then user rng.Find() to find a specific string. However, the last part is when the while loop continues trying to get the next string with rng.FindNext(foundRange). The strings are found, but then Excel does not return from it (it takes all my CPU time); and finally, I got this error. ContextSwitchDeadlock was detected Message: The CLR has been unable to transition from COM context 0x159bc0 to COM context 0x1598e0 for 60 seconds. The thread that owns the destination context/apartment is ...Show All

• Windows Forms passing values from form1 to an instance of form2.

  My application has two forms.  Form1 has a control array of buttons which i have created in another class.  The buttons on form1 open up multiple instances of form2, depending on the button number that is pressed.  Eg button 1 opens up an instance of form2 that has a tag value of 2 and text of 2 aswell.  The buttons represent t ...Show All

• Smart Device Development Making bluetooth and GPRS communication in Pocket PC

  Hi all, I'm trying to make bluetooth and GPRS communication in a Pocket PC. I defined the connections in port COM4 (IN)+COM5(OUT). The connections for external devices, one with bluetooth connection and another with GPRS connection. When I build an application to talk with the two devices it connected the bluetooth one but faild with the GPRS one. What can be the problem What is the right way to make the connections Please help... Hi, GPRS may be using on of the COM ports you've specified.  Try changing the COM ports for Bluetooth to something different and see if that does the trick. -Anil. ...Show All