DiasVFX's Q&A profile

• SQL Server how to compare two word documents using full text search?

  can we use full text search and mining algorithms to comapre two word or text documents to find out if they are similar please help. thaks for reading None of the above links help answer the question It would be nice if there was a way to compare two documents using full text indexing or be able to perform a serch which returns other documents that are similar to a document you specify, however I don't believe this is native functionality ...Show All

• SharePoint Products and Technologies Column Level Security

  I'd like to grant some users access to only some of the fields in the list. I know that there's no column level security in WSS 3.0. Does anybody have any idea how can I do this Any help is appreciated. Thanks Gary. Are you talking about this post It is #1 google result for Sharepoint column level security . But it has two serious disadvantages. 1. The guy is not going to share the code, but I myself have no experience in programming and even don't know what to start with. I'm even ready to buy such a solution for a small fee (I need it for my personal use only). 2. This is sutable only to restrict write access, but my main task is to restrict view also. Thank you for your reply anyway. ...Show All

• Visual C# Help: Slow Launch application at first run after each reboot

  Hi, I've developed an application (only one screen, not too big,published size is about 4MB) It runs expected. The problem I'm facing is that for a given PC, it takes quite long (1-2minutes) to launch this program. The screen waits at the Launching Application message "Verifying application requirements. This may take a few moments". This occurs only at the FIRST launch after EACH REBOOT. Subsequent launching of the program only takes a fraction of seconds. I don't understand why it happens. Hope someone can give me insights. Thanks! best regards, jackLing Hi, Thanks for your reply again. I get what you mean. I have published my application to a shared folder then run ...Show All

• SQL Server Error after migrating to SQL Server 2005

  I'm trying to migrate MS Access 2003 query into SQL Server 2005 view. I'm getting error for the following query. ERROR: Incorrect syntax near the keyword 'LEFT' MS-Access query: SELECT tbl.*, tblP.ParticipantLastName, tblP.ParticipantFirstName, tblP.ParticipantAmount, tblP.SocialSecurityNumber, tblP.Comment FROM tbl LEFT JOIN tblP ON tbl.AutoNumber = tblP.RecordNumber WHERE ToBeProcessed='YES' and [Cancel]=0; SQL Server View: CREATE VIEW dbo.[qryReport] AS /* * Generated by SQL Server Migration Assistant for Access. * Contact accssma@microsoft.com or visit http://www.microsoft.com/sql/migration for more information. */ SELECT tbl.*, tblP.ParticipantLastName, tblP.ParticipantFirstName, tblP.ParticipantAmount, ...Show All

• Visual C++ C++/CLI: Best practices for designing library

  Hi, I'm working on library written in C++/CLI that will be used only from C++/CLI (which means that I don't need to produce pure .NET assembly), so I'm looking for some tips and recomendations how to design C++/CLI library (especially what are the possible ways for building and redistributing it, how it could be used in other projects, etc..). I have the following needs: It must be distributed with some header files (because I need to use templates in several classes) I need to separate declarations (.h files) and definitions (.cpp files) I'd prefer to distribute it as a dll with some header files, but distributing it with the complete source wouldn't be a big problem... Probabbly the only possibility is to split class ...Show All

• Microsoft ISV Community Center Forums Copy an Excel File and Update some of it's cells

  I am adding this to my app that I made yesterday that creates new project folders and copies files over. Now I would like to beable to edit the excel files as I copy them over. I have started to play around with the excel stuff for VB and I got it to create a new file, but I need help on editing it as I copy it. Ideally I would like to be able to only change some cells. Like tell it to delete everything in one cell and replace it with something. Thanks 'OPEN THE EXCEL FILE Dim wb As Excel.Workbook = _ ThisApplication.Workbooks.Open("C:\YourPath\YourWorkbook.xls") 'SELECT MY WORKSHEET 'ThisApplication.ActiveWorkbook.Sheets(1).Select() Dim xlws As Excel.Worksheet = ThisApplication.ActiveWorkbook.Sheets(1).Select ...Show All

• SQL Server Cast from string to date

  I created an SSIS package that pulls in legacy data from a DB2 AS400. There is an In Date field that is stored on the AS400 as OdbcType.Date or DATE. However, when I use SSIS to pull in the data, SQL wants it to be a string so I gave up and let SQL have it's way. Now in my SELECT statement, I have this: SELECT TLMST.TLNUMBER, TLMST.DOGNAM, BRDMST.BRDesc, TLMST.INDT FROM TLMST INNER JOIN BRDMST ON TLMST.BRDCOD = BRDMST.BreedNumber WHERE (TLMST.INDT >= @startdate) AND (TLMST.INDT <= @enddate) ORDER BY TLMST.INDT, TLMST.TLNUMBER Because I see the dates stored in TLMST are yyyy-mm-dd format, this is not working. It is not pulling any records. I tried to use the CAST statement but I keep getting errors about c ...Show All

• Smart Device Development Scroll bars on pocket pc

  hello all,   can we disable auto scrolling in pocket pc we have strange problem, we are using scroll bar control on the form so what happens is on pocket pc we are getting 2 vertical scrolls at a time. Is there any way to disable native scroll bars    also when we change display mode from potrait to landscape unneccessary scrolls are there even if screen is not that long. any suggesions we are using .net compact framework 1.0 thanks in advance Rashmi Tokar   Rashmi, A couple of questions: Which version of Visual Studio are you using Which platform are you targeting Are any CF v1 service packs installed Thanks Dan ...Show All

• .NET Development Error 25007.Error occurred while initializing fusion. Setup could not

  Hi, I am trying to install .net framework 2.0 on Windows XP OS. I get the following error " Error 25007 . Error occurred while initializing fusion . Setup could not load fusion with LoadLibraryShim().   how do i solve this     Try these steps: 1. Do you have the COMPLUS_VERSION environment variable set   If you do, remove it from your environment variable and try to install the framework. 2. Rename mscoree.dll in %windir%\system32 and try to install the framework 3. Look in your registry.  If you had a previous version of the framework installed (beta 1, beta 2, etc), see if this key exists: HKLM\SOFTWARE\Microsoft\.NETFramework ...Show All

• Visual C# C# Windows environment book

  Hello! I am looking for a book that covers Windows environment connected information. Like a scripting bible but for C# (Framework 2.0). A book that covers for example: * How to create a user. * How to create a mailbox. * How to set NTFS rights for a folder. * How to map a network drive. * How to add a printer. * bla, bla, bla.... I realize that some of those thing might not be bundled all in one book, so a book about ADSI edit in C# covering point one and two is better than nothing, and so on. /Leyan Alain Lissoir's "Understanding WMI Scripting" and "Leveraging WMI Scripting" were together a great pair of books on managing windows programatically. The majority of the code ...Show All

• .NET Development Threading Issue

  Hi, Im having a threading issue but unsure where it is happening in my code since the stack trace doesnt tell me where nor does iexplore. System.NullReferenceException was unhandled Message="Object reference not set to an instance of an object."Source="System.Windows.Forms" StackTrace: at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) at System.Windows.Forms.Control.Invoke(Delegate method) at yWorks.Canvas.Animation.Animator.b() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.runTryCode(Object userData) at Sy ...Show All

• .NET Development Dealing with large changing strings

  Hi, I am using stringbuilder class to deal with large strings. I have a StringBuilder object which gets data from the network. From time to time (every time a packet arrives), I have to check if the StringBuilder contains some data pattern to perform some business logic. The problem is that this code does not scale - after receiving around 50-60MBytes of data the application starts consuming 1Gigabyte of memory and dies with out of memory exception. The logic is very simple: StringBuilder b = new StringBuilder() while (true) { string x= getdatafromnetwork(); b.Append(x); string datasofar = b.ToString(); check if datasofar contains a pattern. If yes, quit the loop. } The problem is that StringBuilder.To ...Show All

• .NET Development hard to deploy :-(

  i am new to this, but have developed a working web page in visual web developer express 2005 edition. It works fine on my computer when i run it, it opens a perfect working web page. However does not seem to work on any hosting sites. I have tried quite a few that say they are for ASP etc , but none seem to work. Frustrating to see it working on my computer but not anywhere else. Is there anyone out there who can help me please before this drives me mad thanks Pete i already tried this, and set up on a number of diferent sites, copied ALL the files to the sites and my site would not work, yet as i have said when i run in web developer 2005 express edition it works fine. Must be somthing i am missing but cannot see what . ...Show All

• Windows Forms Binding array into datagrid column

  Dear All, I have a dynamic array generated. So what I want to do is to keep the array as part of a grid column. I cant afford to put each of the array value as individual row as this list will be a long one. So I am doing grouping and keeping the all the ID into an array and later I want to store this array as column value. So how can I store an array as a datagrid column It sounds like you are describing a jagged array, which you are trying to display in a DataGrid, such that some rows would be shorter than others. This could be done, but it would be difficult, and would require the use of a lot of custom PropertyDescriptors. Can you give me an example of what the data would look like at the poi ...Show All

• SQL Server BULK INSERT "AccessDenied" on remote text file.

  OK, Ive read many posts on this problem but have seen no resolution. Here's the deal. When on the actual SQL box (There's 2 in the cluster) the bulk insert works fine. No errors and the event log on the machine that is hosting the text file shows that the account that SQL runs on has accessed the file. This account is a DOmain account and is in the Local Administrator of the SQL server and the remot box hosting the text file. Thats great if you want your developers testing and accessing your SQL box as Administrators. We don't work that way. Our developers connect via SQL Management Studio and test ther stuff that way. That's where the problem rears it's ugly head. When anyone runs a Bulk Insert command that accesses a text file t ...Show All