Tamila's Q&A profile

• Visual Studio Express Editions Database search help

  Ive copied a database search out of a progrsamming book I have and as far as I can tell I've adjusted it correctly to use my db. Whenever I run the search , it tells me theres no matching records to disply, even though there deffinetly is. I have a suspcion (may be wrong) that its a problem with the number of row counting code, but does anyone ahve any ideas. Thanks If ForecastsDataSet1.Tables.Count = 0 Then MessageBox.Show("No records found for supplied case reference", "Search") : Exit Sub End If Dim s As String Dim re As String Dim i As Integer Dim x As Integer s = LCase(txtsearch.Text) If s = "" Then MessageBox.Show("Please enter search value") : Exit S ...Show All

• Visual Studio Express Editions How do I format my data coming from an access DB

  I have a bunch of questions. I am a newbie to VB 2005 express edition. I have a DB in access. I have created my queries to get the data I want from the DB. I am inserting labels to pull data from the query. How do I format the positioning of the data (labels) so that my data starts where I want it to start from, Eg: How can I have, lets say (label2) start from position 13 on the page. I can select the pixel it will start from but I need to select by position. Also if I have 2 rows, my data is displayed one at a time. How do I get it to show all at once. Thanx I think you need to fill people in more. "lets say (label2) start from position 13 on the page." What is positio ...Show All

• SQL Server "Cross Mirroring" - any good?

  Hi I’m about to move all our databases from an old lousy server to a brand new HP setup. I have 8 databases (total of approx 100Gb) and I get 2 BL25p servers and SAN access for them. Now, I want high availability and I like the idea of mirroring the databases for achieving that. On the other hand I don’t like the idea of the mirror server doing almost nothing while the principal gets the entire load – seems like a waste of good resources. But is this really the situation or mirror server also be loaded, just for being the mirror Now, if the main load is on the principal would I then benefit from distributing the databases on both servers, so both servers would act like principal and mirror What I mean is that server 1 could be prin ...Show All

• Visual Studio How to carry user input from the custom wizard to the new project

  Greetings, I've created a custom template wizard that will create for the user a new C++ project in VS2005. I am using this wizard in tandem with a customized experimental hive. In the wizard, I have customized a page to include common form elements (i.e. textfields, buttons, drop-down lists). Once the user has clicked the button to complete the project template setup, I would like to take the information he/she submits and propagate it to the development environment in some way so that I can retrieve it. Specifically, I have customized the experimental hive with a property extender. the property extender is only activated for a certain type of project, namely the project type that I am now creating a wizard for. I would like the inf ...Show All

• Visual C++ Debug has different memory?

  Hi, I am trying to create many instances from one application, but every instances should have different event. So every time I execute my application, one instance will create a new event. I use the following lines: string temp = "A"; while(OpenEvent(EVENT_ALL_ACCESS, FALSE, (LPCWSTR)temp.c_str()) != NULL) { char now = temp.at(temp.size()-1); now ++; temp.at(temp.size()-1) = (char)now; } myEvent = CreateEvent(NULL,TRUE,FALSE,(LPCWSTR)temp.c_str()); It maybe not so effective, but it works well (I execute the output exe multiple times and I get different event for every instance) until when I want to debug the code and I run my visual studio in the DEBUG mode, and then I run the executable and I get the same event as the one ...Show All

• Smart Device Development CreateFile on PDA filesystem?

  How can I find the string to call to get a device handle on a PDA either from a PC or from inside the PDA itself In general use in .Net on a PC you can call CreateFile to get a device handle on a HardDisk by feeding it something like " \\.\PHYSICALDRIVE2 ". However, this does not seem to be the case on a PDA. I am trying to either A. gain access to the PDA as a USB device when the PDA is in the cradle, or B. get access to the device with a .Net compact application. Either way will do, but I am stumped as to how to find or lookup the string to access a create a handle. Thanks in advance Jeff Ok, well maybe im not painting the picture currectly. On a desktop you can use CreateFile on a physical dr ...Show All

• SharePoint Products and Technologies sharepoint 2007 showing System Account instead of Username / full name

  When i login with my username & password into sharepoint (2007) site, it displays as a "System Account" instead of my username or my full name on the top right corner of the website. What ever changes i make inside the site, for example upload a file, post a comment, sharepoint marks it as a System account instead of my name. Can someone help me figure it out why Thanks. I have the same problem and your suggestion did not fix it. Shouldn't changing the account used in the application pool fix it What are the steps to change it ...Show All

• SQL Server Date out of range?!

  Greetings! I have a data source that gets generated based on a variable with the following SQL : "select * from result where deletion_ind = 1 and when_deleted >= '" + (dt_str, 50, 1252) @[User::Last_Run_Date] + "'" But when I run my package I get an error message saying: The conversion of CHAR to DATETIME resulted in a DATETIME value out of range The Last_Run_Date variable is set to '2006-06-25 14:35:05.450' When I run the code in a QA session it works, but in the package it complains! What am I doing wrong Thanks for your help in advance. Hi Jamie, I am not quite sure how to use profiler for this problem. I have a data source coming from SQL Server 6.5. The data source i ...Show All

• .NET Development Database insert problem

  Hi! I'm attempting to insert records from a tab-delimited text file into a database. I can successfully parse the text file and get the data into a datatable. I verified this by binding the datatable to a gridview - I can see all the rows. My problem is when I try to insert those records into a SQL 2005 table. The error I get is: System.ArgumentException: Input array is longer than the number of columns in this table. My database has 36 columns. When I generate the datatable, I leave out the primary key column because such a column doesn't exist in the text file. Obviously, I'll need a primary key in the database. My goal is to insert the data via stored procedure. Does my stored procedure have to have a parameter for the primar ...Show All

• Software Development for Windows Vista How to get Data Object (Properties) define in workflow from my Host?

  Hello, I have a problem for get information in my workflow instance. For example I had created in my workflow define a public property (Client) the question is: How can I do to get this value in run time with sql tracking I had added sqltrackingservice, sqlpersistenceservice and a create a profile with tracking profile designer. Please post your tracking profile. Samples for how to do this can be found here or here . ...Show All

• Visual Studio Team System Internal Error! Failed to acquire a ReaderLock

  I get this error message at the end of a webtest. Any ideas as to why It is hard to make a guess as why you are seeing that issue. Looking at the code in your webtest and/or trying to debug (or of course, finding a constant repro) would definitely help us trying to understand what is happening here. Thanks, David Gorena Elizondo [MSFT] VSTS ...Show All

• SQL Server I need identity on updatable partitioned view

  Ok, already read that is not allowed to have identity column in any member table of a updateable partitioned view. But I need an identity column. Is there any other way or ide how to solve this problem create table bileta_te_lozura_2007_01 ( id int not null, databiletes datetime not null check ( databiletes >= cast ( '20070101' as datetime ) and databiletes < cast ( '20070201' as datetime )), constraint [pkjan2007] primary key clustered ( [id] , [databiletes] ) with fillfactor = 50 on [primary] ) create table bileta_te_lozura_2007_02 ( id int not null, databiletes datetime not null check ( databiletes >= ...Show All

• SQL Server SQL 2005 database will not attach in XP

  We are testing our product installation and run into the following problem on Windows XP and Server 2003, but not 2000: I am trying to attach a database using a command line program that we made, but get the following error: Could not open new database 'Launcher5'. CREATE DATABASE is aborted. File activation failure. The physical file name "C:\MARC\MARC5\Data\Launcher5_log.LDF" may be incorrect. The log cannot be rebuilt when the primary file is read-only. PMJI, I wasn't the original poster but am having the same issue. I have an application that I need to distribute with Sql2k5 Express; our MSDE-based solution works just fine but of course MSDE won't install on Vista.... My installat ...Show All

• SQL Server sql problem

  hi, i have this sql statement. set @stmt = 'select distinct * from (' + @stmt + ') as ax, (' + @st + ') as bx where ax.invoiceid = bx.invoiceid and ax.pono=bx.pono' now suppose it returns select a.s , a.t , a.u , b.s, b.t , b.total from a,b where a.s=b.s how can i reduce this to select a.s , a.t , a.u , b.total from a,b where a.s=b.s . i cannot use named fields but i need a way to prevent duplicated fields. Hi, If I get it right, you want to create a join between two tables without knowing the tables in advance To do this you will need to use the sp_sqlexec stored procedure. This stored procedure allows you to execute dynamic sql statements. Here is a possibility to retrieve ...Show All

• .NET Development Kerberos WSE 2 Error

  Ive been doing a .net 2 web service which is secured with WSE 2 SP3 using kerberos tokens, when i call the service i get the following error message. System.Web.Services.Protocols.SoapHeaderException: System.Web.Services.Protocols.SoapHeaderException: Server unavailable, please try later ---> System.Security.SecurityException: The handle for the current process could not be retrieved. The OpenProcessToken call returned the following error code: 0. at Microsoft.Web.Services2.Security.Tokens.Kerberos.LsaServerContext.AddTcbPrivilege() at Microsoft.Web.Services2.Security.Tokens.Kerberos.LsaServerContext.LogonUser(Byte[] inToken) at Microsoft.Web.Services2.Security.Tokens.Kerberos.LsaServerContext..ctor(Byte[] inToken) at Microsoft.W ...Show All