NimeshPatel's Q&A profile

• SQL Server Conversion between data types

  Lets say I execute: SELECT hashbytes ( 'MD5' ,' IMTIAZ' ) Which returns: 0x60D164C6B64EE81C7E7395C01D838FEE How do I get a varchar: 60D164C6B64EE81C7E7395C01D838FEE Not converted. How do I get the 0x removed from the string Regards Imtiaz You have to write your own TSQL/SQLCLR scalar UDF to do the conversion from varbinary to hexadecimal string. Please do not use undocumented stored procedures like xp_varbintohexstr or fn_varbintohexstr. Undocumented objects can be dropped or modified in any release or even service pack of SQL Server. So you should not r ...Show All

• SQL Server Removing Administrators access to all folders

  We would like to not allow our administrators to see sensitive Payroll information in Reporting Services. I have removed 'BUILTIN\Administrators' from all folders, yet those in the Domain Admins group can still see all of the adminstrative functions, as well as all of the folders. We don't want them to see some of the folders. Does this have to do with the Domain Admins having local Admin rights on the server I think you have to install RS with another service, not Local Service or Networkservice, you can make the service to be installed to the name of a special user Financee\FinanceeAdministrator, after ...Show All

• SQL Server Error on SQL cluster install

  I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain.  The nodes can connect to each other as well as the physical machine.  When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows: ******************************************* Setup Consistency Check Report for Machine: --SERVERNAME-- ************* ...Show All

• Visual Studio 2008 (Pre-release) How soon a WinFX build that works with VS2005 RTM?

  As VS2005 goes RTM tomorrow (15th Oct), how long will it be before a WinFX build that works against it is released Regards Richard Blewett - DevelopMentor http://www.dotnetconsult.co.uk/weblog http://www.dotnetconsult.co.uk Our intention is to have the release of WinFx Runtime Components be the Beta2 release of Windows Vista.  That is planned for Dec 2005.  I hope that helps your planning. -Ford ...Show All

• Visual Studio Express Editions Im Taking A Class on VB...

  How much diffrent is Visual Basic 6 from Visual Basic Express Edition Im going to be taking a class online and its based in Visual Basic 6. My school is getting Visual Basic 6 for us to use there, but I have VB Express at my house. Are the files interchangable Is the coding a lot diffrent The bottom line is, will I be able to start something in one program and finish it in another or visa versa You can use "Create New Project From Existing Code Files" wizard (File => New => Project From Existing Code...) to upgrade any project form Visual Basic 6 to Visual Basic.Net . Hope this helps ...Show All

• Visual FoxPro Converting VFP reports to PDF 6 or Higher version

  How can i convert visual foxpro reports to PDF 6 or higher version from visual foxpro appication and opend automatically. I was having a tool which works fine for Acrobat 4.0 version which uses Acrobat PDF Writer and Acrobat Distiller. Now in the latest version of PDF its creates the printer as Adobe PDF AND now the Windows 2003 server only the higher versions are getting installed. Plese help me in this regard Raman Check out the excellent article by Lisa Nicholls on PDFs in FoxTalk. There is a link to the free article on David Stevenson's (FoxTalk Editor) blog: http://talkingfox.blogspot.com/2005/06/dont-miss-free-pdf-article-by-lisa. ...Show All

• Visual C# Differneces between c++ and c#!?

  I'm quite new in programing and i started learning c++ but i want to know what are the differences between c++ and c#! (because all examples and learning lessons, from msdn Visual Studio 2005, are written in c#) I know this is a stupid question for all of you but i heard about c# only in Visual Studio. I really need an answer to this question because i don't know what lenguage to learn! Thanks  C# is a newer language with a Java-like syntax and feel to it. C++ is more complex and while much of the syntax is similar to C#, some parts are radically different - I'm thinking especially of C++/CLI vs C# and handli ...Show All

• Visual C# Adding Dialogbox

  hi i have created installer package for my application. I want to create the new dialog box which is not in add dialog box pane. How to add new dialog box . In Add dialog pane set of dialog box is available. My requirement is i want to add new dialog box. How to do that Pls tell me It's not possible using the Visual Studio Setup project. You will need to use a custom tool such as Wise for Windows Installer or  InstallShield . ...Show All

• .NET Development Is it possible to use Document/literal style way of using web service in .Net

  Hi all, Currently my ASP .NET Code is accessing webservice throught RPC style of calling. Is it possible to change the style to Document/literal thanks, Ayyanar... Hello Ayyanar, document/literal is the default style in .NET. Just get rid of all the extra code you added for forcing the use of RPC/enc and you should be all set. Furthermore, check out  http://winfx.msdn.microsoft.com/library/default.asp url=/library/en-us/dv_fxwebservices/html/d5a10243-c5a1-44ef-a0bf-06a355f7c598.asp if in your case you need to get rid of parameter wrapping. ...Show All

• Visual Basic Next NewBee question (Icons and TreeView)

  I am working with a treeview control and I want to be able to display the icons next to each node depending on the file type. First I want to say that I am not working with a Windows File System files. I am working on files that are referenced through a proprietary file system that enables the revision history’s and other file attributes. It is for a Engineering software similar to Solidworks.   Anyway my first problem is extracting the Icons from the dll. I can’t seem to figure out how to do that I have been searching the net for 3 days and none of the code I find seems to work.        &nbs ...Show All

• SQL Server ODBC connection failing on 64 version of Windows 2003 server

  I have an application that talks to a SQL backend using an ODBC DSN connection. It works fine when running on a 32bit machine but fails in the 64bit environment. The DSN is setup properly on the 64bit box and the Test Connection returns sucess. However when my application tries to use the DSN to connect to the database I recieve the following error. IM002 - Data source name not found and no default driver specified. The data source name does exist, it's in the ODBC.INI and in registry. As mentioned above the Test Connection succeeds in the ODBC Administrator so logic would dictate that it's setup correctly. Any help would be app ...Show All

• Visual Basic register ocx files

  Hi, I try to register some ocx files and get the message "Loading in memory of library (filename.ocx) has failed. Illegal access to memory location." I checked the dependencies and they are all OK. What can be the cause of this error     Thanks in advance. Jan If you are proficient with using the debugger can you do the following in Visual Studio 2005: From Main Menu select File->Open Project, find %windir%\system32\Regsvr32.exe; right click regsvr32.exe in Solution Explorer and select Properties and Edit the "Command Line Arguments" to be <path>\nagdbs.ocx; From Main Menu selec ...Show All

• SQL Server Create project in MS Access 2000

  Hallo I am getting the “overflow” message (MS SQL Server Database Wizard) on attempt of creating a project in MS Access using SQL Server 2005 Express Edition. I am actually able to open an existing DB. I was wandering why is this happening and what can I do to create such a project Thank you Thank you, for your answer. I do not really need the visual tool with MS Access 2000. What I would like to do is to create a database on the server using MS Access 2000 and I was wondering whether it's possible. Regards, Greater ...Show All

• Windows Forms Updating a ListView

  Is there an easy way to update the info in a ListView without having it redraw the entire line constantly For example, I have a ListView control that displays pertinant data about objects that constantly update themselves. I'm using the ListView to dynamically display these objects (and their data) but the constant flashing from the redraw really annoys me. I know you can set it to OwnerDraw, or something like that, but I'm a little fuzzy on what exactly I'd have to do there. Hello Kris, yes Genius is right. If you want to set the DoubleBuffer you have to extend the ListView since it is a protec ...Show All

• Windows Forms problem painting a control

  hi, i have the following problem, i'm making a triggerbar wich is supposed to draw a vertical line on a form, and then after 500ms dissapear, this is for the CF, in the full framework, i used BackgroundWorker control to do this, this is my routine with the backgrounworker method             Visible = true ;             int f3;             bool TrigLevelLess = MovingTrigVal > _TriggerLevel;             while ( true )  &nb ...Show All