alpefusk's Q&A profile

• SQL Server Moved post "Tricky SQL Problem" from Robert3234 to TSQL forum

  Hi Robert, I moved the thread to MSDN Forums SQL Server Transact-SQL Tricky SQL Problem ...Show All

• SQL Server ReportServer and Dynamics CRM 3.0

  hi all i'm currently installing MS Dynamics CRM 3.0. on the check page before installing is an error: The Web Site for Installing SQL Server Reporting Services {0} uses an application pool of non-supported identity. Supported identity is Network Service. so, when i open the properties (tab identity) of the reportserver under application pools in iis manager prefered "Network Service" is choosen, this should by right. do i made any failure have anyone an idea, tanks dear riv Locate the Default Website and take note of the App Pool that it uses. Change the identity of the App Pool to use NETWORK SERVICE. Pre-installation check should now succeed. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Release .exe not working on non-Xna system.

  Hi, I sent a compiled version of the XNA shell program (blue screen only) to my friend who doesn't have XNA installed on his PC. Didn't work (crash with no decent debug info). After he installed XNA on his system, the .exe worked fined. Just thought you'd like to know. lushdog If they don't have the latest DirectX SDK installed they'll likely have problems. I'm still trying to track down what else needs to be included to get releases to run on a machine within XNA GSE. ...Show All

• Visual Studio Express Editions Must be non-negative and less than the size of the collection

  I keep getting the same error message when i start debugging. This recently started and I don't know why because i didn't change anything yet today. I could attempt to fix the problem myself but I the error message I get does not tell me where in the code the error is Does it It builds fine but freezes on the splash screen. - Thanks System.InvalidOperationException was unhandled Message="An error occurred creating the form. See Exception.InnerException for details. The error is: Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: index" I ran across this post looking for a solution to the same problem. What was happening in my case is th ...Show All

• SQL Server BufferTempStoragePath - Global setting?

  By default the BufferTempStoragePath is mapped to the user running the package's Documents and Settings folder. This is problematic when numerous packages are running simultaneously and using this disk location (i.e. sorts), and you don't have a large disk for your C: drive. The property of course can be changed. However the property is specific to a data flow task, so this would require developers to change the property is every data flow task of every package. Is there a global setting to change the default location that SSIS will use An alternative is to use configurations, however a configuration will be required for every data flow, as it is specific to the data flow task (and name of that data flow task) Any ideas Thanks ...Show All

• Visual C# Any way to access bluetooth device in windows XP

  There are some example for windows mobile 5, any body have example in windows xp with c# thanks ...Show All

• .NET Development who can i use single folder to upload to website using the same folder

  Hi, Does each website that we need to host on a hosting server need a root folder Is there any way that i can not place my Precompile files on root and make them working as we do in clasic asp. As we upload many website on sigle hosting location but in different folder Can we do this in case of .Net. Some time when i just want to host my Test WEBSite i need to find a location where i should host it. Because place where already a .Net site hosted have its own files on root to run the website properly. Kindly help me out. Thanks in Advance. with regards NooraliChagnai. They each need their own root folder (IIS virtual directory). This is needed because you need to configure what Application Pool they will run under, wha ...Show All

• .NET Development SerialPort ObjectDisposedException

  I use serialport on a form to communicate with serial port scanner. Sometimes(not always) I get this error: System.ObjectDisposedException was unhandled Message="Safe handle has been closed" Source="System" ObjectName="" StackTrace: at Microsoft.Win32.UnsafeNativeMethods.GetOverlappedResult(SafeFileHandle hFile, NativeOverlapped* lpOverlapped, Int32& lpNumberOfBytesTransferred, Boolean bWait) at System.IO.Ports.SerialStream.EventLoopRunner.WaitForCommEvent() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() Seriaport ope ...Show All

• .NET Development XPathNavigator.MoveToFollowing

  Hi, I am using MoveToFollowing method to get info about xml element which I want to modified or so. However after moving to one element I cannot move to the previous one! It is need to move to the root first. It is not a good solution. What should I do in order to have access to all elements no matter where they are thanks for help Ela I can use also condition if (navigator.MoveToFollowing || navigator.MoveToPrevious) { } It is not the best solution too but better than using MoveToRoot ...Show All

• SQL Server run sql query on multiple databases

  I need to run a same query on 15 different databases and union the results. Does any of the experts know how to do this with good performance Any help is appreciated. Phil....the only reason i posted in T-Sql is because i will be using this query in reporting services :) Thanks Rafael, could you tell me what toolbox item to use for "call the package 15 times, passing each time a different connection for the source..........." Thanks ...Show All

• Visual Basic Obtaining latest messages from a Chat server, need help

  I am trying to obtian messages from a chat server over UDP. It has to be periodic otherwise messages will get lost. My current code is: Dim udpClient As New Net.Sockets.UdpClient() udpClient.Connect( "ccdc.kick-ass.org" , 1079) Dim RemoteIpEndPoint As New Net.IPEndPoint(System.Net.IPAddress.Any, 1079) Dim receiveBytes As [Byte]() = udpClient.Receive(RemoteIpEndPoint) Dim returnData As String = System.Text.Encoding.ASCII.GetString(receiveBytes) TextBox2.Text = TextBox2.Text + returnData.ToString() udpClient.Close() Exit Sub In a timer control. I have two problems with this: This checks every 500milliseconds, which may tie up an internet connection. It crashes instantly ...Show All

• SQL Server New Diagnostic Logging Entries in SP2 CTP?

  Hello all- I installed SP2 CTP yesterday, and in the course of my testing ran one of my SSIS ETL jobs. I routinely log to database, and have a report designed so that I can easliy monitor the job performance, errors, etc. However, when running on SP2, there seems to be new Diagnostic entries that are logged, so much so that my 6 page report of events has now exploded into 337 pages. I have included a sample of the entries: 19838 2:13 AM ExternalRequest_post: 'ITransactionJoin::JoinTransaction succeeded'. The external request has completed. Data Mart Execution Logs User:Diagnostic Is anyone else experiencing this Did I miss a kb article I have looked around, and I find nothing. ...Show All

• Visual Studio Express Editions Local Or Remote

  Can someone please explain What is the definition of a "local" and a "remote" table Is a local - within your network Is a remote - somewhere in If a local is within your local network, how do you connect from other pc's. I asked a question the other day and someone made the remark that I would not have to use a mapped drive like I have with Access. How do you connect to the data What do you do to the other pc's to see the sql server There again- take it easy on me until I get a sharp as you. Bumfuzzled. David Great, I hope Whats an IDE Would it be better to use SQL 2000 while in developement Thanks for being a teacher today! ...Show All

• SQL Server Strange Problem with IBMDA400 OLE DB Provider

  Dear All, My objective to use SSIS to to pull data from DB2 and store into SQL Server. Working environment is: =========================== Database: DB2 UDB iSeries V5R3 Provider: IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider SQL Server 2005 SP: Latest i-e SP2 In connection manager, i have changed the following properties in OLEDB driver settings and connection with DB2 is tested successfully. 1- CATALOG LIBRARY LIST = AS/400 library 2- PERSIST SECURITY INFO = TRUE 3- INITIAL CATALOG = Database Name 4- Defualt Collection = AS/400 library After testing connection, I Created an OLE DB source and in OLE DB Datasource Editor set following properties: 1- VALIDATE EXTERNAL METADATA = FALSE 2- ALWAYS USE DEFAULT CODE PAGE = TRUE ...Show All

• .NET Development WSE 3.0 UsernameTokenManager not working plz help!

  Hi, Im using a custom UsernameTokenManager in WSE 3.0 but it always authenticates when it should'nt. I'm missing something but don't know what.     my Web Service code is: using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; [WebService(Namespace = " http://tempuri.org/ ")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [Microsoft.Web.Services3.Policy("usernameTokenSecurity")] public class Service : System.Web.Services.WebService {     public Service () {         //Uncomment the following line if using designed components         //InitializeComponent();   &nb ...Show All