Greg Withers's Q&A profile

• Visual Studio 2008 (Pre-release) [WCF-RC1] Adding claims in UserNamePasswordValidator

  OK, another dumb *** question (folks, I am _trying_ to research these things first before bothering you, and I'm starting to feel like a child who can't do his homework!) My STS is based on the Federation example in the RC1 release, and it uses a custom UserNamePasswordValidator to validate the client credentials. In the Validate method, I look up the user in the DB, validate the password etc and return true. Then, within the GetIssuedClaims override that "Issue" calls, I need to create the claims that will be added to the SamlToken. However, the values of the claims that I want to add are stored in the DB in the row that I just looked up in the Validate method, and I really don't see why I would need to look them up again. How c ...Show All

• SQL Server I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

  I got the following error Error: 823, Severity: 24, State: 4 I/O error 33(The process cannot access the file because another process has locked a portion of the file.) detected during write at offset 0x0000000a796000 in file xxxxxxxxx.mdf'. What happened to my database I cannot remind if there was another processing locking the file, what command I can use to check, is it related to the "auto growth" setting because my table size is 4.5G . thx ...Show All

• Visual Studio Express Editions VB6 and ms SQL 2005 DATETIME

  Morning, Could'nt find a post / site that has addressed this issue and I would be very surprised if I'm the first to find this. I am currently having an issue passing a parameter via a stored procedure in vb6 to SQL 2005 that is requiring a datetime format. VB6 supports these separatly i.e. DATE, TIME were as VB.Net etc. support this as DATETIME. Is there any way I can get the date into the SQL 2005 database, not fused about the time part as this would help being stored as 00:00:00. What I've tried so far is: strDate = Format(strDate, "yyyy-mm-dd 00:00:00") but when passing through it details parameter not supported: .Parameters.Append .CreateParameter("dteDate", adDate, adParamInput, , dteDat ...Show All

• Smart Device Development Can't create an extension menu

  Hi,   (didn't get luck in " Smart Devices General  " forum,  maybe in here.. )   I created an extension menu (in the outlook), but It doesn’t appears in the menu.. I did the following:   registered in :   KEY_CLASSES_ROOT\CLSID\{GUID}   and in HKEY_CLASSES_ROOT\CLSID\{GUID}\InProcServer32   and also under: LOCAL_MACHINE\SOFTWARE\Microsoft\Shell\Extensions\ContectMenus\Inbox\Read_View\   I have also signed my code, but as I said, I cant see the menu item. target devices are Cingular2125 and Samsung Blackjack   any help will be appreciate..   Oren Hi, I'm sorry for not responding to ...Show All

• SQL Server Forcing Function recompilation in SQL 2000

  A stored procedure in the cache is automatically recompiled when a table it refers to has a table structure change. User defined functions are not. Here's a simplified code sample: set nocount on go create table tmpTest (a int, b int, c int) insert into tmpTest (a, b, c) values (1, 2, 3) insert into tmpTest (a, b, c) values (2, 3, 4) go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fTest]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[fTest] GO CREATE FUNCTION dbo.fTest (@a int) RETURNS TABLE AS RETURN (SELECT * from tmpTest where a = @a) GO select * from fTest(1) CREATE TABLE dbo.Tmp_tmpTest ( a int NULL, b int NULL, d int NULL, c int NULL ) ON [PRIMARY] IF EXISTS(SELECT * FROM dbo. ...Show All

• Visual Basic SQL and variables

  I am having a problem with an sql statements in my VB.net form. The DB is access and the sql is as follows: SELECT [firstname], [surname], [activityId] FROM tblTraveler WHERE [bookingID] = booking Booking is a integer variable, I am not to sure if I have entered the variable correctly into the sql. When I run it it says that there is a missing parameter. Can anyone see the problem here Thanks in advance Graham the best way, best practice, of doing the above as given by Lars, is to use Parameterized queries. it helps the confusion to become clearer as well as being securer: Dim Query as String Dim Booking as Integer = 1 Dim command as new SqlCommand( "SELECT firstname, surname, activityId FROM tblTraveler WHERE booking ...Show All

• SQL Server sp_executesql and speed

  Hello, I am using sp_executesql this to pass parameter to sql string and I am seeing deadlock between sp_prepexec which does UPDATE with another UPDATE done by another process. When it comes to speed and deadlock, would you recomand not using sp_executesql Deadlock just indicates that your application is performing certain dependent operations in the wrong order or making incorrect assumptions about concurrent access to certain resources. So this is not really artifact of using sp_prepexec or sp_executesql. Both these system SPs will be used by drivers/providers for efficient execution of statements. They provide parameterization capabilities and efficient cache lookups upon execution of the command. So you need to first di ...Show All

• Windows Live Developer Forums Robot Invaders Contest Winners

  It's time to annouce the winners for the Robot Invaders contest. The contest ran from May 15th to September 15th and in the end 53 Messenger bots were accepted as valid entries in the contest ( per the how to compete guidelines ). Each entry to the contest was judge by three judges separately using the Judging Criteria outlined on the How to Compete page and then the judges scores were averaged. There were a lot of great robot's submitted but here's the winners: Title Prize LiveBot Grand Mother Nature 1st Spleak 2nd Mobile Record bot 2nd Virtual Secretary 2nd Dr Phile Knowledge 2nd Comtec Travel Bot 2nd Search Bunny 3rd ...Show All

• SQL Server Cluster failing connections with SSL error message

  We recently migrated our production environment from a win2k3/SQL 2000 EE cluster to a new 64 bit win2k3/ SQL 2005 SP1 Cluster. Cluster works fine for a while (3-6 hours), then our logins start failing. We recieve the following error in the event log: "The server was unable to load the SSL provider library needed to log in; the connection has been closed. SSL is used to encrypt either the login sequence or all communications, depending on how the administrator has configured the server. See Books Online for information on this error message" The only way to resume connectivity is to offline and online the sql service in the cluster. The only reference to this error that I can find has something to do with a hotfix tha ...Show All

• Smart Device Development Treo 650 no longer reads windows media player

  Ok, here's the skinny: I had windows media player 9,10 and was using Pocket Tunes music emulator for music for my treo 650, which works great with both until I downloaded media 11 Beta. At first, everything was fine- syncing was flawless and files were going great on the first five syncs. after that, it no longer reads the application is connected at all. I made sure it was connected(even used contact cleaner on the points) but i had to switch to media player 10 for it to work, but it when I reload WM11 it will no longer work! Any suggestions will be appreciated. MuscleImpala Sorry but this is a development forum and not a mobile device support forum. you may need to contact the manufacturer or visit t ...Show All

• Visual Basic Datareader and Stored procedure.

  I have written some code using a datareader and so far it is working fine. However my sql string is getting rather cumbersome and difficult to read and it seems sensible to use a stored procedure instead, especially since I will be extending the search criteria on the select statement. This is the code I have at the moment: Dim cnRHG As New SqlConnection( My .Settings.Red_Hot_Group_SystemConnectionString) Dim strSQLPossDupes As String strSQLPossDupes = "SELECT Customer_Name.Cust_Name_Family,Customer_Name.Cust_Name_Given_1, Customer_Name.Cust_Name_Given_2 FROM Customer_Name WHERE Customer_Name.Cust_Name_Family = " + strSurnameSearch Dim cmPossDupes As New SqlCommand(strSQLPossDupes, cnRHG) Try cnRHG ...Show All

• Visual Studio Tools for Office Help with Pulling in data from Access to Word & Excel!

  I'm trying to be able to pull in data from Access into a Word & Excel templates. I want this information to auto populate corresponding fields in the templates by inputing one primary key data. Help! Hello, Are you using VSTO to create Word & Excel templates If so, the following sections of the VSTO help documentation may help: Connecting to Data Data Binding ...Show All

• SQL Server Row yielded no match during lookup

  In SSIS. I am having trouble exporting records that don't match from a lookup transformation. I get the following error: Row yielded no match during lookup. I would really like to have a list of all records that did not match so that I could send an email of those missing rows Please give me solution with example Thanks That is happening because your are using the default error configuration of the Lookuptask "Fail Component"; it would fail if a no match occurs. You need to change that to 'Redirect row' and then use the error output of the task to send those rows to whereever you want. Rafael Salas ...Show All

• Visual Basic Redirecting Processes's StandardOutput! Need a help here.

  Hello VB developers! I got a problem redirecting processes's standardoutput! I'm trying to put all the output of a console application in a textbox in my project, but I can't! =/ I have developed this code in Visual Basic .net 2003 to do it: Dim Proc As New Process Dim pInfo As New ProcessStartInfo(Textbox1.Text) 'In text1.text I got the file path pInfo.UseShellExecute = False pInfo.RedirectStandardOutput = True Proc.StartInfo = pInfo Proc.Start() Textbox2.Text = Proc.StandardOutput.ReadToEnd() But I think nothing is changed in the textbox. Hugs! Sure but as its an infinite loop - when do you expect the process to end to capture the output and your clearing the screen each time. I think your problem is ...Show All

• Visual C# InvalidCastException: Unable to cast COM object of type "MapPoint.ApplicationClass" to interface type "MapPoint._Application"

  Hi there, I've got the following problem: I try to build a simple application with VS 2005 and MapPoint 2004. I read an article ( http://www.mp2kmag.com/a103--chandu.thota.net.framework.mappoint.html ) and tried the given example. It didn't work... So I tried to build the code line by line: using MapPoint; /* ... */ public Form1() { ApplicationClass app = null ; app = new ApplicationClass (); app.Visible = true ; /* ... */ } At line five I get the InvalidCastException mentioned in the subject above (the message may vary, though I translated it from German). Even before this line is executed, the debugger gives me the information, that the object app has InvalidCastExceptions on all variables... ...Show All