Anonemous's Q&A profile

• Visual Studio 2008 (Pre-release) DLink -- Object DAC

  Hi, I am a system architect for fujitsu australia and we have developped something very close to DLINK in a SQL object DAC. I can't discuss the details of our implemetnation online but I would like to suggest a few things. 1- Being able to automatically map an entity to a table while still being able to exclude a few of the fields from being stored... (they may be calculated or even be UI centric) 2- Being able to have an ID inner class that would be stored flat in the database. That allows for the ID class to implement the IComparable for sorting purposes. 3- We have also found that it is important (in hierarchies) to manage the numb ...Show All

• SQL Server Package runs fine from BIDS but dtexec on same box gives "insufficient product level" error

  Running eval. edition of Sql Server Standard 2005. "Insufficient product level" error is thrown during validation phase of an OleDBCommand data flow task. This task type is not licensed in Sql Server 2005 standard The component runs a very simple sql update statement against a one row table in Sql Server 2005. If it works from BIDS, should it not work from dtexec.exe on the same box Does dtexec run under the security context of the logged in user Thanks, Ken I have the same problem. SSIS installed, but I am still getting this insufficient product level error. ...Show All

• .NET Development What's new with DataTables?

  I'm curious if someone could explain the new features relating to DataTables in .NET 2.0. I've heard that it is easier to share tables across datasets. Is this true I'm in the situation where I'd like to have the same datatable be in several different datasets. I'm not sure the best way to go about doing this. I'm assuming that I'd have to create it in multiple places. I can't just create a stand-alone datatable, can I this  is a good reference for the 2.0 updates. You can create a standalone datatable (you could in 1.0/1.1 as well), but now the object model has been tweaked so that it has some of the ...Show All

• Software Development for Windows Vista What I'm doing wrong in web.config?

  For the past 4 hours I'm having a small problem with the services in Web.Config that I need to ask. My Web.Config is: < xml version="1.0" > <configuration> <configSections> <section name="WorkflowRuntime" type="System.Workflow.Runtime.Configuration.WorkflowRuntimeSection, System.Workflow.Runtime, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </configSections> <appSettings/> <connectionStrings/> <WorkflowRuntime UnloadOnIdle="true"> <Services> <add type="System.Workflow.Runtime.Hosting.ASPNetThreadin ...Show All

• SQL Server Error messages upsizing from MSAccess database to SQLServer

  I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages: Connection failed: SQLState: '01000' SQL Server Error: 2 [Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQLServer Error: 17 [Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied. Does anyone know how I should proceed Any help would be appreciated. Thanks Which version of SQL Server are you using Does th ...Show All

• Software Development for Windows Vista How to convert .dll back to .xoml?

  I'm creating a new Workflow Library Project name WorkflowLibrary1 with a workflow Workflow1.xoml. After buidling Project successfully, it produced WorkflowLibrary1.dll. Can i then convert WorkflowLibrary1.dll back to .xoml (Same to Workflow1.xoml at the beginning) If it can, then can you show me a sample code Thanks! Thank Arjun. So, just to be 100% clear, if I take an aribtrary .dll that contains a workflow and use the Workflow Reflection sample on that .dll, then does that mean I won't see all the details Thanks again, Notre ...Show All

• .NET Development Provider error while reading DBF file

  Dear All, I am newbie in dbf manipulations .currently I have downloaded foxpro driver from the site . but when I am tying to open my DBF file it gives me error like "The Provider could not determine the Decimal value . For Example,the row was just created the default for the Decimal column was not available,and the consumer had not yet set a new Decimal value" I am using the following code snippet to open .DBF file:- try { strConnect="User ID=;DSN=;Collating Sequence=MACHINE;Data Source= '" + frmViewer.lay + "' ;Provider=VFPOLEDB.1;Cache Authentication=False;Mask Password=False;persist securi ...Show All

• SQL Server Dataset

  hey guys, I created a dataset using a design view of the MDX query designer. As you know, in the filter pane of the MDX query, there is check box if you want to parameterized your report. When I checked that option, SQL Server created a dataset specifically for the report parameter. So my question is that I can see this dataset in the data tab of the report designer but not in the Report Datasets list. Do you have any idea why this happened waiting to hear soon. Sincerely, Amde Report designer will mark MDX parameter datasets as "auto-generated" in the underlying RDL representation ...Show All

• Visual C# Moving contents of a file

  I have a program that watches a folder and when a file is dropped into that file it executes some code on the file then moves it to another file. The problem I am having is I dont know how to select the new file that was just moved into the folder thats being watched. My question is. How can I select a file (or all the files, since their will only be one at a time) in the folder without knowing the files name, and be able to retrieve the name of the new file Thanks string[] files = System.IO.Directory.GetFiles(@"c:\FolderName"); for (int i=0; i<files.Length; i++)     Console.WriteLine(f ...Show All

• SQL Server Creating a stored procedure in SQL Server Management Studio

  I have a database that I want to add stored procedures but when I go to save the stored procedure it asked me to save it as a .sql file and doesn;t add it to the database. This is what I'm doing: right click on database > programability > stored procedures select "new Stored Procedure" writting the procedure then save - this is when i get the save dialogue rather than seeing the sp added to the database. There must be something very simple that I'm doing wrong but I just can't figure it out, any help would be greatly appreciated. Damien You need to execute th ...Show All

• .NET Development Error while writing a Log file

  Hi,     I am newbie in the .net world... In fact I have started learning C# .net in the last week only.....     I have created a webservice... but now Since I have to write logs to a log file... I have tried the following code ---------------------------------------------------------------------------------     public class Service1 : System.Web.Services.WebService     {         public Service1()         {             //CODEGEN: This call is required by the ASP.NET Web Services Desi ...Show All

• .NET Development Testing a web service

  Please help Guys, I am trying to find out if there is a way to test a web service before calling the desired web method. i.e test to ensure the webservice if up/online before calling the web service method I need. Do i basically have to create a test method within the web method myself if I need this functionality or is there a way to do a kind of test-call to a webservice. Hello Chinedu, What about trying to send a GET request to the ASMX file and see if that comes back successful. If this works, then we know that the web service is available and next we can try to send a SOAP request by invoking the web method. See if this works for y ...Show All

• SQL Server Is this a bug??

  i use AMO to connect MSAS2005. Seems everything is fine except i do like this: I try to restart the Analysis Service, and then connect to the server. This will cause windows prompt msmdsrv.exe error or debug info sometimes. This comes with the Connect() methed, but the codes will continue running - that means the code doesn't throw exceptions and executed as usual. I tried to sleep the thread for a while(Like in code make 10 seconds sleeping) but cann't pass the test for every time. Coding as below: ControlService("MSSQLServerOLAPService", ServicesAccess.ServiceAction.Restart) //using ServiceController class to restart the w ...Show All

• SQL Server Getting error in SQL Server Destination

  Hi    I have two different database say, DB1 and DB2 one in server A and another one in Server B. Simply select all rows from DB1.Table1 in OLEDB Source and map it to another table in DB2.Table2 using OLEDB Destination.  Works fine. But if I select destination as SQL Server Destination, I am getting the following error: [Insert contact information for facility into ARBilling database [202]] Error: An OLE DB error has occurred. Error code: 0x80040E14  An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80040E14  Description: "Could not bulk load ...Show All

• Visual C# Items are not removed from Error List until project build

  One thing I didn't like at all in my transition from VB.NET to C# is that C# does not remove items from the Error List when they are corrected by the developer. Items are removed only the Build is requested. On the contrary, VB removes items dynamically when corrected. The same applies to the Syntax underlining. When an error is corrected in the code editor vb removes the underlining. C# requires to build the project in order to check if the syntax was corrected. Coming back to this subject after quite some time... A friend recommended me the Resharper tool which does some very helpfull stuff. It also includes dynamically commenting su ...Show All