Pat1111's Q&A profile

• SQL Server Secure Access to database

  Hello Experts!! Let me start off by saying I'm not a SQL expert and have very limited knowledge on the topic. Here is my question: Our organization has an archiving solution that stores data in a SQL database. This applicaton creates two SQL accounts. One that is used to archive to the database. The second to browse the database from a search interface provided by the application. With all the federal compliance issues I see that they require the data to be stored in " a non-rewriteable and non-erasable format". My question is. How can I prevent the database from being erased in the SQL database As 'Administrator' I can open Enterprise Manager and open a table in the database and simply delete any record that I wish. I u ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. multi-GPUs program

  I'm interested in the programs using multi-GPUs. But this is not connected to SLI or CrossFire. I have two GeForce7950GT videocards, and I'm using these cards without SLI. Each videocard are connected to different one display. In this environment, GetAdapterCount function returns 2. Then, I use CreateDevice two times and executed same shader program in each device. As a result, 2nd device obtained lower performance than 1st device. Shader program is a simple filter program (but, executes loop calculation for enlarge computational effort), so CPU's loading is not high. So, I don't think CPU is bottleneck of this experiment. On the other hand, I created 2 devices and made 2nd device to execute shader program, the performance was lower than 1 ...Show All

• Visual Basic Crystal Reports Not in VS 2005 VB.NET Standard

  It's clear that VS 2005 VB.NET Standard does not include Crystal Reports.  - http://msdn.microsoft.com/vstudio/products/compare/default.aspx - http://msdn2.microsoft.com/en-us/library/b4z62wxz(en-US,VS.80).aspx - http://msdn2.microsoft.com/en-us/library/zcbsd3cz What is the MS the strategy for the standard user to get reports out    Buy Crystal Reports on the side for $200   Use Access It is possible to use the Crystal Reports application that was bundled with VS.NET 2003 in 2005 projects    Is there some data binding between Crystal Reports and SQL 2005 Express that would make it much easier to use as part of the bundled VS 2005 Professional package   Thanks! As to h ...Show All

• SQL Server Question regarding creating If Else functions in my report

  Hi, I'm new and i'm having trouble trying to create this query at the "DATA" tab of my rdl. What i'm trying to do here is passing 2 employee name from two drop down text box(doing a filtering with "From Employee" and "To Employee"), and assign it to a global variable which i declared. Is there something i miss out or i did worng which cause a error "Incorrect syntax near the keyword 'BEGIN'. (.Net SqlClient Data Provider)". It would be so helpful of you if links of website or previous post or any reference are provided, which give some basic tutorial on how to create codes as shown below. Thanks in advance DECLARE @G_StartEmp AS CHAR(10), @G_EndEmp AS CHAR(10) IF ...Show All

• Visual C++ using excel type library in vc++2005

  I tried to do the following example in vc++ 2005 but it wont comiple. It returns like 300 errors in excel.thl file. I havent even done the coding part, i just imported the CApplication.h and turned on the runtime support compiler option ( /clr:oldSyntax ) like the kb says and tried to compile.. help.. http://support.microsoft.com/kb/308407 Thanks. This appears to be working... at least for certain files. The code below managed to open excel files saved in 2003 format, but it fails to open or recognize excel files saved in 2007 format. I current have Office 2007 installed on the development machine, and the import library is referenced to the "Office12" folder. Even the _tfindfir ...Show All

• Visual Studio Embedding shapes in v1

  Hi, First of all congratulations on getting v1 out. It's looking pretty cool! I have been trying to migrate a DSL I developed in the June CTP version, but I have run into some errors. A couple of examples are.. Error 23 A GeometryShape may not be parented on a GeometryShape. In the ShapeMap mapping State to StateShape, the parent element path leads to StateManager, whose mapped shape is StateManagerShape. Error 26 A ImageShape may not be parented on a GeometryShape. In the ShapeMap mapping EnterCommand to EnterCommandShape, the parent element path leads to State, whose mapped shape is StateShape. Basically my DSL is similar to UML statechart notation, but I want to be able to nest states inside one another hierarchically in ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. InvalidCallException on SetCursorProperties call

  I am having a terrible time getting the cursor to work. I keep getting this error on the SetCursorProperties call: Microsoft.Xna.Framework.Graphics.InvalidCallException was unhandled Message="External component has thrown an exception." Source="Microsoft.Xna.Framework" ErrorCode=-2147467259 StackTrace: at Microsoft.Xna.Framework.Graphics.GraphicsDevice.SetCursorProperties(Int32 hotspotX, Int32 hotspotY, Surface cursorBitmap) at ElectricBliss.Game.Components.Game1.Game1_Starting(Object sender, GameEventArgs e) in C:\_projects\XNA\Camera\Game1.cs:line 124 at Microsoft.Xna.Framework.Game.OnStarting() at Microsoft.Xna.Framework.Game.Start() at Microsoft.Xna.Framework.Game.Run() at ElectricBliss.Game.Co ...Show All

• Microsoft ISV Community Center Forums VBA Word Can't find project or library

  I have wrote a VBA macro and in the macro I use visual basic functions such as "RTRIM$( )" and "STR$( )". When running the macro on a client's computer the error "Compile error Can't find project or library" comes up and it stops at the "Rtrim$( )" function. What is missing on the client's computer. Please help Thanks Paul Seo Thank you Andy. That definitely fixed the problem. Most of the macro works except for when I tried to write to a random access file, it comes out with "Run Time Error '59' Bad Record Length". The codes are quite simple, I read the record then set some string fields to the new string value and write it back immediat ...Show All

• Windows Forms Navigating forms in a SDI application

  Hi, I am writing an SDI app in (VB Express 2005) and want to navigate backwards and forward between forms. I can do this quite easily by overiding the constructors in forms using the "callingform" technique found in other posts. My problem is that 1 form needs to be opened from multiple forms. e.g. "Form1" or "Form2" can call "Form3". How do I sort out overiding the constructor for a case like this ...Show All

• SQL Server DTS package "Index Not Found Error"

  The Scenario is we have a development machine that is actually a virtual machine and we have a test server. Virtual machine is XP professional based machine and Test Server is Windows Server 2003 based machine. We have created a DTS package in Sql Server 2000 which copies data from 7 foxpro .dbf files to Sql Server 2000 based Database. This package when we test at our Development machine(Virtual Machine) works very fine, but when same DTS package is executed at Test Server it gives an Error, Below is the error which we found in DTS Logs. Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed. ************************************************************************** Step Error Source: Microsoft JET Database Engine Step Error Des ...Show All

• Visual C++ Question on FILEDESCRIPTOR Structure

  Hello All, I have been having some problems with the length of "file path + filename" greater than a certain number of characters (242 characters). The problem is occuring in the drag and drop operation. FILEDESCRIPTOR structure is used to describe the properties of a file that is being copied by means of the clipboard. I see that the MAX_PATH defined is 260 characters. I would like to find out if somebody encountered this situation and is there any function or property related to FILEDESCRIPTOR structure which can understand this path without any problems. Thanks, CPPUser7. CPPUSer7 wrote: Hello Peter, Thanks for answer, so if we have paths longer than 260 characters, we have to somehow ...Show All

• SQL Server Convert Int to Time

  I have a DB that gets telephone call information from a telephone switch. We use 3rd part software and a db to capture all of this. However for some reason most of the fields are stored as int DateTime is stored as an int. I am able to convert most of the date field from int by doing select convert(datetime,convert(varchar(8), localday)) that works fine the int are in the db as 20061029 for 10-29-2006. How ever I can't convert the columns starttime and endtime. They are also stored as int but They don't seem to store a date. For instance for the date 9/29/2006 the start time of one particular call is 1159533056 and the endtime is 1159533264 All i need to get from this is the time since I already have the date from another column. I can't f ...Show All

• SQL Server Restore does not leave database in usable state......

  So this is the c# code I'm using to do my restore from a backed up file, but after the restore is called the database cannot have sql statements executed against it. Any ideas are greatfully received public static void RestoreDatabase( Database db, string fileName) {      RecoveryModel recoverymod = db.DatabaseOptions.RecoveryModel;      DatabaseUserAccess originalUserAccess = db.DatabaseOptions.UserAccess;      db.DatabaseOptions.UserAccess = DatabaseUserAccess .Restricted;      if (db.ActiveConnections > 0)      {           MessageBox .Sho ...Show All

• Audio and Video Development The clock about Presenter of EVR

  Hi, all: I wrote a presenter to overwrite the composition of evr. In vista beta 2, I get a clock in InitServicePointers function. I use the clock to syncronize video frame, but the video and audio is not syncronized. But when I try again with Vista RC1, the clock always return 0. I am very confused. So 1. Should I use IMFPresentationClock or IMFClock for syncronization 2. Why the clock is freezed in vista RC1 Thanks Thanks for Becky. My problem is caused by we do not send any video samples at start time. That is because the first scene is a menu. When users click a item then we will start sending sample to evr. But without first video frame, it looks like the clock will not be fired. so I always get a 0 time. If ...Show All

• Visual Studio Express Editions Public and Private

  Is it possible to declare a string as public I know this seems like a stupid question but I am pretty stupid when it comes to VB. I want to be able to use a string in all my subs, functions and classes. Is that possible Yes very possible and easily accomplished....   Globally accessible..... Public Module Main Public MyString as String = "Blah" End Module   Class Accessible: Public CLass MyClass Private TheString as String = "BLAHBLAH" Public AString as String = "B" ... End CLass The first declaration would be available to your entire project, "TheString" would be available only to "MyCLass", Where "AString" would be accesible to MyClass and any objects that have access to " ...Show All