l4ci's Q&A profile

• .NET Development Newbie-What is the proper way to handle special characters in XML?

  I'm having a problem with single quotes in my XML document. I have Xml that resembles something like below: < xml version="1.0" encoding="utf-8" > <root> <MyText>Text contain's a single quote</MyText> </root> This content resides in a file and when I extract the xml and pass it to a stored procedure, instead of the entire xml being sent to the stored procedure, it is being truncated because of the single quote in the word "contain's" and is causing the stored procedure to error out. What is the best way to handle this The xml above is being created via the XmlSerializer class. I ...Show All

• SQL Server SORTS: Change the temp sort file

  Hi, When I use the sort object multiple temporary files get generated in a temp folder below 'local settings' under my profile.   Where can I change this defualt location to a drive that has more space Could someone point me to documentation that explains how to modify the SQL statement on the advanced tab in 'Lookup Transform' sucessfully and how the Lookup actually works.  i.e does it just pull back the fields that you have selected or does it pull back the whole table   Thanks I believe it says it is on the dataflow task and that is where it is.  The setting is global for a ...Show All

• SQL Server Another SSIS Package Validation Question

  We are going to be running a package repeatedly 24/7. The same package against the same data store, filtered using a "stageFlag" so as not to read rows previously processed. We have various timing statistics and have yet to fine tune; but on the surface it appears that it takes approximately three minutes to validate and another three minutes to run. If we have no additional data on the second run it still takes three minutes to complete - to do nothing but skip rows already processed. Is it possible to set this up to run repeatedly without the validation on each iteration Any ideas as to how this would be accomplished would ...Show All

• Visual Studio 2008 (Pre-release) select in with many to many relationship

  I've an entity Profiles containing Tags with a many to many relationship. I want to return all profiles that contains at least a list of some tags e.g. all profiles containing tags with id=10 and tags with id=12 This is my method: public List < Profile > GetProfiles( List < int > tagIds) { List < Profile > profiles= new List < Profile >(); Query < Profile > q; q = from p in db.Profiles , t in db.ProfileTags where t.TagId==tagIds[0] select p; tagIds.Remove(tagIds[0]); int check; foreach ( Profile profile in q) { check=0; foreach ( int tagId ...Show All

• SQL Server Linked Server connection issue

  We have a SQL Server 2005 Enterprise Edition set up on Server 2003 Standard Edtion OS and one on Server 2003 OS Enterprise Edition. All of them have their Service Pack ones installed. On the 2005 on Standard 2003 OS I can get to linked ODBC connection servers with no problem. On the 2005 SQL Server on the Enterprise Edition I get Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "EAWARMBKUP". We are not sure whether or not this is caused by something on the OS or on the SQL SERVER software. Any help would be appreciated. Allow remote c ...Show All

• SQL Server Looking for some magic

  ... well, perhaps some sophistication. The setup: Server A publishes to server B via transactional replication. Server A is to be shut down while some electrical work is done. So we fail over to server B for a couple days. My underpowered brain says to shut down replication, possibly fail over well in advance of the power outage. Then, when the electrical work is done and server A is restarted: 1) stop work on server B, 2) copy the database on B to A (I suppose after deleting it from A), and 3) redoing the replication from scratch. Can anyone recommend a better process I am very gratefull for any enlightenment. ...Show All

• Visual Studio Team System Custom Exception causes "Not Authorized to View this page"

  Hi, I am having a problem throwing custom exceptions. Whenever my web application throws an unhandled custom exception it does something so that the next time I run the application I get a "You are not authorized to view this page" message. I have tried manipulating the Directory Security in the website property pages and on the physical directoreis themselves with no luck. It seems to work just fine if the exception thrown is a system exception, for example: Null Reference, but not if I create and throw a custom exception. Any help would be appreciated...... Thanx in advance. Hi T.J. I could not reproduce the problem on my mach ...Show All

• .NET Development HTML + TIME code.

  Hi, my name is Ozzie Garzon and I have a question on this piece of code. <t:MEDIA id="oMedia" timeAction="visibility" src="countlead.wmv" begin="indefinite"/> <BUTTON onclick="oMedia. beginElement ();">Start</BUTTON> <BUTTON onclick="oMedia. endElement ();">Stop</BUTTON> <BUTTON onclick="oMedia. pauseElement ();">Pause</BUTTON> <BUTTON onclick="oMedia. resumeElement ();">Resume</BUTTON> This code works when I use it with Visual Studio 2003. When I use this code on Geocities free we ...Show All

• .NET Development How to use Configuration.GetSection() and ConfigurationManager.OpenMappedExeConfiguration()

  Hi all, I want to access a custom section located in a different config file than the current default one and I managed to use ConfigurationManager.OpenMappedExeConfiguration() to retrieve a Configuration object for that config file after supplying it with a properly constructed ExeConfigurationFileMap object. From the Configuration object, I managed to use the Configuration.GetSection() to retrieve the correct custom section, which uses NameValueSectionHandler. But after that, I don't know how to obtain the data in the form of NameValueCollection. Can someone help If it is the default config file, I can simply use the (NameValueS ...Show All

• .NET Development Programatically embedding resources (a la self-extracting zip archive)

  Hi, first, I'm not sure if this is the most appropriate forum for my question, I did try to consider this but I'm just not sure, so I apologize upfront if it is not. I want to make a program with a feature similar to WinZip's ability to create a self-extracting archive, i.e. I want my program to generate an executable with embedded resources. The executable code in the assembly will always be the same, so I believe this is a matter of embedding resources programmatically. I've figured out that the Assembly Linker offers the functionality I need, but I am a little doutful about whether I can legally distribute this with my program. I'm ...Show All

• SQL Server Occasionally slow to connect to a sql2005 database

  Hi We have a VB app talking to SQL 2000 and SQL2005 databases. Most of our clients use SQL2000, but the new ones we are deploying with SQL2005 Sometimes the app is slow in establishing a connection to the database when it is SQL2005. The provider is sqloledb. We never get this delay in SQL2000. Sometimes it takes seconds to establish a connection - this is even the case when the app is on the same machine as the database. We are using SQL authentication - always with the same connect string. Any ideas thanks Bruce     Hi Any chance of a reply on this one Thanks ...Show All

• .NET Development .NET High Speed Timers - Precision/Accuracy

  There are 3 timer types in .NET (System.Windows.Forms.Timer, System.Timers.Timer and System.Threading.Timer) From the documentation the System.Windows.Forms.Timer timer interval precision is one-eighteenth of a second (55.55 milliseconds). http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbconlimitationsoftimercontrolsintervalproperty.asp I cannot find any details on the other timers precision/accuracy. I want to plot graphical data on a periodic basis - every 10 milliseconds. Will this be achievable with timers Which timer would be the best to use Would I have to change anything in the underlying PC archi ...Show All

• Visual C# large datasource causes slow datagrid response

  I create a datasource with one master table and 7 related tables. The form has 7 tabs with datagrids to display the tables. There is also detail fields on the bottom half of the tabs. We followed the walkthrough logic of dragging the datasource relations onto the grid and form. We added parameters to the dbconnections to minimize the data fetched. It seems to be running very slow. Just moving the cursor to another row on the datagrid has a noticable delay ( apx 1 sec ). We removed some of the detail fields ( that we 'Clicked and dragged' off the dataset and it seems to improve the speed. But that isn't really a solution since we need to disp ...Show All

• Windows Live Developer Forums Problem creating a map centred on London

  If I create a map centred on longitude 0 (to show, for example, London) then it appears as the entire earth, totally zoomed out: map.LoadMap(new VELatLong(51,0)); Yes very odd, doesn't seem to like 51,0, try 51,0.0000000001 Cheers Mike ...Show All

• SQL Server Use RS interface to pass variables to vbscipt/exe

  I'm pretty new to RS and .NET, and have recently implemented an instance to provide self-service reporting to users (obviously).  I've built a nice library of reports using the development environment in .NET 2003, but I've got some vb6/Excel-based reports that are a bit much for the RS report builder format.  I would like to give users the ability to run these reports using the RS interface, however. I picture the user selecting the report within RS, entering the variables, and RS passing these variables to some code which then builds the report in Excel, and offers itself up to the user to either open or save, kind ...Show All