CharlieRussell's Q&A profile

• SQL Server Help: Append Parameters in ASP classic

  Hi, Please tell me what is wrong in the following code to get the RecordSet by calling the Stored Procedure . '============================================== Dim StaffRS, objComm, objParam1, objParam2, objParam3 'Set RecordSet, ADODB.Command Set StaffRs = Server .CreateObject("ADODB.RECORDSET") Set objComm = Server.CreateObject("ADODB.Command") objComm.ActiveConnection = conn 'conn was set earler objComm.CommandText = "GetStaffReport" 'Stored Procedure objComm.CommandType = adCmdStoredProc '**Error line** 'Append Parameters set objParam1 = objcomm.CreateParameter ("People_ID", adVarChar, adParamInput, "123") objComm.Parameters.Append objparam1 set objparam2 = objcomm.CreateParameter (&qu ...Show All

• Visual Basic form loading on screensaver activation

  How do I load a form in an already running application when the screensaver activates Basically, to give some background to the problem, I want a full screen application to 'lock' itself, and require the user to input a password when the operating system's screensaver activates. This locking thing is nothing to do with os security, just the security of my application. I have sorted the 'lock' bit out, it's just how to get it to 'lock' itself when the screensaver activates I'm new to VB, and am young, so I have no idea where to begin on this problem, so some help would be greatly appreciated. thanks in advance ST W The code I posted last actually works, there is a problem with WMI on the ...Show All

• SQL Server compile a store proc again

  Hi there!! Can we force stored procs in a database to recompile and see if there is any compile time error in the stored procs then and there. Something like sp_recompile which marks Stored Proc for recompilation and compilation occurs later on. I am looking for something which will force the existing stored procs to compile and let me see the error if any. Best Regards Rahul Kumar, Software Engineer, India Yep, TSEQUAL is gone for good in 2005 ( http://sqljunkies.com/Forums/ShowPost.aspx PostID=2534 ) but it wasn't documented for quite a while. It isn't necessary, so you can change: tsequal ( TmStp , convert ( varbinary ( 8 ), convert ( bigint , @xTmStp ))) to TmStp = ...Show All

• Internet Explorer Development IE7 the culprit? outlook express hotmail problem

  I use OE6 to archive my hotmail locally via dial-up until I installed IE7 and then I'm requested to logon when synchronizing my hotmail folders. I have not been able to logon yet and synch my mail. I also have McAfee security running and have disabled it to see if the connection is being firewalled to no avail. I just need to know for sure if hotmail is no longer available to OE users or there is an easy fix to restore what was a very handy facility. Help! Afew minutes after I posted this I found KB907942, an obscure update that Most Magnificent Microsoft has for just this problem. I will repost if it doesn't work. I have the exact same problem with both my SMTP and POP3 accounts in outlook (Outlook ca ...Show All

• SQL Server Subscription sends 2 emails

  We have SQL server 2005 Reporting Services SP1. In Report Manager I have a shared subscription that runs every hour between 8am and 6pm (I created the shared subscription in Report Manager, then modified it in Sql Server Management Studio to run the hours I wanted). I have a second shared schedule that runs Tuesday and Friday at 7am. For 2 separate report subscriptions - one uses the hourly schedule and the other uses the 2-day schedule, the first time they run during the day it sends 2 email - after that it sends only 1 email, as it should. I created a subscription to email a report when the report content is refreshed from a report snapshot. In Properties...Execution, I selected to render this report from a report execution snapshot, an ...Show All

• Software Development for Windows Vista Service started very late in Vista?

  I have a service program with OWN_PROCESS, AUTO_START, no any dependency. This service works on Vista as well as w2k/wxp, except the Vista start it in a very late statement. In w2k/wxp, my service program can start before user logon. But in Vista, even the user has logon, it takes about 40 or more seconds before my service program start running. My PC is Celeron 3.0GHz, with 1GB RAM, I don't think it's the hardware's problem. Since my service is one part of the drivers for an input device, this is very important for me to load the service ASAP. Does any one know how to boost the load order for this type of services We ran into this problem, too, and just found the problem. If you have an ethernet card or interface that is c ...Show All

• Visual Basic How to create an installer

  Hello all, I have created a Visual Basic .NET 2003 .exe. I thought I could simply put it on another computer, and it would run. That didn't work. I believe I have to write an installer and include the dll files, as well. Do I have to write an installer, or can I simply put the .exe and the dlls on the other computer If I have to write an installer, would you please let me know how to get started and where I can find info. on how to do this Thanks, Kathy In the most basic of cases you might be able to simply copy the files, but the other computer would need to have the .NET Runtime and any other prerequisite files installed first. A better way to do it is by using a Setup and Deployment project to ...Show All

• SQL Server Getting Status/History Info. from .exe that is Run by a Job

  Hello. We're using SQL Server 2005 and SQL Server Agent to run some jobs. These jobs execute a custom .exe program (written in C#). What we're wondering is, is there any way to send status/history information from the custom .exe back to the job that kicked it off We're trying to provide execution info. to show if the job succeeded or if some error occurred in the .exe (thus the job didn't complete successfully). Thanks! ...Show All

• Visual C++ problems with DirectX program

  My DirectX program doesn't work. It gives me no errors, but if I run it, it gives me errors. What's wrong with it I do not write my mywin.h and basic.h here, because they are not important and work correctly. Procedures from those header files are Logi, MkWin and ReggWin and TPump, so do not be confused of them, just ignore them. My code is here: main.cpp: #define WIN32_LEAN_AND_MEAN #include <D3d9.h> #include "mywin.h" #include "basic.h" #pragma comment ( lib , "User32.lib" ) #pragma comment ( lib , "d3d9.lib" ) WNDPROC wndProc; HINSTANCE hInstance; HWND _hwnd; HRESULT hr; IDirect3D9 *g_D3D=NULL; ...Show All

• Visual Studio Team System Visual studio locking up when doing TFS stuff.

  Hi, I am wondering if anyones else is having a similar problem as me. It seems at certain times when I do various actions (getting latest code, checking in something) the action completes and then Visual Studio locks up to the point where I have to kill the devenv.exe from the task list. It has happened to me quite a few times now. I am running the VPC image for the server and have installed the TFC from the en_vs_2005_tfs_trial.iso file. I really like the product and have convinced my manager we should move to it but I can't really do that in good faith if the team is going to lock up frequently. Cheers, Clint There is a known issue where automerging a file can hang. Are you trying to check in a file that someone else ha ...Show All

• SQL Server SSIS Crashes while validating Data Flows

  Hi all, I'm stuck here when I try to open an existing package which contains several data flows, SSIS tries to validate each data flow and after a while a Visual Studio error message pops up and I can't do anything.  The error message says : "Unable to cast COM object of type 'System._ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject90'. This operation failed because the QueryInterface call on Com component for the interface with IID '...GUID...' failed due to the following error : The application called an interface that was marshalled for a different thread. (Exception from HResult: RPC_E_WRONG_THREAD)" Did anyone has seen this error message Any help will be appreciated. Sebastien ...Show All

• .NET Development SQL LIKE QUERY WITH A PARAMETER

  I have a problem with a LIKE query in vb.net. I want to run a query which will output all of the usernames that end with a certain character. I need to use a LIKE query but I am not sure how to use a parameter. I have tried this: SELECT Username FROM TblUsers WHERE (Username LIKE '%= ') ORDER BY Username This does not work because it does not allow me to enter the value I want. If anyone can help I will be grateful. Thanks Hi there VMazur. Thanks for posting some help. The following error appears after the cn.open() part of the code: "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 ...Show All

• Windows Forms Trying to add an inherited interface as an Object DataSource adds only the child fields

  I have a grid that I want to associate to an object datasource. I also have two interfaces: 1. IFirst <T> 2.ISecond: IFirst <int> When I add ISecond DataSource to the application through the "DataSource Configuration Wizard" it only adds the properties of ISecond and ignores IFirst. What can I do Maybe there's a way to edit the ISecond.datsource file ...Show All

• Visual Studio Express Editions how to set pre-defined properties for a structure elements?

  Hi, Don't know how to put the title more clearly, but anyway what happens is that I have defined a structure type in my project, see below: Structure Cols_Structure Dim label As String Dim x As Single Dim y As Single Dim Shape As String '...0: rectangle, 1: Circle Dim A As Single '...Dimension A, or Diameter Dim B As Single '...Dimension B Dim Angle As Single End Structure Public Columns(50) as Cols_Structure for Shape element, there are only two choices allowing user to set, one is rectangle, another is circle, how can i implement this say for the statement such as: Columns(1).Shape= .. what should i do so the intellisense will let me choose from either "rectangle" or "circle" ...Show All

• Smart Device Development Running a device APP on the PC thru Pocket PC 2003 SE Emulator

  The code below runs fine thru a windows APP., but does not run thru the pocket pc 2003 se emulator. Is there something wrong in the My.Computer ... portion of the code Please help. Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim file As System.IO.StreamWriter Dim Record As String = CStr (TextBox1.Text) Dim procID As Integer file = My .Computer.FileSystem.OpenTextFileWriter( "C:\HSP1.text" , True ) file.WriteLine(Record) ' Run batch file. procID = Shell( "C:\HSP1.bat" ) ' The preceding path is for Windows XP. ' The Windows 2000 path is C:\HSP1.bat. End Sub ...Show All