dagfari's Q&A profile

• SQL Server Report SnapShot Creation Programmatically through Java

  Hi, I am facing some issues while creating report snapshots programmatically using axis (Java platform for creating and deploying web services applications). To create a report snapshot what should be the methods called I tried using UpdateReportExecutionSnapshot() but didn't find any parameters to set the schedule information which would say when the execute the report snapshot. Can you please guide me for this Also I had one more doubt regarding report snapshots. If a parameterized report is configured as snapshot then we would require to set default parameters for the report. Is there a way to create snapshots of the same report with different parameters eg : The employee information report displays the information base ...Show All

• SQL Server Basic SQL Execution Question

  I have a table that contains a history of record changes within another table. It may have rows that look like this: DML_Type Record_ID Record_Value DateTime Insert 1 A Today @ 11AM Update 1 B Today @ 11:15AM Update 1 C Today @ 11:22AM Delete 1 C Today @ 11:25AM Insert 2 A Today @ 11AM Update 2 B Today @ 11:15AM Update 2 C Today @ 11:22AM I've inherited a stored procedure that migrates these changes to another database in another schema. The proc is using a cursor to perform each operation in sequence. If I perform the migration in 3 steps (inserts, updates, deletes) - ...Show All

• Smart Device Development Infrared capability on .net compact framework

  Hi, After researching infrared capabilities I can't locate how to accept incoming infrared signals from stnadard tv/dvd remotes to be able to play them back. I have seen and read plenty of articles eg. godotnet but can't seem to find what servicename or endpoint is required to be set in vb.net or c# to work with standard tv/dvd remotes eg. to associate with the client/listener classes. I'm starting to think that the .Net Compact Framework doesn;t support this capability and only embedded c++ will work I would be grateful for any leads.... Thanking you Sorry, I wasn't aware this would be considered cross posting as I thought there were different audiences in the different forums. I th ...Show All

• SQL Server sql hardware setup

  just purchased new server for sql im not sure which raid i should go with here are my specs hp proliant ml 380 g5 2.. dual-core 5150 cpu 4... gb memory serial ATA-150/SAS 140 smart array p400 512mb 4 ..72 gb 10k SAS drives given my specs should i go with 2 raid ones one for os and log files and the other foe database files 1 raid 10with 3 partitions 1 raid 5 with partitions my dabase is about 10 gb transaction log 1 gb please shed some light on which way i should go with disks that i have i believe the server is verry good i would hate to create a bottleneck on the raid I agree with you Dano, RAID 1 for OS and log files RAID 1 for data files this configuration offers the best ...Show All

• Visual Studio 2008 (Pre-release) Message Contracts - Missing something...

  I am not sure how to explain this, so I’m going to show code, then try and ask the question at the end, so please bear with me… I have the following WCF Service (yes, very simplistic but will build out once basic functionality is working…): using System; using System.ServiceModel; using System.Collections.Generic; using System.Runtime.Serialization; using System.IO; namespace WCFService { [ServiceContract] public interface IServiceClass { [OperationContract] string InitiateOrder(); [OperationContract] BookOrder PlaceOrder(BookOrder request); [OperationContract] string FinalizeOrder(); } ...Show All

• Smart Device Development XMLSerializer: sibling elements order - normal in .Net Framework but random in .netCF!

  Hi, all I have used the same classes, and the same serialization code to run a test program writing out an XML document from a data object. It turned out that for an element which has multiple child elements, the order of the child elements remained the same in Framework 2.0 as defined in the class, but it was random in CF2.0! It isn't alphabetic nor anything I can tell but a random order... This is annoying because then the document generated in CF2.0 wouldn't pass the same schema, based on which the classes' code was actually generated.  Is the problem a bug -bonnie I don't care about the actual order of the elements as long as it can pass the schema validation. Since the schema was written in W3C ...Show All

• SQL Server #@ Row 1, Column 7: String data, right truncation @#

  I am trying to BCP a ton of data files into a SQL 2005 database. The first row of data in one of my files looks like: 1000|100000156752|100000176409|100000000000|100000000000|9.4|M|9.4||1/22/1993||1||||100|||||||||1|1/22/1993||||||| The error file has this: #@ Row 1, Column 7: String data, right truncation @# 0 0 0 0 0 .00 17|27.7|M|27.7||2/2/1993||1||||100|||||||||1|2/2/1993||||||| I've built a format file based on the SQL Table definitions with this command: FOR %%f IN (*.*) DO bcp IRIS.dbo.%%f format nul -T -n -t"|" -r"\n" -f%%f.format The format file for lines 1-8 look like: 1 SQLNUMERIC 1 19 "|" 1 SITE_ID "" 2 SQLNUMERIC 1 19 "|" ...Show All

• SQL Server Linked Server issue

  I have a problem querying a linked server connected via the OleDB provider for ODBC. This is the DataDirect 32-BIT SequeLink 5.4 client driver connecting to a FileMaker Pro 8 database. I've tested this in VB.net 2005 by adding an ODBC connection in server explorer and a data grid to a form. I can run the tooty and the data loads in the grid with no errors what so ever. So using the above ODBC connection I added a linked server called 'DNA' and run the following query on the Stock_DNA table. SELECT * FROM OPENQUERY ( DNA , 'SELECT * FROM Stock_DNA' ) The result I get is this; OLE DB provider "MSDASQL" for linked server "DNA" returned message "Requested conversion is not supported.". Ms ...Show All

• Internet Explorer Development Why does IE7 always popup the prompt window in vista?

  I have created a BHO and a Broker process, and I want the BHO can access the broker process without prompt. Therefore I add a key and values into the Registry , so that I can silently elevate the broker process to medium integrity level. more infomation for "elevate policy" ,please see " Understanding and Working in Protected Mode Internet Explorer ". 1. Add a key like this HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Low Rights\ElevationPolicy\{AA467279-FAA8-4154-94C3-71FBAD2FE3FE} 2.Add some values into the key AppName REG_SZ "test.exe" AppPath REG_SZ "D:\test\debug\" Policy REG_DWORD 3 CLSID REG_SZ "{BBD113D6-28F2-467F-B8D5-5F9508FC23BB}" ...Show All

• .NET Development Porting from saxon

  Hi, First off...I am very new to xslt, and I am really just doing an investigation here to determine which XSLT transfor object we are going to use in a client application we are going to be writing (think client). We already have a web application that uses xslt to transform xml files that contain data gathered in a lab. That web app uses saxon, perhaps partially due to the fact that saxon implementents XSLT 2.0. Regardless, since I am going to be interested in displaying the same data (in an environment where we don't necessarily have access to this web application) using the xml files and xslt templates, it would be nice If I could get away with modifying these as little as possible. I have already found out that the element xsl:f ...Show All

• Visual Studio Team System nonincremental update requires all .SBR files

  Sometimes if I stop a build before it's finished, I get errors like this in some C++ projects: BSCMAKE : warning BK4502: truncated .SBR file '.\bin\Debug\csiTransactionParameters.sbr' not in X:\Build\Ascent\NightlyBuild\Binaries\Win32\Debug\/ParamContext.bsc BSCMAKE : error BK1513: nonincremental update requires all .SBR files I'm not doing clean builds and it looks like the only way to get rid of these errors is to delete all of the output files before starting the build again. I'm wondering if anyone has seen this and knows how to avoid it any way other than doing a clean build Thanks, Richard I've not heard of those errors, but I would guess that it's likely a side effect of stopping a b ...Show All

• Software Development for Windows Vista SqlWorkflowPersistenceService requires separate database per workflow

  Hello: Is it correct that SqlWorkflowPersistenceService requires one database with persistence tables (InstanceState and CompletedScope) per workflow I setup database for SQLpersistence for my one solution, which contained Ordering project and Workflow1 and I added following code as a part of my this project and it worked fine, application stored workflow state in SQL2000 database I just created. SqlWorkflowPersistenceService stateservice = new SqlWorkflowPersistenceService (connectionString); _WFRuntime.AddService(stateservice); I created another solution with another project containing workflow2. When I add above two lines of code, application did not persist information and gave me following error: System.Type ...Show All

• SQL Server File System Task in SSIS

  Wanting to use File System Task in SSIS to move files from one location to another for archiving. I can't seem to figure out how to use a wild card for the file name. It seems that I must specify the actual file name which is a problem because only the first 4 letters in the file name remain a constant. Does anyone know how to use a wild card or a way to work this in Darrin Turner wrote: Wanting to use File System Task in SSIS to move files from one location to another for archiving. I can't seem to figure out how to use a wild card for the file name. It seems that I must specify the actual file name which is a problem because only the first 4 letters in the file name remain a constant. Does anyon ...Show All

• .NET Development Please help - XML check and validation

  Hi, I had generated the xml file and it looks like this < xml version="1.0" standalone="no" > <!DOCTYPE Book SYSTEM "Book.dtd"> <!--This file contains the book information--> <Book> <Science> <Code>1234</Code> <Title>Discovery in Science</Title> <UserCreated>John</UserCreated> <DateCreated>1/26/2007 2:11:11 PM</DateCreated> </Science> <Science> <Code>5678</Code> <Title>Discovery in Science 2</Title> <UserCreated>John</UserCreated> <DateCreated>1/26/2007 2:11:11 PM</DateCreated> </Science> </Book> I ...Show All

• Smart Device Development Display username from phone book to my own application

  Hi,   I am new in using C#. I am write a program for WM 5.0 pockect PC .I would like to display username on to the listbox from phone book to my own application using C#.   Thanks     Hi I assume you want to list the Outlook contacts. In this case have a look at the Microsoft.WindowsMobile.PocketOutlook namespace. These classes provide the functionality you need. Hope this is what you're looking for. Michael ...Show All