Jamie Thomson's Q&A profile

• Microsoft ISV Community Center Forums MS Access & Windows Media Player

  Hi Im using Windows Media Player on a MS Access form and I can't get the current Time of the video. Any ideas Thanks Sean WindowsMediaPlayer1.Controls.currentPositionString will give you the current position of the video clip or music file while WindowsMediaPlayer1.currentMedia.durationString will give you the total duration time of the selected video clip or music file. So, in that case you could try: Label1.Caption = WindowsMediaPlayer1.Controls.currentPositionString & "/" & WindowsMediaPlayer1.currentMedia.durationString Hope this helps. (^_~ ) ...Show All

• SQL Server DB mirroring + load balancing

  Is it compatible to set up SQL DB mirroring on 2 different physical servers (High availbility + FULL transaction safety + Automatic failover with a third server as witness) and simultaneously set up network load balancing between these 2 servers (option with Windows Server 2003 Enterprise) If yes, which type of licenses do I need and how many (for SQL server 2005 and Windows Server 2003) with such a configuration - 4 physical servers in total : A, B, C and D - load balancing between A and B (same application) - load balancing between C and D (same application) - A hosts principal DB X, B hosts mirror of DB X - C hosts principal DB Y, D hosts mirror of DB Y - D is witness for A and B - B is ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Spacewar failed to launch...

  Error 1 Error code: -1 encounted when initializing FBX file loader. The file is either corrupted or it is not a valid FBX file. C:\...\Visual Studio 2005\Projects\MySpacewarWin1\MySpacewarWin1\Content\Models\p1_pencil.fbx MySpacewarWin1 corrupted :( np - . . :\NonUnicodeFolderName\ yes but it's likely because of your My Documents folder (C:\Documents and Settings\UserName\ \...), just change it's destination ...Show All

• SQL Server INSERTING NULL VALUES VIA STORED PROCEDURES

  Hi, Becouse some of my stored procedure parameters can be NULL, for every parameter with potential NULL value I have to do checking like this: errorParams[3].Value = (e.InnerException== null ) ( object ) DBNull .Value:( object )e.InnerException; When I do it like this ( it is a part of preparing values for insert ): errorParams[3].Value = e.InnerException no row is added. Is there any way to pass over that check : (e.InnerException== null ) ( and do it easier   This the sample exception message for that issue: {System.Data.SqlClient.SqlException: Procedure or Function 'sp_addError' expects parameter '@InnerException' , which was not supplied. Thanks, Pawe That depends ...Show All

• Visual Studio 2008 (Pre-release) SVCUtil.exe

  Hi All, I am working in WCF. Here my questio is, is it neccessary that to have Winfx SDK installed on the machine to use the SVCUtil.exe Next question, is there any advantage of using SVCUtil.exe instead of Add service reference Regards, Santha Hi, I have generated the proxy using SVCUtil.exe but I haven't install the SDK. Regards, Santha ...Show All

• SQL Server Generate SQL for a table

  Hi I have two questions i) is there any SP which will generates SQL Script for a table including all constarint(PK,FK), index etc. and the table data in the format of "INSERT INTO" . if NO, how can i create to do so, or any other SP which will help me( may be third party one) ii) Where had "Scptxfr.exe" gone in SQL Server 2005 Regards, Thanks. Gurpreet S. Gill   Gurpreet Singh Gill wrote: Hi I have two questions i) is there any SP which will generates SQL Script for a table including all constarint(PK,FK), index etc. and the table data in the format of "INSERT INTO" .  if NO, how can i create to do so, or any other SP which will help me( may be third part ...Show All

• Windows Search Technologies CAN SOMEONE HELP PLEASE? WDS STILL NOT WORKING

  Hi Everybody, It's getting very frustrating that WDS Beta 2 is still not working for me. It only works from within Outlook 2007 beta 2 technical refresh 2, but i always get " NOTHING FOUND " from the normal Search Deskbar.This while i basically went through all possible settings 100 times and installed, deinstalled and reinstalled the product multiple times, the last two weeks. Also if i install another search engine, like your friend Google or Copernic, it works instantly. Something must be broken somewhere, but everything else on my computer is working fine and actually it's quite a fresh install. Can somebody please make a point about this and help me out Am i the only one with this problem, i can't imagine. Sure, ...Show All

• Windows Forms Problem with DataGridView ??

    I'm facing a problem, I have 2 tables in the RemoteDB, and same tables in a LocalDB. Companies Table ( CompanyID , CompanyName, ..etc).    CompanyID is a PrimaryKey. Employee Table (EmployeeID, ... , CompanyID ).   CompanyID is a ForigenKey.   My program retrieving the a specific Employee Info, with his Company info (if its not exist in the LocalDB) and saved it in a LocalDB. The program showing the Employee Table Cells in a " DataGridView1 ". Insted of showing the CompanyID as a code I'm showing the CompanyName by changing the Column Type to DataGridViewComboBoxColumn and do the rest...etc.. I have no problem with that at all, all data is appeared perfectly. when ...Show All

• Visual Studio Express Editions Check Database for category name

  I am trying to figure out how I can make an if then that will check to see what the name of the category is inside my database. if categoryname = "cat name1" Then something will happen End IF Bruno, I'm not sure you understood the OP's question. He has a database and the database has a category name. He wants to be able to retrieve that. Much more information is needed from him on the kind of database, and the database topography before the question can be answered. ...Show All

• SQL Server database owner is needed

  hi, on 1 of my servers (actually, the dev. server I have setup up here at home), I must included the database owner everytime I select something or make a db call. for example select T.foo from K inner join T on T.id = K.id must actualy be written like: select dbo.T.foo from dbo.K inner join dbo.T on dbo.T.id = dbo.K.id or else it wont work what did I do wrong for this database owner thing to be a "must" when writing queries on this server. spec: sql 2000 sp4 > What do you get on the server that requires dbo. when you execute: >select suser_sname(), user_name() | ______________|__________ | foouser | foouser >select * >from sysobjects >where name = '<name>' ...Show All

• Smart Device Development Multiple instances of an application - bad

  I have an application running under WindowsMobile5.0. I have used the code below to make sure that I only get one instance of the application (I'm talking to a SDIO module - don't want more than one instance). It works fine after the first instance is up and running. However, if I tap the application name in the 'File Explorer' multiple times (4 or 5), I end up with the application launching 2 or 3 or 4 times. I have not yet found a way to prevent this. The reason this causes a problem is that the spinning processing icon doesn't appear immediately after the first tap. It is not obvious that the tap was accepted and it is not uncommon for the user to tap a second time and this can cause the problem. static class Program { [DllIm ...Show All

• Visual Basic Erase and replace

  Here is what I have at the moment My .Computer.FileSystem.WriteAllText( "C:\SaverSupreme\ScreeenFile.txt" , lstTheme.SelectedItem, True ) This is ok, but what I want is when the user clicks a new SelectedItem from the listbox the old entry is erased and replaced with the new one. I thought of Append but I think that only adds to what is already on file. By ommitting or setting the append argument to false the WriteAllText will overwrite the file with the new string... My . Computer . FileSystem . WriteAllText ( "C:\SaverSupreme\ScreeenFile.txt" , lstTheme . SelectedItem ) or My . Computer . FileSystem . WriteAllText ( "C:\SaverSupreme\ScreeenFile.txt" , lstTheme ...Show All

• Software Development for Windows Vista Cannot create more than one WorkflowRuntime per AppDomain????

  I have a webform with a button. On the button click i am calling the workflow and getting the response for the first time. The next time i click i am getting the exception "Cannot create more than one WorkflowRuntime per AppDomain" public partial class _Default : System.Web.UI. Page { WorkflowRuntime wr; private string _returnValue= string .Empty; private string _returnMessage= string .Empty; public string ReturnValue { get { return _returnValue; } set { _returnValue = value ; } } public string ReturnMessage { get { return _returnMessage; } set { _returnMessage = value ; } } protected void Page ...Show All

• Windows Forms Disabling resize on row selected column in DataGridView

  Hi, In my application, I have managed to disable resizing of my data columns on my DataGridView, but the only column that I cannot disable the resize feature is on the row select column, you know, the one which shows which row is currently selected (also shows the little pencil when the line is being edited). Can someone help me identify how to disable this please I'm using VS2005 pro and C#. I'm doing this programmatically because my program uses many different databases. I currently do things like: this.myDataGridView.Columns["LineIndex"].width = 100; this.myDataGridView.Columns["LineIndex"].Resizable = DataGridViewTriState.False; Can I do the same sort of thing to fix the width of the row selection col ...Show All

• SQL Server New to SQL Server Express... I'm scared.

  Hello, I've been working on many sites with ASP Classic and SQL Server 2000 for a while now at work, and I now need to do a bit of work from home. As I am only running Windows XP, so I cannot install SQL Server 2000 here and hense why I am trying to use 2005 Express (the price is right). I've been searching for hours, and I cannot find any good tutorial or documents on how to setup SQL Server Express and use it from ASP Classic scripts. Could some one give me some direction on the following: Creating users - Using SQL Server Management Studio Express, I have created the required databases, but I have no idea how to create a user to access these databases. When I try to create a "SQL Server authentication" through Security - ...Show All