Answer Questions

• PedroCGD The IDMClusteringAlgorithm interface

  Good morning, Well... I'm implementing a clustering algorithm following the examples given on the Managed Plugin Algorithms tutorial. As the samples are in C# and I'm implementing it on C++, I'm facing some problems, but nothing really significant. But I've some conceptual questions about the implementation: 1) It necessary to implement the IDMClusteringAlgorithm interface in order to implement the ClusterMembership() and the CaseLikelihood() methods, right 2) The changes needed to be done on the Navigation class have nothing to do specifically with clustering. These changes are only to set calculated statistics to be shown, and if I want, I can simply don't implement them. Is this correct 3) Is there any documentation on ...Show All

• DevDiver Help for a real newbie

  A problem so simple I'm a little embarrassed to post it... I am setting up a trigger in which I want to, among other things, record the network ID of the user who performs the action that triggers the trigger. I know there is a variable or function out there to pull that information, but I can't find it, and have tried every variation of "login logname usr_id network_id....." I can find. So first.... could somebody please tell me the variable or function that will return that piece of information. And second, if you also could point me to a good place, either in print or on line, to look up that kind of information, I would be most grateful. Thanks. Hello Leslie. The first thing to re ...Show All

• bud1024 problem with custom assembly

  Hi, I have problem with my my custom assembly: when i display the result localy in my report it's work very well but in web access with my Url http://localhost/Reports/Pages/Report.aspx ItemPath=%2fmydemo%2fReport2 i got a error message:#ERROR. As you can see my function return just string readed in text file. using System.Collections.Generic; using System.Text; using System.Security.Permissions; using System.IO; namespace SimpleDLL { public class SimpleClass { public SimpleClass() { } public static string returnString(){ FileIOPermission fileReadPerm = new FileIOPermission ( FileIOPermissionAccess .Read, @"C:\TempFold\Sample.txt" ); fileReadPerm ...Show All

• dvferretm percent computation

  Hi, First of all I would like to mention that I am new to SSAS 2K5 and MDX and this may be a classical problem. I have a classical sales cube with DimProduct, DimCompany, DimDate and FactSales. I would like to create a New Measure where the percent of the sales is calculated like Percent = (Sales Price - Purchase Price) / (Sales Price) * 100. What is the best approach to display the Percent at any level of the hierarchy for the Product (Category, Subcategory) and Company geographical location in the cube browser What Aggregate Function should I use Thanks in advance, GiMi. I have a similar issue regarding a calculation which combines a numeric Dimension column multiplied/divided by a Me ...Show All

• Rattlerr Cursor or Temp table

  Hi Chaps, I want to write a stored procedure in which I will update the all calendar week values (stored in a table). And to achieve this I will have to loop through all the records present in calendar table. I am just wondering that should I use Cursor or TEMP table (caz of performance issues) As it will be part of data warehouse so all the processing will be carried out at SERVER ( means no client) Can any one tell me that which would be the best solution ( Cursor or Temp table) in my case and WHY Note: I am using SQL Server 2005 standard edition waiting for quick reply. regards, Anas I want to loop through the records (for checking and updating purpose) i.e. one row at a time in one iteration tell ...Show All

• OldCDude Remote Distributor and Subscriber on same machine - is that OK?

  Hi, Server A houses the Production DB which services an OLTP system. Transactional replication is configured on this server which has two subscribers - on two separate servers (servers B and C). The Distribution database currently resides on Server A (which is also the Publisher). Server B is on the same LAN as Server A (on the same rack). I'm considering moving the Distribution database from Server A to Server B to offload some of the processing overhead from Server A. Are there any gotchas/performance problems associated with having the Distribution database (remote distributor) and the Subscriber on the same server (server B) in a transaction replication topology Please advise or point me to the appropriate documentation ...Show All

• chaza Can't log in to reporting services in my browser

  I've installed the Developer's edition of SQL05 on my PC at home. I am able to open the reporting services via the Manager Studio and Windows login under my username and password, however I cannot open it in my browser when I enter the http://computername/reports address. I get a login dialog and enter "computername/myloginID" for the user and my local login password. It will not accept the login and reprompt until I exceed 3 tries. I also tried logging in with the PC's admin id and password as well as the sa account name and password. Any ideas on what I missed in the setup or security Thanks for any assistance anyone can provide mike... That is correct, I wouldn't set up my servers with anonymous access e ...Show All

• Recycler Cannot connect w/ Java app but can connect w/ .Net app - SQL Server Express 2005

  I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005). The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running. SQL Server Express 2005 is installed in mixed mode. Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />. These are my values in my Java app web.xml - <init-param> <param-nam ...Show All

• Andy Wilkinson Problem in using USE dbname

  Hi, I am trying to monitor log and data space usage through dbcc sqlperf(logspace) and dbcc showfilestats commands on a server. what I want to do is to log all these for all the database using a cursor all work fine except User @db go inside the cursor body. Does anyone know any alternative to use this to what I want to get Thanks Ap Well your code had a few issues.  Here's a modified version that actually works (I removed brackets where they shouldn't have been, added parens for the EXECUTE, closed and deallocated the cursor at the end (make sure to always do that), and added a PRINT statement so that the cursor actually outputs something):   --- ...Show All

• logx Report Services - capture userid of person running the report

  I have a report which executes a stored procedure when the report is opened. What function will capture the identity ( name or user id ) of the person opening the report and therefore executing the procedure the first parameter of the report is UserId, string, hidden the available value is label UserId with value =User!UserID. The default value is non-queried =User!UserID the data source is: exec ReportBase.dbo.proc_TestUser '01/01/2006','01/02/2006',@UserID the procedure is: -- ============================================= -- Create basic stored procedure template -- ============================================= use ReportBase GO -- Drop stored procedure if it already exists IF EXISTS ( ...Show All

• xlordt Extract data from ACCESS database with pwd via ODBC

  Hi, My task is simple, I want to use the execute sql task editor to grab a value from a database in Access and put it in a variable. The connection is via ODBC and the access database is protected by a password. I've done all the preliminary stuff such as running profiler to make sure that the package is getting the call to the database, setting up the ResultSet to be "single row" in the general tab, mapped the Result Set correctly, but nothing works. I get the same error every time. This is my sql command: select count(FingerPrintID) as FingerPrint from Employee Result Set is set up like this: Result Name: FingerPrint ; Variable Name: User:: varDataset Here is the error I get: Error: 0xC0 ...Show All

• J.a.t Error when deploy SSIS with Deployment Wizard

  I've get error when I deploy SSIS package with Deployment wizard like this =================================== Could not save the package "C:\Documents and Settings\aun\My Documents\Visual Studio 2005\Projects\ImportCommittee\ImportCommittee\bin\Deployment\IMPORT_FS_DATA.dtsx" to SQL Server "(local)". (Package Installation Wizard) =================================== The SaveToSQLServer method has encountered OLE DB error code 0x80040E21 (Invalid character value for cast specification). The SQL statement that was issued has failed. ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, St ...Show All

• Forrestsjs Reporting Service Web Service from PowerBuilder 10.5 ...

  Has anyone implemented Reporting Service (Execution) Web Service from within Powerbuilder 10.5 I am trying to pass NULL value to the second argument of LoadReport function (to not get the History Snapshot) and the SOAP call gives an error message "String was not recognized as a valid DateTime". I could not pass Powerbuilder NULL (SetNull(StringColl) and StringCol passed as the snapshotID) value as the second argument to LoadReport as for some reason the Web Service could not be invoked. If I pass empty string (or 'NULL' string) I get the following error message. If I pass 'or '1900-01-01T00:00:00', then Reporting Service looks for a snapshot with this date and fails. Is there a way to send a string f ...Show All

• Donal Lafferty time format

  hello to every one well i have a calculated member in seconds and i want to represent it in the format hh:mm:ss in analysis serveces. my problem is that if the hours exceed the number 24 i want to display the hours for example 350:50:10. how can i achive that thanxs Well, this might be a totally round-about way to achieve this, but could you create a few helper calculated members (and make them hidden) to calculate just the seconds, just the minutes, and just the hours, and then a formatted calculated member that produces a string that just concatenates the values back together again Just playing around with this a bit in a query, I came up with the following (relying on some of the VBA function ...Show All

• Toinepoep calling a procedure from another procedure

  Maybe this isn't possible, but I'm trying to figure out how to call a procedure in a select statement where I can pass a new id each record found. Here is the procedure code that returns the desired results for any given ID: CREATE PROCEDURE proc_amEnrollmentTrackingDetailGet_cst @syStudentID INTEGER AS DECLARE @SATACT DATETIME, @HSTranscript DATETIME, @AcceptLetter DATETIME, @FAFSA DATETIME, @FinAidApp DATETIME --Get the last DateDue for each document type SELECT @SATACT = CASE WHEN cmDocTypeID IN (81,110) THEN DateDue END, @HSTranscript = CASE WHEN cmDocTypeID IN (83) THEN DateDue END, @AcceptLetter = CASE WHEN cmDocTypeID IN (126) THEN DateDue END, @FAFSA = CASE WHEN cmDocTypeID IN (150) THEN DateDue END, @FinAidApp = CASE ...Show All