Hugo Sanchez's Q&A profile

• SQL Server The Process Could Not deliver the Snapshot to the Subscriber, using WebSynchronisation 2 server setup

  I am Having trouble trying to set up SQL Server Replication Utilising Web Synchronisation Where the IIS(Web Server) is on a separate machine to the SQL Server(Publisher). I am using MSDE as the SQL Server Box, however even when I used SQLServer2000, or SQLServer2005 I have had no joy with the 2 separate Servers setup. If I have the one server then I have no problems (i.e. One Server Setup) Server A: Windows 2000, with MSDE installed enabled for Merge replication, and has a Publication set up. IIS Web Page Setup for Synchronisation My SQL Server 2005 Mobile device syncs via the web page on ServerA Fine, no problems at all. The Trouble is when I am trying to utilise SQL Server Replication as follows. (i.e. 2 Server Setup) ...Show All

• SQL Server Force to complete query, ignore errors

  Hi, I have a big table and want to make a plausibility check of it’s data. Problem is, that my query stops, if there is an unexpected datatype in one of the rows. But that is it, what i want to filter out of my table with that query and save the result as new correct table. How can i write a parameter to my query SQL Code, that if a error occurs, the querry resumes and the error line will not displayed in my final querry overview In my books and on the net, i don’t found something to this theme ;-(. Thx in advance. Hm, what u mean with avoid inserting bad rows The bad rows are allready in my base txt-Files. But they are too large, to check and delete there every single line with the hand. I don’t ...Show All

• Smart Device Development Upload/download via http (method post)

  Hi, need help! I want upload files through http (method post) from my smartphone application (on server have an upload.aspx where receive the binary file and save it). I need to do the same with download (request download.aspx where I build the file, read it and make a response.write and catch it on my smartphone application) a little part from file Download.aspx [...] //code where I connect to Oracle DB to get information for download file! [...] Response.ContentType= "application\\octet-stream"; FileStream downloadFile = new FileStream(filename, FileMode.Open); downloadFile.Close(); Response.WriteFile(filename); Response.Flush(); HttpContext.Current.ApplicationInstance.CompleteRequest(); ...Show All

• .NET Development Updating dBase tables

  How to update dBase (.dbf) tables I can read them with Odbc or OleDB but CommandBuilder can't create UPD, INS and DEL command based on 'SELECT * FROM dbf_table_name'. Exception is: "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information." Yes, with PK column I can update but in most cases I don't have PK col or don't know where is it. How MS_Access change dbf files when I link them There must be some way. Please ignore this post. It is a test post. The forums team is testing Alerts. This post will be deleted in a day or so. Thanks Jana Carter Forums Program Manager ...Show All

• Visual Studio ReportViewer assembly binding fails

  I have a client who is using a web hoster who has not installed the ReportViewer control so the ReportViewer assemblies are not found. Can I put the assemblies in the webapp\Bin directory and reference them. Microsoft.ReportViewer.Common.dll Microsoft.ReportViewer.WebForms.dll Microsoft.ReportViewer.WebForms.xml thanks No, you do not need to change anything in your aspx page. I don't know the answer to your second question. I think your client will have to ask their provider whether their application can run in full trust. -Albert ...Show All

• Visual Studio Program hangs when preview report

  Our Company is using 2003 Standard Edition, which is a domain controller. When the server start up for a period. client using terminal service remote into the server. They are using an application which will print the report on "Remote Session".That means the database and the cilent program are also store in the server. Sometimes, when the cilent try to preview the report, it seems normal. But after a while, some of the cilent using the application to preview the same report, the crystal report will got freeze , and the program will hangs. It need to terminate the program and start again.When same user print same report, it still hangs. But when the server restarted, user can preview the report and print it normally.. D ...Show All

• Visual C++ Vista "for loop" problem

  In code that runs correctly in XP, I have a for loop. 1. for (int nIndex = 0; nIndex < 256; nIndex++) { 2. array[nIndex] = something; ... In Vista, at line 2, nIndex = -856238756375 or something like that, ie. uninitialized. Obviously, this causes a crash. Is this a known bug I installed Build 5728 yesterday and cannot reproduce the problem. I did have problems with crashes related to USB driver. In my VM, I removed the USB port and now it seems pretty stable. ...Show All

• SQL Server Is there a load event or run event?

  Is there a load event or report run event for a report that can be accessed I need to have my report jump to a certain url whenever it is run but I cannot use the jump to url because that has to be clicked. I need this to occur automatically. Any suggestions There is an OnInit event that fires each time the report is run. The method can be used in custom code like this, Protected Overrides Sub OnInit() ' do something End Sub Ian ...Show All

• Visual C# About Write App.config

  I use sample code with article Read/Write App.Config File with .NET 2.0 listed below         // Open App.Config of executable         System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);         // Add an Application Setting.         config.AppSettings.Settings.Add("ModificationDate", DateTime.Now.ToLongTimeString() + " ");         // Save the changes in App.config file.         config.Save(ConfigurationSaveMode.Modified); but When I run the programme, I do not see any ch ...Show All

• Visual Studio Team System changing Environment Variable via postbuild event

  dear all i need to access an environment variable via build and change its value - any idea how do i do that Thanks alot Ron Ron, MSBuild does not have a built-in task for modifying environment variables. However, you can do it via a custom task (which has already been written for you). Check out the following links for more information: http://sstjean.blogspot.com/2006_08_01_sstjean_archive.html http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=669082&SiteID=1 Hope this helps. ...Show All

• Visual Studio Express Editions How to make Project Wizard/Templates?

  Hi; I want to make a Project Wizard/Template to eliminate the need to hand edit configuration settings. If someone has worked with Sharp Develop should know it has a template for DirectX Project. How can I make a template wizard like that for Visual C# Express 2005 Thanks you very much. Have your friend copy the .zip file into the correct folder. Check this MSDN article for a description. ...Show All

• .NET Development Net 2.0 install errors

  I have been trying to install the .Net Framework 2.0 on a windows 2000 computer, I keep getting the following error at various points during the install. "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2905." I have used this install on other computers and it worked fine. I have also downloaded the dotnetfx.exe again, only to get this error again. What is a 2905 What can I do to get this installed Hi, Do you have win 2000 sp4 installed on you r box If not please install win2000 sp4 and then try install of .Net Framework 2.0. Thanks, Manisha. ...Show All

• Smart Device Development How to Merge *.reg File From Code

  Hello, Reg files usually are merged automatically during Cold Boot. Is there a way of merging a reg file from code (Something different than reading the file, parsing it and manually calling Reg functions from API.) The only thing I was able to find out about the issue was information about existance of RegMerge.dll. Thanks, Artur There's no registry editor on most Pocket PC or SP devices. Some vertical market devices (which I suspect you're working with) might have special capabilities/applications from device vendor not available in general. For example, this "Application" folder is specific to Symbol devices as far as I remember. As to "merger", "merge" mig ...Show All

• Visual C# Exposing to COM not working

  I have excluded most of the code in the class because it is, complicated, not relevent to my question, it works fine, and there's too much. When i refrence the generated dll in C# it works fine, BUT is says its a .NET Assembly , even though I am trying to make a COM. When I try to load the dll in Visual Basic it doesnt work; The generated .tlb does not work in either. If any one could tell me what im doing wrong I would appreciate it   using System; using System.Collections.Generic; using System.Text; using System.Windows.Forms; using System.Runtime.InteropServices; namespace EButtons {     [ InterfaceType ( ComInterfaceType .InterfaceIsIDispatch)]     ...Show All

• Visual Studio Team System Problem with displaying "Work Items" for a <PROJECT> in Team Explorer

  Our TFS lives in the folowing configuration: Server OS: Windows 2003 Server R2 Database Server: MSSQL 2005 + SP1 Some time later, after we had started using the TFS we got a problem with displaying of content of WorkItems in our <Project>. The problem appeared for some users only, but including Administrator who had installed TFS. When they try to expand WorkItems Team Explorer shows "(working...)" and hangs in it. At the same time "sqlservr.exe" process  on the ServerComp gets 100% of CPU loading and stays in this state until TFSAppPool will be recycled. Can anyone help to workaround this problem Also, how many projects are there on the server, and did you create a custom proces ...Show All