Shaun Logan's Q&A profile
Visual Basic Lock on DB
Hi, I have developed a VB.NET windows based application and am using SQL 2000. After using this application for a while then it becaomes slow.I found out that it is because I use select statements and readers and these cause a LOCK on the DB so that the correct data is always displayed..... How do I use select statements and readers so that they do not cause a LOCK Thank You, There are a variety of lock options for SQL server. These are included in the SQL statement. The one you are talking about is NOLOCK The following article details some of the others. http://www.sql-server-performance.com/rd_table_hints.asp I would however say that unless you really see the default locking as causing problems then dont change ...Show All
SQL Server Uninstall on new machine causes resource file error
OK heres the deal, I just purchased a new dell and uninstalled the sql server. Now i am getting- Execution cannot continue as the language dependent resource fil could not be loaded. Any ideas where i could download it or where to get some answers My laptop is only 3months old what the fudge!!!!!!!!!!! ...Show All
.NET Development How will the client come to know about the WSE settings used by service at server ??
Hi, We have created a web service and secured it using some policies of WSE 3.0. Now on the client side, we need to apply the same policy to the proxy of service, that is generated. So the question is , how does the client come to know about policy used by the service WSDL / or the proxy class generated does not have any information regarding policy used by service. Any pointers to, how the client would come to know about this . Thanks and Regards, anita. Hi Anita, WCF publishes all the service metadata (Security, Transport, Service WSDL, etc) in a specific URL using the protocol WS-MetadataExchange. WCF also provides ...Show All
Software Development for Windows Vista How to listen for event for child activties
hi, I have a replictor in my workflow which runs all child activities in paralell. My assumption is that all activities will be running at the same time. Now if those activties a waiting for external event which one giong to get it or how i can scope event for each activity. Or should i create sub workflow in such case. thanks, Sajjad Take a look at the CorrelatedLocalService sample, found under Technologies\Communications, in the WF Samples that can be downloaded from here . The sample uses a Parallel activity but how to do get correlation working is the same. ...Show All
SQL Server Error: The backup of the file or filegroup "sysft_XXXX_FT" is not permitted because it is not online
Hi There, I am trying to do a full back up of a user database which has full text indexing on it. I use the maintenance plan wizard to set up a full backup. For some reason, I get this error. ================= Executing the query "BACKUP DATABASE [XXXX] TO [XXXX] WITH NOFORMAT, NOINIT, NAME = N'XXXX_backup_20060819040020', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "The backup of the file or filegroup "sysft_XXXX_FT" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, " ...Show All
Visual C++ How can I make the environment ideal for C
I am using MSVS2005 Professional. What settings should I change for writing C and not C++ What about file extensions They should be .c As pointed out before, C++ is highly compatible with 'C'. In embedded systems, I've worked with them, 'C' tends to be favored because being an embedded system software vendor doesn't nearly qualify you to be a C++ compiler vendor. The standards are quite low, but embedded C++ started to become widely available several years ago... ...Show All
Visual Basic Program to execute on one machine only
Hello, My problem is that I want to deploy my program onto a 'thumb drive' and sell it that way and I need the program to only run off that drive. It is a small program that can easily be copied and run by anyone so I thought that if I could somehow 'lock' it to the small USB drive then that would solve my problem. Because some games require a CD to be in a drive before they will run I figured that that would be something that I could do, my problem is finding any help in how that might be accomplished. Can anyone point me in the right direction Thank you very much Bill Langston Thanks nobugz. I typed up a long reply and when I went to post it an error occured. Grrrr I'll download the shareware and see what goes. ...Show All
Smart Device Development Is there possible to transform audio datas while I'm phoning ?
Hello everyone, I wanted to know if they are some Api in Windows Mobile SDK that allow an access to audio data which are passing through the mobile while I'm phoning Please forgive my bad English, and many Thanks in advance..! Maybe my question was too large. I've found on Internet a software for PPC with Windows Mobile 5.0 that allows you to record your mobile phone conversation. Both voices are recorded on the file, so, the software is able to read audio buffers used by the mobile during the conversation. Any ideas on the Api used to do a soft like this Thank you very much ! ...Show All
Visual Studio report is being generated never goes away.
I am using a reportviewer for a windows forms project that query's an access database. 75% of the time the report stays with the message that the report is being generated, but never does. 25% of the time it works. I have had it not work - make no changes, hit the start debugging button and have it work. I can see no pattern here whatsoever. What is going on I have made separate programs and still have the same problem. No it is not resolved and I have replicated it several times. I am suspicious it is a bug related to access and report viewer. Are you using a sql server database or an access database ...Show All
.NET Development Whats best Updateagram or Stored Procedure on passed XML dataset?
Hi, i have writen a webservice to accept a passed xml dataset from our clients server. The webservice will be called every X minutes and data passed. The clients server uses the Jade database and is remote to our servers. The dataset passed contains multiple tables I need to incoropate this to our SQL server, inserting, updating and deleted records as needed. as far as i can see there is a couple of ways to do it: method1: take the uploaded dataset insert into temporary tables run a stored procedure on temporary tables that will insert,update or delete into live tables as needed delete data from temporary tables wait for next dataset to be passed method2: take the uploaded dataset step thru dataset and live tables buil ...Show All
SQL Server Sending parameter to SQL script file
To update customers’ databases I use the command “sqlcmd -S .\SQLEXPRESS -i DBUpdate.SQL” through an InstallShield Wizard. One of the SQL statements within the DBUpdate.SQL file is a BULK INSERT statement that loads data from a text file. The path for the text file is known only at the time of execution. Is it possible to send the path as a parameter to the script file (DBUpdate.SQL) If so, how I would appreciate any help. Please see the link below for more details on how to parameterize your SQL script. http://msdn2.microsoft.com/en-us/library/ms188714.aspx ...Show All
SQL Server Similar problem
Hi folks, I’m relatively new to both SQL Reporting Services as well as .Net programming. I come from a Crystal Reports background and I’m running into a problem duplicating a common technique used in my old Crystal reports. The simplified description of the problem I’m having is this… it seems that public shared variables are evaluated in the wrong order when accessing them from code in grouped tables. It seems that the group header is evaluated first, then the group footer and finally all the detail rows. As a result, if I modify a shared variable in the details section of a grouped table, that modification isn’t recognized in the group footer. Here are the details of what I’m trying to accomplish… I have added a table to my report which ...Show All
.NET Development Table Adapter - stop Auto generated files
I am using a Table Adapter in my Data access layer, built as separate Project. I need the adapter to use the Connection string in the Web.config file of the solution where the DAL assembly will be used. How do I prevent the Settings.settings and Setting.Designer.cs files from being generated when I compile the DAL. If I include the DAL project in my Main solution then will I be able to specify the Web.config connection rather than the connection from the Settings.Designer.cs file! I seem to be confused between using the Settings.Designer.cs and the Web .Config for Table adapters. Where can I find a good resource for this . -Jawahar Thks Charles for ur answer, the first method is working if th ...Show All
Visual Basic Add columns from different tables in SQL to a datagridview to show info via SQL Query including joint statement.
The problem I have is the following: I need to have a datagridview in which I can add columns from different tables in my database (SQL), not only from one table. The idea is that I want to make a query in which I use a joint statement to obtain from certain table that has an idnumber, the name of this id number which is obtain from another table. And all of this I need to be presented elegantly in the datagridview, in which I present columns from the first table and columns from the second table, thanks that I have made the joint in the query. I have read a lot and still I haven’t found what I’m looking for. I’m using Visual Studio 2005 (need and answer in visual basic form not in C#). Thanks people in advance ...Show All
Visual Basic Adding an inherited form failed by Assembly Load Error
I would like to add an inherited form to my VB.NET project under a solution that contains assemblies written in various .NET languages. Whenever I confirmed to add an inherited form, an "Assembly Load Error" error dialog box popped up. The dialog box said that "Unable to load assembly 'VCS.NET.dll'. Ensure that the file is a valid .Net framework assembly.". My VB.NET project did not refer to the 'VCS.NET.dll' assembly directly or indirectly. It still prompted me such an error dialog. I am a little bit confused. Could somebody advise on this matter Jeremy "VCS.NET.dll" is my own .NET module written with C# and I am using VS2005 standard edition + VS2005 professional edition t ...Show All