redshock's Q&A profile

• Visual Studio Tools for Office Cannot access assembly from end user computer

  I am creating a simple excel application and saving the assembly on a network folder. When i try to access this from end user's machine i get the "The Current .Net Security policy does not permit the customization to run. Do not change the security policy in your computer. ...." 1.I have ran caspol.exe and granted full trust to the assembly on the end user's machine. 2. When i look at the details of error, it shows the dll is loaded from correct network folder. 3. I have also verified in Framework 2.0 configuration it shows my dll under Local Intranet_Zone. 4. The solution works correctly on my development machine. I am using Visual Studio 2005,VTSO 2005 and Framework 2.0 Thanks in advance for helping me with this. The one ...Show All

• SQL Server using query export to flat file

  Hi i have a temp table i want to export the columns to flat file with delimeter eg : temp table Empid Empname Date_of_birth 1 Xyz 12/12/2000 2 Abc 01/11/1987 3 Adf 05/12//1982 Using T-Sql i want to insert into a flat file and the format for the flat file is like  |1|;|Xyz|;|12/12/2000|  |2|;|Abc|;|01/11/1987|  |3|;|Adf|;|05/12/1982| please help me out this issue , thank in advanc Sunil   thanks a lot Mani one think i want to know like can it possible to add Header and Footer for the output file (C:\exported.txt) in this bcp command. and in the above query the ...Show All

• Windows Forms Hide method doesn't work on program's first execution

  Hi there. In my application I have a main MDI form (called frmMain) and a login form (frmLogin) . frmMain is the main module of my application. I have the following code on frmMain load's event: this.Visible = false; this.Hide(); _frmLogin = new frmLogin(this); _frmLogin.ShowDialog(); When I execute the application for the first time on the current session, frmMain loads but remains visible and then frmLogin appears but frmMain is still there. Ok, I close the application and then run it again. This time frmMain hides correctly and frmLogin is the only form that is visible. If I restart the computer and attempt to run the program, same thing happens. Important note: if I run the program on a slow computer the problem always occur. Why this ...Show All

• Microsoft ISV Community Center Forums Error 1004 setting print_area

  I've set up a bit of VBA that formats a variable length spreadsheet for printing. The problem is that after the first time it's been run, it throws up an error message 1004 "application defined or object defined error". This is the code that defines the print_area: ActiveSheet.Names.Add “Print_Area”, ActiveSheet.Range("A1").Resize(NumRows, 6) NumRows is a variable that I calculate further up to determine the length of the printed out bit I want to use. First time I run it, it works fine, after that it throws the 1004 error. I tried clearing the Print_Area using this code: On Error Resume Next ActiveSheet.Names(”Print_Area”).delete On Error GoTo 0 just before set print area bit, but I still ...Show All

• Visual C++ C++ Newbie needs a c++ expert converting bits to bytes

  Hello all, I need some C++ experts to help me with a problem I have in converting a PBM file to a PGM file. These files are used to store digital images. The PBM file uses monochrome to display images while the PGM file is a grayscale image. I have written a test program that works somewhat. The problem I have is that the PBM format uses 1 bit to represent a pixel while the PGM format uses 1 byte to represent a pixel. Therefore 1 byte in PBM format represents 8 pixels. I need help in converting those bits to bytes for the PGM format. I am not sure how to achieve this. I have never really had any experience in masking bytes. Here is my code thus far: #include <iostream> #include <fstream> #include <string> using namespace ...Show All

• SQL Server ForEach Loop Editor

  Help, Trying to through a process together and using the "ForEach Loop" task. When configuring the task and using the ForEach Loop Editor I do not have the "ForEach File Enumerator" in the drop down. Anyone know whats going on or what I need to do to make this appear. I only see 5 selections: ADO, ADO.Net Schema Rowset, Variable, NodeList, and SMO Enumerators. I am also using the SQL 2005 eval with SP1. Thanks, John Jamie, Thanks for the info, but feel uncomfortable since I have never compiled C# and not sure if I can do this within BIDS. After reading the posts it appears that some of the registry settings do not have the correct permissions. Would you happen to know which reg settings I need change t ...Show All

• Visual Studio Team System Opening a database project is taking a very long time

  Hello everybody, I have a little problem. I created a database project that represents a Microsft SQl Server 2005 database schema. When importing the schema (the database size is 1.7 Gb) it took 6 hours. After creating the project , when i want to open the project it takes 2 hours. How is this possible Can anybody help me on this one Thanks a lot, Oana. Oana, There is a known issue with DBPro projects that are under source control. Last I heard we should have a fix for this in a matter of days. Amos. ...Show All

• .NET Development Webservices return object problem

  Hello. I have one problem with webservices and that problem is: I have one application 3-tier. In Data tier i have a class Address(example). In Business tier (exposed by webservices) I have two webservices that returns class Address. In Client or Interface Tier i have one module aspx that makes management of addresses. But in this class i only can import Webservice1.Address or Webservice2.address. But i want import only class Address, and not webservice1.address and webservice2.address (in client this 2 address classes are not the same). I could i do that Thank you. Antonio Dias I think you can't change the "update web reference" behaviour but you can ...Show All

• Visual Basic How to display a Unicode character

  Greetings: After an hour of futzing around, I still can't figure out how to display a unicode character. Encoding, decoding, whatever. Here is as far as I've gotten: Dim uni As New UnicodeEncoding() chkBf.Text = "B" & uni.GetDecoder(\u266B) which doesn't work at all. It can't be too complicated, but I can't make heads or tails out of the help files. I want to display the musical notation "flat" symbol. Thanks! Mmm... that may be a problem. A rectangle means the the current Font of the checkbox does not support that character. Try using the Arial font, this one has support for many Unicode characters, seems to work fine for me on a Win XP. Initially I tested ...Show All

• Visual Basic Setup Wizard in VB 2005 Standard SP1

  This one is aimed at Matthew Gertz in VB Development Team. Yes, I am aware that the Christmas Holidays are near but I hope your response will be quicker than last time. First two points and then my query 1. Despite ticking the Alert Me box, I am not getting Alerts when you post responses. 2. The first time, I opened VB2005 after installing SP1, I got the error message "Run Time Error/Program C:\Pro\R6025 - pure function call" and VB closed. The second time I got an Report Error toMicrosoft - which I did. Third time the programme loaded and ran OK. Curious QUERY I have read extensively in the help file about using the Setup Wizard but the reality does not match the reporting. Page bf5cf02e-b0b7-4a99-ba9c-bcf9d383b7d ...Show All

• SharePoint Products and Technologies User Provisioning in SharePoint 2007

  Dear SharePoint Community,   I am trying to deploy MOSS 2007 for a large amount of user (>10000). Is there any other way to batch add the users to the desired SharePoint user group (Home Member, Home Owner, ect)  The way I have found till now is to add the users one after the other either directly in SharePoint UI or through the stsadm.exe command line). Do you have any Idea, how can I accelerate that Any help will be greatly appreciated!   Thanks a lot!   Cheers... LLiu ...Show All

• SQL Server Create Time dimension Year, Week, day problem

  Hi, I have a problem when creation a Time dimension Year, Week, day , The week does not start on the correct date eg. Week 42-2006 should start on 16 th. october and end on 22 th october, but in this case it starts on the 15th october and ends on the 21 october. So what happens is that it starts 1 day before it actually should. This is my Time Dimension: DatePart(year,"dbo"."fCapacityLedgerEntry"."Posting Date") DatePart(week,"dbo"."fCapacityLedgerEntry"."Posting Date") 'Week ' + convert(CHAR, DateName(week, "dbo"."fCapacityLedgerEntry"."Posting Date")) convert(CHAR,"dbo"."fCapacityLedgerEntry"."Posting Date&quo ...Show All

• Visual Basic Timeout on first load with SQL Express

  I have an application that on the first boot, almost all the time, it will give a timeout error for the database. Has anybody else had this problem, and is it possible to fix Thanks! Hi Dave, I have the same problem too, and although I don't really know the cause/solution, I work my way around it. I don't think it is the cause of an Antivirus/Firewall program. I've tried it on my machine (with AV and Firewall) and on my parents machine (without). And both had the same error. On my form which needs a SQL Express connection, I use Try - End Try. In the catch section I place the whole thing again like: Try 'The Code for the adapter here: Me.MainTableAdapter.Fill(Me.LogbookDataSet.Main) C ...Show All

• SQL Server Package execution fails in Windows service but runs fine as a Windows application.

  I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service. The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task. Again, the app will run all packages just fine. The data is imported and t ...Show All

• Visual Basic former issues, revisited: FileSystemWatcher

  My understanding of the FileSystemWatcher is that it can only watch a single directory, and either one file type or all file types (nothing in between). If that is true, I am looking at a different approach, if it is not true, perhaps someone could expand my limited knowledge. In short, here is what I want to accomplish. I have big files being uploaded to our FTP server (located in our office), by various speed IP’s (including dial-up) to over 30 unique folders, and I want them swept into a central location. Obviously I have to be concerned about whether the files have completed their upload before they are moved. I was thinking about an app that has a timed event to check all of the files in each named directory for the “da ...Show All