Andrew Mercer's Q&A profile

• SharePoint Products and Technologies Opening WSS site in VS 2005

  Hi, I haven't got Frontpage 2003 neither sharepoint designer, therefore I am trying to use VS 2005 to edit WSS pages. In the "Open Web Site" dialogue box, under the "Web site Location", I typed "http://myServer/default.aspx " whereby "http://myServer/default.aspx " is the address to access my WSS site. Upon clikcing on "Open". I am getting eror message saying: unable to open the web " http://myServer/default.aspx ". An error occured accessing your windows sharepoint services site files. Authors - if authoring a web server, please contact webmaster for this server's web site. Webmasters - please see the server's application event log for more details and the events l ...Show All

• Windows Forms Multi-dimensional array property

  Hi, I wish to create a form property which is a multi-dimensional array. Can this be done If so, can you show me the syntax, please I've tried the following, which fails. Private _details(8,1) As String Public Property Details(,) As String Get Return _details End Get Set ( ByVal value(,) As String ) _details = value End Set End Property Thank you. p.s. I realise there are other ways to solve the problem, but I'd like to understand whether a multi-dimensional array can be a property. So now I can reply to my own question. It is possible to declare a property which is a multidimensional array and the correct syntax is, for examp ...Show All

• .NET Development COLUMN LEVEL RIGTHS AND C# APPLICTIAON

  Dear All. I have two tables t1 (f1 int, f2 int) and t2(f3 int, f4 int) And I have view1 as( select t1.f1, t2.f3 from t1, t2 where t1.f2 = t2.f4 ) user1 has right to select all columns from view1, but user2 can select only column "f1". In c# application, I have simply a datagrid. i want to get user right and set visibilty of datagrid's columns based on that rights. f.e: if connected user is user1, that application will show all columns of datagrid, if user2 than it must display only column f1. How can I achieve it Thanks in advance. Sincerely, Teymur You cant handle that problem through sql server  as sql server does support columns permissions on each data obje ...Show All

• SQL Server Logging Query Messages From ExecuteSQL Task

  The ExecuteSQL task makes it easy to capture the resultset of a query or stored proc in a variable. But what about the messages that would normally appear in the Messages tab when running queries in Management Studio or Query Analyzer There must be a way to display and log rowcounts and other messages that a query normally produces.   Various package/task logging configrations haven't helped. I've read discussions about logging rowcounts in data flow tasks, but what about capturing messages in ExecuteSQL and other control flow tasks that run T-SQL   I only have enough time to dabble in this technology so I may be missing something obvious or approaching this incorrectly. Any sug ...Show All

• SQL Server subtotal in table

  Hello! How can I add into an object "Table" subtotal by page I try to do so, as you advise me, but the problem is, on first page positions 18 lines from tables, but on the following much more. How I do so on first page there was 18 lines, but on all rest for instance 60 Thanks. ...Show All

• Visual FoxPro Automate appending data from an MS Access.mdb to two different Foxpro tables (including memo fields)

  I have 1 MS Access table calles Notes.mdb. I have two FoxPro tables called Measures.dbf and Special.dbf. I need to take data from Notes.dbf and import it into the FoxPro tables. Notes.mdb Special.dbf ID Number local.id Date/time datein comment code scode comment stext ARKS=yes SUP=yes Notes.mdb Measures.dbf ID Number local.id Date/time mdate Weight mvalue Weight unit munits ARKS=yes Sup=yes Need ideas for coding this. Tried to do an append query but the memo fields were empty. One of the fields in the FoxPro Special dbf is an autoincremental field. What is the code for incrementing the number. I tried to append blank record then insert bu ...Show All

• Visual Studio MRefBuilder Index Out of Range Error when documenting internals

  When I turn on the documentation of internals I receive an IndexOutofRange error in the MRefBuilder. When internals are turned off all works fine. Any ideas Anand, I cannot share my dlls with you. I was working on trying to remove dlls from the documentation build until I no longer received the error to see which may be the culprit. I should mention that one of the dlls is a ASP.NET Web application dll, another is a set datasets, and the rest are regular vb.NET dlls. In the Web dll there are plenty of references to third party control, which is my guess as far as where the problem lies. I will let you know if I narrow it down enough to find the problem. Carl ...Show All

• Visual Studio Express Editions Dll Errors

  I tried using VC++ to create a win 32 appon a Win XP SP2, It compiled fine. But when running, LoadLibrary gives a load address of O as a float or NULL as a string. Error code is 7E for Kernel32.dll. I tried using regsvr32 and almost all the DLLs return a " Dll loaded but DllRegisterServer Entry Point not found. I have had a hard time already configuring VC++ on my system while the Borland compiler I use on my Win 98 works perfectly. The code below will compile but wont run... #include "windows.h" int main() { HMODULE my_lib = NULL; HMODULE my_lib = LoadLibrary("kernel32"); printf(" load Library is at %x ", my_lib); return 0; } I could reinstall... If it solves the proble ...Show All

• Visual Studio Team System Diff between two labels not working

  Hi, I'm trying to use the tf diff to get the difference between two labels. The syntax is: tf diff $/SourceFolder /r /version:label1~label2 For some reason i'm getting this error:"Unable to determine the workspace" What is the meaning of this error Thanks, Shmulik. ...Show All

• Software Development for Windows Vista CallExternalMethod Activity, Workflow Idle Issue - URGENT

  HI, I created a custom composite activity embedding CallExternalMethod Activity and HandleExternalEvent activity to interact with the Workflow host (ASP.NET appln). I have a simple workflow like this, 1)CustomActivity1 2)Parallel Activity i) CustomActivity 2 ii) CustomActivity 3 3)CustomActivity 4 When the workflow gets executed, the steps 1 and 2 works fine. But when i complete both the items in the parallel activity, my workflow idles (fires the workflow idle event) without evaluating the next CustomActivity4. I have this Workflow Idle issue only when i place my customactivity within a parallel activity. Any help on this. thanks. Does the parallel activity rea ...Show All

• SQL Server Link Report

  I have a report A under FolderA , I created a link report for reportA under Folder B. I am trying to access the names of the reports under FolderB through ASP.Net web application. But when I do this the link report name is not being displayed since it has the path \FolderA\ReportA. But the report is visible in the report manager under folder B. Is there a work around to display the name of the link report.please let me know. Thanks!! SqlNew ...Show All

• SQL Server SQL Chargeback

  Does anyone know of good chargeback software for use with SQL 2000 & 2005 We have two shared SQL servers with 120+ databases from various departments but cant find any off-the-shelf software which will allow us to produce MIS reports for mangement and charge back. I am aware of a Microsoft document however, this doesn't work too well and is too complicated for our maagement to use. ...Show All

• SQL Server which of these ways is the best to create dimensions

  hi. Im currently trying to upgrade an AS2000 db to AS2005. the layout of the tables is like this: there is one fact table, and a number of dimension tables. il take the DueDate Table as an example. I cant set up the dueDate dimension as a time dimension, as there are other time dimension tables also ( invoiceExpirationDate etc etc), so im doing what the original dev done, just create them as regular dimensions. Now in the dueDate table, there is the primaryID Key, and then the DueDate, the DueDateMonthName, DueDateQuarter, and DueDateYearName. we need to be able to filter on each of these columns, so do create each of those as a dimension, as was done previously, or create one dimension with the rest of the fields as attributes this doesn ...Show All

• SQL Server How to enable range Date in Calender?

  Hi, I am using Asp.net Calender in my application and i have two date (i.e StartDate and EndDate). I need to enable dates between these two date in calender. So the user can choose date with in this set of date. Can any one give me idea to solve this problem Thanks, Hi, Do you want to pass these dates to a report If so, you need to create 2 parameters and pass the start and end date to the report. If not, you should probably need to post your question in a different forum. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• SQL Server ODBC support

  Can CE be called from an app. that makes ODBC calls Thanks. I would guess that the reason he wanted an ODBC adapter was because he wanted the database to be accessible from some tool that supports ODBC, but not OLEDB. I'm actually surprised that there isn't some sort of generic ODBC-from-OLEDB adapter, so that if you have a DataSource accessible via OLEDB, you can turn it into an ODBC DataSource. ...Show All