LalitSRana's Q&A profile

• SQL Server Using SQL Server CE in a NON .NET Delphi Application

  Hi, I'm looking at using SQL Server CE as a replacement for MS Access in a WIN32 Delphi Application. This limits my database options to Providers that is usable from ADO. I see that the OLE DB Interfaces are implemented, but I can't connect to a SQL Server CE database from Delphi. I've cut and paste a sample connection string (replacing the data source bit) but no go I've installed the Runtime Environment, VS2005 bit, Connectivity Tools and the SDK :) Any help Anything that I might have missed Thanks, Dawid You can buy something like the Delphi native interface to SQL Server from CoreLabs ( http://www.crlab.com/ ) instead of ADO. ...Show All

• SQL Server YTD with multiple time hierarchies

  Hi, I want to create a ytd (and much more) as calculated members of the special attribute (TimeView) in the Time Dimension. I know how to to this with a single Hierarchie referencing in the calculation, but we want to provide multiple hierachies with differnt levels and i want to have the calculation working well with all the hierarchies. Hierarchies: H1: year - quarter - month - day H2: year - quarter - week - day H3: hour H4: year - weekday - day H5: year - month - day and so on and i want ot have an hierarchie "Timeview" with default member "point in time" and "YTD" where YTD is calculated - but should work with hierarchies H1, H2, H4, H5. Is there any way to make the calculation hierarchie independed Than ...Show All

• Visual Studio 2008 (Pre-release) Drilling down to the source of a WCF error

  I'm having trouble finding the source of a WCF exception I get calling a function returning a complex type over a netTcpBinding. Judging from the trace, my problem comes from an array (see bolded part below, near the end of the very long trace). There are indeed array members in classes included in my return type (members of members of the return type to be exact). Now, how do I go about finding which array is wreaking havoc and why Edit : the problem is better defined in my further posts below System.ServiceModel Transfer: 0 : , relatedActivityId=18d927d1-79df-4388-95cf-43cc8ce9cb87 DateTime=2007-01-15T18:16:20.0184792Z Callstack= at System.Environment.get_StackTrace() at System.Diagnostics.TraceEventCache.get_Callstack() at Sy ...Show All

• Visual C# How to Move Controls at RunTime in a flowLayoutPanel Control?

  Hi How to Move Controls at RunTime inside the same flowLayoutPanel Control by using Drag-n-Drop Thanks Deza Hi Deza, Here are the basic steps: 1) Dragdrop requires handling specific type names. Since your FlowLayoutPanel is likely to have multiple types, the easiest way is to use a wrapper to reduce all types to one. This way you avoid having to use extensive if then constructions. Example: class MyWrapper {     private Control control;     public MyWrapper( Control control)     {         this .control = control;     }     public Control Control     ...Show All

• Visual Basic VBS Script Help

  Hi, I'm not sure if this is the correct forum or not. If not, please let me know where to post. I would like to create a script that will rename files based on a users input. So far I have a basic batch file that will do the job, but I want something that they wont have to edit. The files needing to be renamed are usually something like 06M123AB.000 where the 123 would be the only thing renamed in the folder. I would like to, if possible, let the user input the old numbers (123)  then input the new numbers (456) and have all files in the current directory renamed. I was thinking a VB Script would be better for this. Thanks for the help.           ...Show All

• Visual C# Insert Bitmap into a Word Document into a thread

  Hi everybody, I use a ' BackgroundWorker ' to generate a word document in background. I want to insert a bitmap which is generate on the fly. If I use this method (that work outside the thread) : System.Drawing.Bitmap bitmap; [..] System.Windows.Forms.Clipboard.SetDataObject(bitmap); [..] Microsoft.Office.Interop.Word.Range range; [..] range.Paste(); I have an error : Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. How can I set the backgroundworker to be 'STA' Is there an another way to proceed Thanks by advance. Greg No, this is not a solution. I do have [STAThread], but since doing it ...Show All

• Visual Studio 2008 (Pre-release) Running WCF GettingStarted sample

  I am getting the following exception when running the WCF GettingStarted sample. Searching through the forum by 405 revealed a solution but it does not say exactly how the App.config and Web.config should look like. I am using RC1 on XP. Thanks ........ System.ServiceModel.ProtocolException was unhandled Message="The remote server returned an unexpected response: (405) Method not allowed." Source="mscorlib" StackTrace: Server stack trace: at System.ServiceModel.Security.IssuanceTokenProviderBase`1.DoNegotiation(TimeSpan timeout) at System.ServiceModel.Security.SspiNegotiationTokenProvider.OnOpen(TimeSpan timeout) at System.ServiceModel.Security.WrapperSecurityCommunicationObject.OnOpen(TimeSpan t ...Show All

• SharePoint Products and Technologies Reports from Lists

  All: I would like to create a report based on a list. Take for instance a simple issue log: How do i create a report in SharePoint and organize the list by "Entered By" I have created reports in Access that use the data from SharePoint via linked tables and I would like to 'duplicate' these reports in SharePoint. Thank you ps. i have looked at "Microsoft SharePoint Products and Technologies Resource Kit" but with out any luck. Thank you Mike, that is NOT the answer I wanted!! As you inferred, I need good looking reports which are easy to make in Access and the list views in SharePoint are not the best. We have not yet moved to SQL Server 2005 and Office 2007 yet, but i w ...Show All

• Visual C++ regarding System.Net.WebPermission while using J# browser Control

  hi, I converted a streaming Applet into J# browser Control. that applet will get the feeds from stock exchange and will display in a grid format. im passing the required parameters like exchange ip and port address to applet using PARAM tag. the same thing i did for J# browser control also. when im running my J# browser control im getting this following error. (means that it is blocking my J# browser control to recieve feeds from the exchange) System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed Im using Full Trust Permission set at Machine,Enterprise and User Level. Any Suggestion ...Show All

• .NET Development "Save" default Access DB as new Database

  I am writing an app with VS2005(VB.Net) that must access an existing MS Access database, create a table and import a text file into the newly created table. The app must then save the existing default database as a new DB with the "user supplied" name. My question: Is it possible to save an existing Access DB as a new Access DB using ADO.Net If not what would be the best way to achieve this Thanks Christie Yes there is no "Save As" with ADO.NET and Access database. Possible options: 1. Like poster indicated above, make a physical copy of the database. 2. Create a new database and copy the tables into the new database, see for example: http://www.codeguru.com/vb/gen/vb_database/microsoftacces ...Show All

• Visual Basic windows services

  hi I want to create anew window service in VB.Net2.0 I am new to this I have to create a new window service that runs in the back ground and the goal of the service is to copy the files from the inbox to a separate folder can anyone tell me the codes /links for this or can guide how it can be done its very urgent Hello Have a look at following, should help you http://www.codeproject.com/cs/system/WindowsService.asp ...Show All

• Visual Studio Express Editions Data in 'bin' but not in database

  I have creating an application and data is being saved to the database in the 'bin/debug' but not in the project database. I have set the database.mdf to 'Copy if newer' but this does not help. Am I right in thinking that when i run the application the 'bin' database is used If so how should it get the the project database so that I can see it when I preview data Help would be appreciated. yes thats correct, it will use the bin\debug folder since thats where its launching the application from. you could modify the connectionstring to point to the file located somewhere else if you wanted what exactly do you mean by previewing the data ...Show All

• Visual Studio Cannot se property values, when I debug

  After I have upgraded to Visual Studio 2005 Team Dev. Edition, I have problem to se the values of the property's. I just get this information instead: Cannot evaluate expression because a thread is stopped at a point where garbage collection is impossible, possibly because the code is optimized. My code is not set to be optimized. When I reach a break point, and want to step into the next statement, the debugging sesion just finish. I have read Mike Stall's .NET Debugging Blog , but I can figure out what to do, to get my debugging work again Can somone help me I don't have "iolo System Mechanic" running on my machine. Could this be a problem caused by some other software/patch installed on the machine ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3DX in DX7 phoning home. can this be fixed?

  This is a "known bug" at least to the game progarmming community. The problem is the D3DXCreateContextEx call, which apparently does a certificate revocation check for the adaptor when it chooses a video card, this triggers a connection to the internet, sets off the users firewalls, and makes them feel like they are being hacked. I know that disabling the "Check for Publisher's Cert" checkbox under the advanced internet explorer options, will disable thsi check and prevent the phoning home. howvever, this option is enabled by default, and thus is no solution for typical end users. Yes, I know directx7 is old, there is 8, 9 maybe even 10 now,. Thats not a solution. I'm a small indie developer doing 2D games wit ...Show All

• Visual Studio Express Editions how to get microhelp or tootips on menu items

  despite the application form already has tooltips on other controls, I failed to see tooltip on menu items. is it possible how about something similar to "microhelp" that appears in the status bar like outlook express when mouse is over an item - when the item select if fired and disappear when the mouse moves away I managed to use an event handler for the select event for each menu Item I want to show "microhelp" in status bar but not yet make it disappear when mouse is moved away. I don't like this method as it adds bulk to the form and not very productive. Is there another way oh, I am using mainmenu class. I had look at menustrip but have not found what I need yet ...Show All