Jay Thomas's Q&A profile

• SQL Server Not Connecting to a remote SQL server with OLEDB

  Hi, I can connect to a remote SQL server with ADO.NET but not with OLEDB. I get ------------------------------ Test connection failed because of an error in initializing provider. Login timeout expired An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. Named Pipes Provider: Could not open a connection to SQL Server [233]. ------------------------------ Through the SQL Server Connection Manager, if I disable Named Pipes and enable TCP/IP, I get for OLEDB connection: ------------------------------ Test connection failed because of an error in initial ...Show All

• Visual Studio Team System Closed versus Resolved

  I'm sure that this has been talked about before, or perhaps its just a very stupid question, but i can't find any information on this. What is the difference between a work item being "Closed" and a work item being "Resolved " I know that when checking in changesets, you can only set them to resolved, not closed. But working directly with the item, you can set them to either. Any help would be appreciated. Thanks in advance. Thanks to both of you for your responses. It makes a whole lot of sense. I was thinking something along those lines anyway, but i wasn't sure and some of the user interface confused me a bit on that. Thanks again! ...Show All

• SQL Server range - left our join

  hi all, how can i do a range left outer join. i know how to do a ranged lookup but it does not allow null. example: suppose I have tables t1 and t2 in table t1 I have fields f1 and f2 and in table t2 I have fields f1, f2 and f3 I want to left outer join t1 and t2 on t1.f1 = t2.f2 and t1.f2>t2.f2 and t1.f2<t2.f3 in other words. t1.f2 is betwee t2.f2 and t2.f3 thanks, joey Do it with a where clause as a lookup SQL command SELECT FROM LEFT OUTER JOIN ON t1.f1 = t2.f2 WHERE t1.f2>t2.f2 and t1.f2<t2.f3 ...Show All

• Visual Basic WriteProcessMemory() Api Help

  I have a problem with WriteProcessMemory() that I am trying to use. My code looks like this: Public Declare Function WriteProcessMemory Lib "kernel32" ( ByVal hProcess As Integer , ByVal lpBaseAddress As Object , ByVal lpBuffer As Object , ByVal nSize As Integer , ByVal lpNumberOfBytesWritten As Integer ) As Integer Dim appProcess as Process *gets the process* ' I know it works Dim offset As Long = 29689060 Dim value As Long = 3 WriteProcessMemory(appProcess.Handle(), offset, value, 4, 0&) What I am trying to do is to write the memory adress (01C504E4, decimal value 29689060) with the value of 3. The data type is a long, (4 bytes). Is there anythin ...Show All

• SQL Server Login failed for user 'XXXX\ASPNET'

  Hi all, I review my server report from my asp.net app through reportviewer, and I got this error: Cannot open database "myDB" requested by the login. The login failed. Login failed for user 'XXXX\ASPNET'. I use username and password to login my app, and 'XXXX\ASPNET' is my ASP.net service account. Any idea Thanks, Jone Hi Konstantin, Thanks for your reply. I changed the credential from "Windows integrated security" to "Credentials stored securely in the report server" and entered my username and password that I used to login my machine. Then it woks well now. But I still have a question about this: after this project being delpoyed, many other ...Show All

• SQL Server @!#$%^&*( SSL/TLS

  OK, I have a fresh installation. I installed SSL prior to SQL Server 2005 and let the installer create the default configuration. SSL is working, cert auth is in place. Started up Report Manager and it is working. Tried out Report Builder and it is working just fine. I go to run some reports, I get the parameters (some are dynamic) working fine. When I go to render the report I get the almighty dreaded The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure. Anyone have any ideas what is going on Report Server Virtual directory is set to 3 - All Soap APIs. Just to recap, Report Manager, OK. Report Bui ...Show All

• Software Development for Windows Vista Why I can not intall the application?

  In the preparation of the test case, in step S.13:attach the application install executable to AppVerifier including msiexe.exe In my installation,I have a a.msi file and a setup.exe file. Does this step mean I have to attach them both or only attach setup.exe or a.msi only I do the above thing in an administrator privilege,and when i switch to logotestuser1,I cannot install it. please tell me why this happened and what' wrong with I do Folowing your instructions i have been left with a number of errors but cannot make any sense of the results that the app verifier gives me. Please find below two cases of the results i would grateful if ou could explain where i'm to find the Denied Access code that I an search MSDN ...Show All

• .NET Development Delegate / event and serialization with SOAP

  Hello! When I tryed to serialize the Class1 object (by calling the save_Click..) I got the following exception message: "Type 'Hello.Form1 in Assembly 'Hello, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' is not marked as serializable". How can I solve this problem Is there a way to tell the SoapFormatter() that events/delegates don't have to be serialized //////////////////////////////////////////////////////////////////////////////// Form1.cs //////////////////////////////////////////////////////////////////////////////// namespace Hello { public partial class Form1 : Form { private Class1 myClass; public Form1() { InitializeComponent(); myClass = new Class1(); // I think th ...Show All

• .NET Development Async HTTP POST/GET in VB .Net 2005 !!

  Hi, I am a VB6 developer and I am learning VB 2005, I wanted to know how can I make HTTP POST AND GET requests in asynchronous mode , I wanted to use it to download file from HTTP servers Simultaneously (probably using multi-threading). Thanks. This is what I came up with.. I was also having the same problem, for my problem I had made this works for me. (I am learning VB 2005, so dont expect too much) Public Sub PostData(ByVal strURL As String, Optional ByVal POST1 As String = "", Optional ByVal POST2 As String = "") Try ' Declare a variable named client of type WebClient. Dim myWebClient As WebClient ' Instantiate a WebClient object and assign it to the 'client' ...Show All

• Visual Studio Express Editions Lesson 5/Absolute Beginner

  Hello. I recently started the Absolute Beginner Video series and am on Lesson 5. During the example on intialized arrays, I entered the code from the video (see below) but got a little red box under the comma following "Bob". It suggested that a ) was expected and won't run the program. Did I mistype this or is there some other problem (like a change between the Beta which video uses and the release version) Offending Code: Dim myotherarray() As String = ("Bob", "Beth", "Conrad", "Grant") MessageBox.Show(myotherarray(2)) ~R. Nobles Reminobles wrote: Dim myotherarray() As String = ("Bob", "Beth", "Conrad", "G ...Show All

• Visual Studio Express Editions SAVE ENCRIPTED PASSWORD INTO ACCESS DATABASE

  i have an input text that asks for the user to put a password on it..and a button that sends the string to this function i found in the forum to encrypt the code.. Public Shared Function HashPassword( ByVal password As String ) As String Dim sha As New SHA1Managed Dim passwordBytes As Byte () = Encoding.UTF8.GetBytes(password) 'compute the hash Dim hash As Byte () = sha.ComputeHash(passwordBytes) Return Convert.ToBase64String(hash) End Function this function returns the password encrypted, now...i need to save it in my Access database... Personal.mdb EmployeeID:string; Name: String; LastName: String & Password:String. My idea is just to save the result from my ...Show All

• Visual Studio 2008 (Pre-release) xbap's can't upload images??

  Further to http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=789627&SiteID=1 : It seems that using BitmapFrame.Create(...) throws an exception due to MediaPermissionImage being set to "SafeImage" for xbaps. Since this function seems to be the universal method to stream an image, as in: TiffBitmapEncoder encoder = new TiffBitmapEncoder(); encoder.Frames.Add(BitmapFrame.Create(image)); encoder.Save(stream); and a stream can be used to get a buffer: stream.getbuffer then you can't use a web service to upload an image using a byte array, from the buffer, as an argument. Naturally, that is the technique I have been working on. Is there an official way to sent an image to a web service function wi ...Show All

• Windows Forms beep generates no sound

  the Beep method generates no sound, the volume is on i checked Remco Either method mentioned requires the Default Beep to be set in Sounds and Audio Devices. Rather get your own .wav file and play it, if you require it to be played even if sounds are off. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multi threading in a game (using XNA)

  Hello. I am able to create thread and make them exchange information through common objects they know (server / each other reference) Now I would like 2 threads to update a server. Each of those threads takes for inputs a keyboard for one, a mouse for the other one. However, it seems that the thread that listens on the keyboard do not detect events from it. Seems like it is the parent thread that is able to listen to a keyboard event and only that parent thread. How would you do so that a children thread is master over a device even if it does not have the focus Regards, Chryso As far as I know (which isn't that far, really), XNA is designed for all XNA-based activity to happen on the main thread. You ca ...Show All

• Visual Studio Express Editions WebBrowser non event

  I have a problem with WebBrowser when I navigate to a URL where the document doesn't complete under certain circumstances. First, the code... Dim wb As New WebBrowser wb.Navigate(URL) Do Until wb.ReadyState = WebBrowserReadyState.Complete MsgBox(wb.ReadyState.ToString) Loop MsgBox( "Finished" ) It never exits the Do Until loop unless I have the msgbox(wb.readystate.tostring) line in there. This seems to allow the application to do events. I get the same problem using the document completed event (it never fires unless I have the MsgBox line in the loop). I am using this code within a class and I can get it to work if I put it within a form class because I can put My.Application.Doevents in the ...Show All