Dilip M's Q&A profile

• SQL Server SSIS Shared Configuration files -SP2 Problem

  Hello, I have several packages that share one configuration file located at a network location. Up until i installed sp2 everything worked fine, but now the packages "loose" the path to the configurationfile. It is replaced by some c:\program\sqlserver\package.... path where no config file is located. I can run packages if i specify the config file explicetly, but I really don't wanna do that, since it will not work in the context i'm working. I am using the wizard to install my packages. Anyone with similar problems Any help appriciated. Note: This is not the issue that sp1 solved (for me at least). =) ...Show All

• Office Live Development Sharepoint login through URL

  I am trying to load sharepoint in an iframe, and I need to login from Drupal (PHP CMS) I got the <iframe src="https://username:password@share.mycompany.com> but this just brings up the password prompt and if I click Cancel it logs me in. How can I login to Sharepoint by passing the username/password arguement through the URL No, I'm trying to login into Sharepoint 2003 through the URL. I am building an intranet where we will have all our apps in one place, and I need to load each users sharepoint account in an iframe. Therefore I need some way to pass the login credentials to the Iframe URL, most likely in the form of https://user:password@share.url.com. Feel free to move this thread if this is ...Show All

• Windows Forms Windows Application and Access Database

  I've created a Window Application in c#, and I’m trying to delete and insert data in a access database, and I have this problem: - When debugging the application, sometimes I can make all the changes that I need, and some other times I get the ‘operation must be an updatable query’ error. I can’t understand why. I’ve noticed that the .ldb file is created when it works. I’ve granted Full Control to everyone in the folder where the database is. - When I try to run the executable binary, I always have the ‘operation must be an updatable query’ error. Here is some part of the code: str_connection = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + DBFile + ";"; OleDbConnection obj_Conn ...Show All

• Microsoft ISV Community Center Forums Newbie in VBA Drag and Drop..

  Hi, Do not know if this is possible drag and drop effect of items in dropdown control inside a word application The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done Thanks in advanced. den2005 Hi, After a bit of searching I found this code that demonstrates drag and drop between two list boxes on a user form. You saw your new so I'm give a brief overview of whats going on here. ListBox1 is populated with some values when it initialises. When the user click ListBox1 (the source) and moves the mous ...Show All

• Visual Studio Express Editions how to convert textfile to mdb

  Hi, How to convert delimiter based text file to mdb. Actually I need create table structure and mdb also runtime. If any has coding like that pls send to me ASAP by thiyagu Hi, In the issue of creating an mdb file and datastructure, my approach here is to hide a blank database mdb. This would just serve as a template if i want to create a new database. I would just copy this template to whatever location I want to create a new mdb. After that, I'll connect to it through a connection object and just Issue create commands to create my tables, etc... CREATE TABLE <tablename> cheers, Paul June A. Domag ...Show All

• Visual Basic how to stop the call of IE in your app

  im still new at vb but here's the thing ive decide to create a web browser that also interacts with my files on my pc.now with that said. if i debugg my project and go to yahoo.com then click the finance link i get to the pages within my app just fine. now from there. there is  asearch bar at the top of the page i type the word cars in the search and press enter it call ie to launch.I have created an event within webrowser in my app fot newwind under properties. that get it to when i hit enter under the same senerio to open a new window with my app.ok now hers the question.i need to retrieve the requested page that is being called to IE and also stop the call for IE to open. how do i do that herses my code.you will find the event im r ...Show All

• Windows Search Technologies Where are the Adobe filters?

  It seems the adobe filter is not at citeknet nor the WDS gallery. Did Adobe/MS pull it or is it located somewhere else ed, You can find the Adobe version of the IFilter here: http://www.adobe.com/support/downloads/detail.jsp ftpID=2611 It isn't up on gallery anymore because it causes problems with WDS 3.0. If you are running WDS 3.0 I would advise against installing this IFilter at the moment. Paul Nystrom - MSFT ...Show All

• Windows Forms Two color progress bar or somesuch

  I'm looking for a component or control or something that I can use to visually display the times when something can or cannot occur. For example, a process will only run from 8 p.m. to 4 a.m. The user can adjust the exact times. I want to graphically show this. It would look something like: **** **************** **** Except that it would be a solid line instead of asterisks. Any ideas It's kind of like a progress bar but with two colors and some extra properties. Thanks, Check out the Gradient Animation control provided by the open Source Ascend.Net tools . ...Show All

• .NET Development Cannot access the database due to permissions.

  Hi there! This problem is taking place over two servers (intranet): Public and Front1 (ASP.NET framework installed) An .aspx report exists on the front1 server, and the database exists on a Public server. I'm trying to access the report through ie but the get the below error. Server Error in '/scorecard' Application. I figure that it is a permissions problem but I've tried a myraid number of things, but I get the same error. What other info. shall I provide, please be of assistance. Thank you very much. See the following: An unhandled exception may occur when you try to connect to an Access database from an ASP.NET worker process ...Show All

• Software Development for Windows Vista Windows MonthCalendar in Vista.

  Hi friends, I am having a problem in using Windows 2005 MonthCalendar in Vista. If we set XP style by (Application.EnableVisualStyles()), we can't change the background color of windows Month Calendar. I afraid that this is a bug in dotnet 2.0 and hope this will be fixed in SP1. If I am missing something, can you please help me to change the backcolor of MonthCalendar in Vista Thanks! Rathish P S As I understand it, the general rule is that if you decide to follow a style, then the style controls the colors, not you. Because that's what a style is for. If you want to customize the colors then don't use the style. (After all, if you did customize the colors, then you can't guarantee that the colors in the next version of ...Show All

• .NET Development Type.GetType()

  Hi, I am using Postgres SQL and I am trying to retrieve data from a column which is float 8 type. I currently have problems retrieving this column using: (dr[0].GetType() == Type .GetType( "System.Decimal" )) But Type.GetType() keep returning me a System.DBNull value. What should I do here Please advise. Thanks. Type.GetType never returns DBNull. It either returns a Type object or a null reference. In this case, however, it's probably easier to use the typeof operator. dr[0].GetType() == typeof(decimal) ...Show All

• Visual C# Stop Thread and exit program

  My program has a form and another worker class. Worker class has a thread that receiving data, in loop: socket.ReceiveFrom(....) When I close the form the program (thread) is still running. How to stop everything and exit Peter Ritchie wrote: Handling the form close/closi ng events in an ApplicationContext won't help much unless references to the thread objects are available in that scope. I concur with that wholeheartedly...I am just playing color man to your commentary and throwing out suggestions. <g> ...Show All

• Visual FoxPro Simple question about option group labels

  Can't find where to change the background color of the label portion of the option buttons. They stay the original color of a dirty beige. Even though the color of the group box changes, the label will not. How Thanks I wish it did. There are two choices 0=Transparent and 1=Opaque. Neither have any effect. Should it have And if so, what may I have done wrong when the form was created ...Show All

• SQL Server EXEC in SQL Functions

  Hi, I need to pass a table name and id to a function and return a row count I need to use EXEC or SP_EXECUTESQL to run dynamic SQL It wont work in functions. Following is my function alter FUNCTION [dbo].[GetRowCount] (@TblName NVARCHAR(25) , @Itemid INT) RETURNS INT AS BEGIN DECLARE @RowCnt INT set @RowCnt = 0 DECLARE @Sqlstring nvarchar(2000) set @Sqlstring = 'SELECT @RowCnt = COUNT(*) FROM ['+ @TblName +'] WHERE Itemid = '+ convert(varchar(10),@Itemid) EXEC @Sqlstring RETURN @RowCnt END while executing this I get the following error .... "Only functions and extended stored procedures can be executed from within a function." and "Incorrect syntax near the keyword 'EXEC' " does anyone have any ideas of this Thanks ...Show All

• Visual Studio Express Editions Can you get around the .NET Framework prereq for Windows Forms apps?

  Hello, I'm new to C# and am developing an application that will autorun from a USB device (we've already worked out the technical details behind getting the app to run from the USB device). My question is this.  We want our application to autorun whenever the device is inserted into a USB port on a machine running Windows.  However, it seems that Windows Forms applications will not run unless the .NET Framework is installed on the machine.  I am aware that we can package the redistributable version of .NET Framework with our app and install it if it is not already installed.  However, the amount of time it takes to get the application running on a new machine matters very much to the usability of this application and ...Show All