reddfan's Q&A profile

• SQL Server Best way to store information

  Hi, I am using MSDE in my applications. Sometime the tables are large and it takes a time for reading the data by query. 1. If I split the tables it can help me or not 2. May be exist another way to read the data My application wrote in C# (dot.Net 1.1) using ADO (SQLClient). Thank's Alexei You are seriously going to have to give way more information for anyone to answer this question. You state you are using MSDE, is this as a server How many users If you have > 8 simultaneous queries it will start to punish you and seriously degrate performance. And what do you mean large Can you post table creations, some sample data, and most importantly, how many rows you have It might be indexing, it could be poorly wr ...Show All

• Visual C# RTF to HTML

  Hai all, I want to show RTF formated text in WEB page. How to convert RTF formated text into HTML format Any class or library available for this Help me..... Jefy Here are a couple resources I found. I have not used them but they may work for you. http://www.easybyte.com/products/rtf2html.html http://www.developerfusion.co.uk/show/180/ http://www.clicktoconvert.com/index.html ...Show All

• SQL Server OLAP CUBE SECURITY

  Sorry if this question is answered somewhere already..i tried searching in but failed to get an answer for my problem. I have a cube with Fact table as revenue information, and Manger as one of the dimensions. On the front end, i am using Dundas charts for showing this information as chart. But i want to show or hide the cube data depending on the user logged in. Manager Has information like 1) VP 2) Director 3) Assc Dire 4) Project Lead etc. I have the revenue data at Project Lead level. If a VP logs into the system then he should be able to see only his/her group information in revenue. How i can create this kind of security in OLAP CUBES I have no other option on the front end except passing the user role ...Show All

• SQL Server Sharepoint Reporting Services Addin and Sharepoint Server 2007 Trial

  Hello, My question is: can I install Sharepoint Reporting Services Addin CTP on computer with 1. Sharepoint Server 2007 Trial, 2. MS SQL Server 2005 (Developer Edition) SP2 CTP, Reporting Services included installed Documentation tells that I can use "Office SharePoint Server 2007, Beta 2 Technical Refresh or later". Does Sharepoint 2007 Trial fit in ...Show All

• SQL Server ---Problem of realization replication through WEB---

  Hello There is a following mistake at replication through WEB A security error occurred I try to go through IE which user has specified in the master of creation of the subscriber, in a diagnostic mode https://Servak/Replication/replisapi.dll diag And all works, all certificates fulfil correctly who did not collide{face} in what business WHERE TO DIG YES, I do{make} inquiry about receptions of the certificate from a computer repl, on a computer repl it is established IIS I sign the made inquiry in the center of certification and I transfer{pass} on repl signed by the center of certification the certificate and the root certificate cent of certification, I install in IE the root cer ...Show All

• SQL Server I need help with a SQL Query

  I know that there's a lot of you out there that are really good at Sql Queries. Hopefully, one of you will have pity on me and clue me in. I am working with a Visual Studio 2005.net VB application accessing SQLServer 2005 and SQLServer Express databases. I am using a sql query with ado.net data adapter to return data to a grid bound to the data adapter. My problem is that there is data in the SQL table stored as Bigint data types, that I need to divide by another integer and return as a double precision number. For example, part of the Sql Statement looks like: " InvStock.QuantitySold / NumPeriods AS 'AvgUnitsSold', " It works except for the fact that it returns an integer and truncates the decimal points. Is th ...Show All

• SQL Server SQL Server CE doesn't show in Reference dialog

  I already have VS2005 SP1 installed and after installing : SQLServerCE31-EN.msi SSCE31SDK-ENU.msi SSCE31VSTools-ENU.exe When I create a Smart Device project and and try to add a reference to SQL Server CE only the old version (3.0.3600.0) shows up. How do I get the new one (3.1) to show up Yes it does appear that you were referencing the wrong dll. The big issue is that because device and desktop projects have different framework dlls there needs to be different versions of the system.data.sqlserverce dll - the following FAQ that has been started at www.sqlserverce.org might provide a better explanation ( http://softteq.com/sqlserverce/blogs/faq/archive/2007/02/09/missing-system-data.aspx ) H ...Show All

• .NET Development System.net.Webexception

  Hi All, I am in serious trouble. We have a desktop Application that was originally developed in C#.NET 2003 and then upgraded to VS 2005 an year ago. This desktop application accesses its Oracle Database through some webservices also written in .Net 2003 and upgraded to VS 2005 later. Real Problem:- End users of this application takes out excel reports (apart from a loads of other things). They have 14 reports which they can take out from this. Out of these 14 reports one of them gives error in production and when I run the same code in development then it runs fine. This is the error that I get in Production:- The following exception has occured: System.Reflection.TargetInvocation. Exception has been thrown by t ...Show All

• Visual Studio Team System Changes exist in branch, but IDE states "No changes to merge"

  We are trying to perform a merge of a changed file back to a mainline branch, but keep getting the message "No changes to merge". If I right-click on the file, click compare and select the mainline file as the "compare to:", I do see the differences. Why isn't this merge working Jason, In the latest version of our tool we have tried to address both the merge history issue and merge candidates preview. It would be very interesting to see if you could use it to solve your problem more easily. I do believe so and would be very grateful if you took a moment to have a look at the tool for your specific problem. Thanks beforehand. ...Show All

• Visual Studio Team System Project Portals stop working after restoring TFS from backups

  Synopsis of Problem: After restoring TFS from backups, the Project Portals cease working. When I try to load one I get the error message "The virtual server that is referenced here is not in the config database.". Full Story: In my evaluation of Team Foundation Server I decided to see how smoothly a backup and restore would go. The backup was easy enough. I backed up all the TFS databases (per this article ) and the reporting services encryption key (per this article ). With backups safely stored on a separate machine I wiped the server running TFS, reinstalled Server 2003, applied all available updates, and started the TFS install by following the instructions found in the installation guide for a single server configuration. ...Show All

• SQL Server How to add assembly in GAC to SQL 2005?

  I want use Microsoft.Office.Interop.Excel to access excel file my clr. But that assembly is installed in GAC. How could I register it in SQL 2005 thanks! You can copy the .dll file out of the GAC and try to register it. I have not tried this assembly, but I would expect that there may be some issues using it within SQL Server. You could give it a shot, of course. Cheers, -Isaac ...Show All

• Windows Forms How to locate the forms as I like?

  There are 3 forms in my application and I want to put them in the location I want ... Is there any method to realize that Thanks! You can specify each form's location by setting its Location property. Also, make sure its StartPosition property is set to Manual: private void Form1_Load( object sender, EventArgs e) { Location = new System.Drawing. Point (100, 100); } Andrej ...Show All

• Visual Basic Smart Device, Windows and Asp.Net Projects on same Solution ???

  Hi, Im developing a major application that involves: 1) Smart Device Windows CE App 2) Windows (Desktop) App 3) Asp.Net Web App And some of the clases between projects are the same. I tried to include a Windows Project in a Solution where a Smart Device Project resided and it showed me a "plataform incompatibility" error message. I want to make a component (DLL) to store all the shared classes. Is this possible Any suggestions cheers This is possible in VS 2005 and it wasn't supported in VS2003. However, there are still some limitations: You can only use file references (not project references) You need to install the hotfix for KB Article #919904 in order to correctly retarget system reference ...Show All

• Internet Explorer Development Internet Explorer Toolbar (Menu Bar) disappeared after installing IE 7

  I use yahoo as my homepage, when the "Get IE7 now!" appeared in the toolbar, I clicked on it and installed it. Big Mistake so far...Here's the problem, after installing my IE menu bar (toolbar) containing "File, Edit, View, tools, help" vanished and I can't figure out how to retrieve it or get it back. I have checked and it is not hidden behind another toolbar. Along with that, The IE blue bar at the top & small bars at the bottom contain no information of the URL (webpage) when pages are loaded. In the Yahoo toolbar, under the pencil icon- there is no standard toolbar listed anymore. Also my tabs disappeared from yahoo and under the toolbar options there no longer is a check box to "Enable Tabbed Browsin ...Show All

• Visual C++ Help button get chm instead of hlp

  I have a application built around a CPropertySheet derived class. The help button is looking for 'app.hlp' file (this is the default MFC stuff, I've not added anything other than moving the button). How do I get it to look for a 'app.chm' file instead I've tried the following using a test help file in InitInstance() //First free the string allocated by MFC at CWinApp startup. //The string is allocated before InitInstance is called. free((void*)m_pszHelpFilePath); //Change the name of the .HLP file. //The CWinApp destructor will free the memory. m_pszHelpFilePath=_tcsdup(_T("C:\\filezilla\\filezilla.chm"));     EnableHtmlHelp(); but i just get "Failed to launch help" It works for m ...Show All