pinoyz's Q&A profile

• SQL Server MSDASQL error requires SQL Service restart

  I am having trouble with a linked server using MSDASQL.  I'm connecting to a PostgreSQL database and pulling over data.  This process has been working fine. In trying to pull data from a different client database (same schema), I received an error that the MSDASQL couldn't read the column names. The actual problem I want help on is that after this happens, I am no longer able to make valid connections to any of my Linked Servers using MSDASQL.  The only way I can get my other linked servers to work again is to restart the SQL Service.  Usually this is impossible for me to do because of the number of active users. Two questions: 1) Is there another way to restart a more targeted service or sub-set to reset MS ...Show All

• Visual Studio 2008 (Pre-release) IValueConverter and ValidationRule in Binding

  In Binding, I want to use IValueConverter and ValidationRule. At that time, I want to evaluate the result of conversion with IValueCo nverter with ValidationRule. How should I do There are samples in the sdk ms-help://MS.MSSDK.1033/MS.NETFX30SDK.1033/wpf_samples/html/dba50aaa-a436-47d3-a850-1f3cd58e9141.htm ms-help://MS.MSSDK.1033/MS.NETFX30SDK.1033/wpf_samples/html/9a5f1195-f84e-439e-a752-1564c4ef220c.htm ...Show All

• Visual C# how can i use ole like tech in C#?

  first Q: i want use c# to insert into richtextbox an object ,but i can't find ole in c#,so what can i do to insert an object Second Q: when i use ,i find richtextbox can't displey table correctly in vs2005,for example i draw a table in word application ,but when i copy it to richtextbox ,the table is not the same like in word. A RichTextBox control is not a complete functional replacement for Word. I seriously doubt it supports embedding OLE objects. Tables are likewise an advanced Word feature and Word has constantly tinkered with it in every new release. ...Show All

• Visual C++ Intellisense for source spread out in different folders

  Hello, Does anyone know a way of making intellisense work for source files in different folders Eg: In folder 'foo', I have FooClass.cc In folder 'bar', I have BarClass.cc I make a new empty project in VC++ and add the 2 source files. The problem is that intellisense will not work in BarClass for references to FooClass objects (and vice versa), but if I put them in the same folder, intellisense would work. (They need to be in different folders because I'm building them in linux using a make file). My question is pretty much, is there a way to specify to VC++ the source folders that I am using. (I'm using Visual C++ 2005 Express Edition) Thanks in advance. Hmm... having files in dif ...Show All

• SQL Server Select maximum from a table

  Hi All, I am trying to select maximum value of a column from a table X, I know that this table has '10' as the maximum value but whenever I do a Select Max(ColumnName) from Table X , I get '9' as the answer. Can anyone help me with what could be the reason. Thanks Thanks Phil, The table had the wrong datatype for that column (nvarchar instead of int), changing the column datatype fixed it. Thanks ...Show All

• Visual Studio Testing for Null in RDLC Report Field

  In .net 2.0, vb.net, I am trying to display a strPhCell phone number char field, from a DataSet, using the Format() function. The Format works fine, but whenever there is NO Phone Number, the string "#error" displays on the report. I have tried every way I can think of to detect a Null or blank, but nothing works. Someone on ExpertExchange suggested the following ... which also does not work if there is no phone number. Can someone help =IIF (Fields!strPhCell.Value is nothing , nothing , Format(cdec(Fields!strPhCell.Value), "(###) ###-####" ) ) cgai I dont believe there is a way to check for null. A workaround is if you instead return something like "n/a" from your ...Show All

• .NET Development How to add codes in a three layer web application to fulfill Inner joins and queries?

  Let's take a sample such as http://download.microsoft.com/download/9/6/9/969e5c94-dfb6-4e47-9570-d6d9e704c3c1/ASPNET_Data_Tutorial_17_CS.exe . I wanna fulfill Inner joins and queries ,for example:SELECT Products.SupplierID,Suppliers.CompanyName FROM Products JOIN Suppliers ON Products.SupplierID = Suppliers.SupplierID Where CategoryID=@CategoryID . I add query:"GetSupplierByCategoryID(@CategoryID),FillByCategoryIDID，GetSupplierByCategoryIDID(@CategoryID)" in Northwind.xsd. I also add "[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)] public Northwind.SuppliersDataTable GetSupplierByCategoryID(int categoryrID) { return Adapter.GetSupplierByCategor ...Show All

• Visual Studio 2008 (Pre-release) Extending EndPoint Configuration

  Does anyone know if it possible to extend the EndPoint configuration element. By this what I mean is i would like to do the following: Current: < endpoint address = " http://localhost:8080/service1 " binding = " wsHttpBinding " bindingConfiguration = " WSHttpBinding_IService1 " contract = " ConsoleClient.ClientServices.IService1 " name = " WSHttpBinding_IService1 " / > Extended: < endpoint address = " http://localhost:8080/service1 " binding = " wsHttpBinding " bindingConfiguration = " WSHttpBinding_IService1 " contract = " ConsoleClient.ClientServices.IService1 " name = " WSHttpBinding_IService1 " my ...Show All

• Smart Device Development Books help

  Hello, if anyone of you have idea related to books for windows mobile 2003 developers or PPC 2003(C++.net 2005). any ebook or book website link is highly appreciated. Thanks -Salman Hi Salman I'd get the book 'Programming Windows CE' by Douglas Boling. Get some e xcerpts from this book here: http://msdn2.microsoft.com/en-us/library/ms912076.aspx Michael ...Show All

• Windows Forms How to deal with file system permissions when recursing file system

  I am working on a module for an app the recurses the file system. As the program recurses the "C:\" drive I get the follow exception System.UnauthorizedAccessException was caught Message="Access to the path 'C:\System Volume Information' is denied." What is the correct way to deal with this exception and continue to recurse the drive thanks, Luis You'll avoid most, if not all, of these exceptions if you avoid recursing into directories that have the FileAttribute.System attribute set. ...Show All

• Visual Studio Team System Can't find the "New Project" command

  HI guys, something very weird is happening to me. I installed VSTS 2005 and when it first ran, a screen appeared to ask me how I want to configure the IDE (as a Web Developer, Project Manager, etc). I was distracted, when I clicked the Project Manager option. The thing is: I can't create any type of project with it. I only see New File and New Team Project options (I use TFS). But I can't create any type of web / windows project. What can I do to restore that option again Cheers In Visual Studio, go to "Tools" -> "Import and Export Settings...". In the wizard that appears, choose "Reset all settings" and click "Next". Save your settings if you wish ...Show All

• .NET Development Regarding Debug.writeline()

  hi im using Debug.writline() method in my class.I don know where the writeline() method will write to..Can anyone help me in this issue WriteLine will write to the trace listeners in the Listeners collection. The default for this collection is to contain a DefaultTraceListener that will emit the information using OutputDebugString. If you are running your debugger this will appear in the output window. ...Show All

• Visual Studio Team System Continuous Integration Build with rolling back ability

  Hi, In our company we use Continuous Integration (CI) build. The problem with CI is that there isn’t really way to prevent from my CS - code that broke the build to not Check-into the source control. We want to implement scenario that start building on every Check-in, and in a case of failure the build will roll-back all the changes that Included with the specific pending changes. Does any body know on a way to implement this kind of thing…….. Thanks in advance, There is a command line tool available in the power toys that allows you to rollback a changeset (assuming only one changeset caused the problem and you can programatically identity which one it is) Personally, ...Show All

• .NET Development Windows application built for Framework 1.1 does not run with Framework 2.0

  I have an application developed with VS 2003 for the Framework version 1.1. I do not distribute the framework with my installer for obvious reasons. When people download and install my software, the installer directs the user to the Microsoft site where the framework can be downloaded. Here is the problem: Currently, MS offers version 2.0 for download, but the installer demands version 1.1 of the framework. Can anyone help me how to change the setup in such a way, that it installs and runs with both version 1.1 and version 2.0 of the framework In advance, many thanks, if you can offer some help. Ruud. Thank you for your help, Johan. Half my problem is now solved. The application now does indeed run with bo ...Show All

• Visual C++ How to bundle dll into exe using VC++

  Hi how to create an exe file or bundle dll into exe unsing vc++ thanks Put the DLL into a binary resource and use LoadResource to access it. There are samples around somewhere. This is actually a Platform SDK question (see The scope of this forum ). Look in Windows programming newsgroup and/or in web sites such as CodeProject and CodeGuru. ...Show All