gareth andrew lewis's Q&A profile
SQL Server How to save the " character in a CDATA in SQL SErver 2005
Dear Pals, I know that special characters, such as <, in a cdata section will be converted properly into entity reference before getting stored in a xml field in the database. However, it seems that the character " (quotation) does not get converted to ". This would result in problems when the XML document is fetched. For example, a xml document like: <A><![CDATA[THis is "John"]]></A> when stored, it becomes <A>THis is "John"</A> This of course causes problem for XML parsers. IS there any cure for that problem. Thanks Feng-Hsu Wang Feng-Hsu, According to the XML spec: The ampersand character (&) and the left angle ...Show All
SQL Server Access emulator device from Management Studio
Hi, i know i have the chance to access my mobile device (physical or emulator) from Management Studio. I went to Connect Object Explorer, server type Sql Server Mobile but i can’t connect to my emulator and i can’t see any way to connect to a physical device either. How can i do this The only thing i can do is create a sql server mobile database (.sdf). Thanks SP ...Show All
Windows Forms datetimepicker with customized format
i have a datetimepicker with customized format dd/MM/yyyy HH:mm . Is it possible to disable the dropdown calendar so that user can only type in the value ...Show All
Visual Studio Free May 06 library and VS6
I was greatly impressed with the free version of the MSDN library. One thing I noted in the download page was: By default, it does not integrate with Visual Studio 6 Which means it can. Ages ago I lost my MSDN Library for Visual Studio 6 Pro cd and now I have lost all access to help which is important because I quite frankly prefer COM to NET, I find it more lighter and faster. How do you integrate it No there isnin't, all of the old data is probably removed from the disks. To get one that does you will have to try and find a source that you can buy, You could also check with MS Support if they could get a copy together for you (As you have purchased a copy). But if you do use com rather then ...Show All
Visual C++ include XML file into a class at compile time
Hi All, I have an XML file that must be included (or linked) into a class object at compile/link time. Basically, we cannot send this file along with the product and read the data from the file into memory at runtime. My question is, is there a way to tell the compiler to read the content of the file into a CString, or a string buffer at compile time My project file is a VC++ ATL project and does not use .NET framework. Thanks And this may sound very stupid, (I haven't done MFC/ALT for a long time) but how do you add a compiled resource (*.res) into the assembly any way. I have two projects: One is the *.exe, and the other is a static library. The resource file is in the static library projec ...Show All
SQL Server Help Me! How can I use SQL Server Subreports in Visual Web Developer Express Edition
Hi, I use Visual Web Developer 2005 Express Edition. Anybody help me how can i use reports and subreports with parameters in it. I am new to ASP.NET. Please give me a sample. Thanks in advance. Take a look at this article "Adding a Subreport with Parameters", it might be able to help you. http://msdn2.microsoft.com/en-US/library/aa337490.aspx Hope this helps. Jarret ...Show All
SQL Server Force Excel Column type when exporting from SSRS
Hi all, I have a tricky behavior here. I have a column in my report which contains alphanumeric codes. When I have a code like 17E001 and I export the report to Excel, excel kindly shows that alphanumeric code to 1+E7 and the value of the column is changed to 1700 which is defintly not what I want. So I was wondering if there is any way to force the column types when exporting from SSRS Sebastien. By the way if there is a way to force all columns to be formated as Text that will do for me as the excel reports are only used to process data using SSIS. ...Show All
Architecture unable to connect remote Desktop
Hi all I want to connect a remote desktop outside of our LAN. I am using Remote Desktop Connection tool to connect it .But it is giving the error The remote session was disconnected because there are no Terminal Server client access licenses available for this computer But I am able to connect remote desktop in side our LAN.Please tell me how to solve it Regards Bijaya Try connecting to the console like: Start-Run mstsc /v:YourServerName /console This will connect you to the console session on the remote server. This does not require a term serv license. ...Show All
SQL Server sql server express loses ability to write to database
After a period of use (typically 1-2 hours), an application using SQL Server Express stops writing to the database, whilst still continuing to read from it. As far as I can tell, no error message is generated by any operation. The application is written in VB Express and is executed on several machines, with SQL Server Express on a central machine. Re-starting the application on the affected machine restores normal operation. The problem on one machine does not cause a similar problem elsewhere at the same time (hence it appears to be an issue with the relationship between the application and SQL Server) This does not appear to relate to the response to Q asked by sgcook on 9 may as we are not using user instances, but only a ...Show All
.NET Development Read Text file and allow to be opened for writing
I would like to scan a log file in read only mode w no locking. I have tried with FileStream, AssignFile and even CopyFile. My issue is that there is a process running that needs to write to the file which may be during the time I am reading. I have the file open in fmOpenRead or fmShareDenynone and have no issues with opening. However, the app that needs to write to the file errors out w 'Cannot open log file C:\XXX.log' -- it's trying to open the same file in fmOpenReadWrite or fmShareCompat.. any ideas (I can't change the code for the app that's writing to the log) the issue is the code in app: It opens the log in fmOpenReadWrite and fmShareCompat mode. fmShareCompat mode and fmShareExclusive work the same way. They both evaluate ...Show All
Visual Studio Team System Schema Import missing GRANTs
After importing my schema, I see plenty of nice scripts for my sprocs and tables. I also see that my ROLES are created, but the mapping of roles to the sprocs is missing. I have a dbReader role that can access my query stored procedures and a dbWriter role that can access the Inderts/Updates/Deletes. somhow this relationship of GRANTS has been lost in the translation... We're pretty close to internally nailing down the design decisions on the pre and post deployment scripts as far as what they will contain and how and when they are generated. When we have definitive answers, we'll try to get them out on the forum for your review. Thanks for the input. Bruce ...Show All
Visual FoxPro Visual FOXPRO ODBC Drivers for windows Vista
Hi. Does any one knows where i can get the Visual FoxPro ODBC Drivers for Windows Vista Thanks. Helder Santos I don't think that the current download/install of VFPODBC (VFPODBC.MSI) hasn't ever worked on Vista, and I notice it's still broke in RC2. Is VFPODBC going to be supported in Vista ...Show All
Visual Studio 2008 (Pre-release) display web browser in wpf Xaml forms
hi all, I am developing an application using WPF and i want to let the user check his email in one of the wpf forms. I noticed that there is something called web browser control in windows forms, is there something similar to this in wpf in other words all i want to do is display hotmail for example in wpf xaml form. ...Show All
Windows Forms Acquiring Deployment Info from VB
I've created a simple project in Visual Studio .NET 2005 Professional according to the information from the following link: http://msdn2.microsoft.com/en-us/library/49b92ztk(vs.80).aspx I've added various steps to the installation side of things and would now like to be able to acquire customer details etc from the vb code. Can someone kindly provide me with a link to a working example or even better still, kindly show me how Thanks in advanced It's a bit tricky to customize it much further. There are some things you can do with custom actions, but once you go there you are kind of on your own to make sure that your custom actions do appropriate things and by the rules. With a VB or C# cus ...Show All
Visual Studio Team System Tag information on TFS Content Items
Hi, Is there a way store additional string information (like metadata) on a Team Foundation Server Content Item For example, I want to store XML information on an Excel document, or a JPG file. Is there something like TAGs, Parameters, or any type of additional information container Your help will be appreciated. Gustavo We don't have an officially supported mechanism for that in V1 - we have some "annotations" that we use internally and you can access via the web services, but nothing supported or available through the object model. We're considering it for a future release. In the mean time, you could workaround it by associating data with the changesets that affect the items, b ...Show All