Search results for query: *

I have written a web application which embeds crystal reports into ASP.NET (1.1 framework). I have no issues running the reports on my development machine where all the SQL Server 2000 db is located but when I deploy to the test and live servers where the SQL Server db is located on a different...

I have written a web application which embeds crystal reports into ASP.NET (1.1 framework). I have no issues running the reports on my development machine where all the SQL Server 2000 db is located but when I deploy to the test and live servers where the SQL Server db is located on a different...

Sorry for the stupid question but I have been looking for a while to get the syntax. What is the c# syntax for getting a value from a selected datagrid? the vb is "dg.Items.Item(1).Cells(20).Text

I have a web application because of the way people can quit out of it, their connection to SQL Server remains (SPID). I have written a proc that will run during the night to kill the SPID processes, however I am worried that during the day I might hit an upper limit of SPID processes and the...

I have not used Crystal for a few years, however last time I did I created an application embedding Crystal Reports 8.5 into an ASP interface. In that application I could change the groups of the reports at runtime, I believe it was the command AddGroup. Can I do the same in ASP.NET using VB...

I have installed MySql version 5.0 locally onto my laptop. I have problems when I change locations from the office to home, "Could not connect to specified instance. MySQL Error 1045 Access denied for user 'root'@'localhost' (using password:YES)" I have a static ip address at work and but not...

I have 2 dts packages that use a query to get just under 16,000 records from an ORACLE view that uses 5 tables and has just under 100,000 results I have an ORACLE view that uses 5 tables and returns just under 100,000 results. I have 2 dts packages that use the same query that returns just...

I have 2 dts packages, one dts package imports data from a sql server db and the other imports data from an ORACLE db. Both dts packages can be executed from sql enterprise manager. The problem is that when I schedule the packages with a job, the SQL Server import dts package works fine but the...

I am new to asp.net. I have created a user control that has a text tox in it and I have put it onto a web form. (I am doing this with a reference book in one hand!) When I run it I get the user control loaded onto my form ok, The buttons do what they are suposed to do and the text box gets...

We have a problem with one of our tables that has started to occur. The table has about 4500 records and when it is queried select * from xxx it hangs. When we select count(*) from xxx it returns instantly. When we stop and restart the SQL Service the problem stops only to return the next day...

We have a problem with one of our tables that has started to occur. The table has about 4500 records and when it is queried select * from xxx it hangs. When we select count(*) from xxx it returns instantly. When we stop and restart the SQL Service the problem stops only to return the next day...

I want to write a query that returns if a specified job is currently running. I expect to find this data in the msdb.dbo.sysjobs or msdb.dbo.sysjobhistory tables but nothing jumps out as the field I want. Can someone tell me what field and table I need to return the current job status? Thanks

I am using SQL Server 2000 and I want to report on the steps in a job by using a query. There is the procedure sp_help_jobhistory in the msdb database which returns what I want but I need to put the results into a temp table to be able to use them. Is there a way of creating a temp table from...

I have this view. When I select the view in the object browser in the query analyser I can’t see the columns. When I try to open the view in the analyser it get an [Microsoft][ODBC SQL Server Driver][Timeout expired]. When I run the view as a query it works. Any idea what’s going on and how...

I would like to write a query returning job history data. does anyone know where this data is held? I have just had a quick look at the master system tables and there is nothing obvious. Maybe there is an stored procedure?

We have a .net solution that has many projects and uses DPAPI Encryption on the connection string. When I am running in debug I can see that the connection string is as expected the first 9 times it is called but then changes to the live connection string for no apparent reason. Have checked...

Has anyone had this problem? When I try to create a Release version of my solution in Visual Studio I get a message it looks like windows is trying to install some components: “Please wait while Windows configures Visual Studio .NET Enterprise Developer 2003 - English” After a couple of...

I am very new to vb.net and I want to start down the right path. In the past when I have built applications in VBA I always used unbound controls. Should I use this approach with vb.net or should I go with data binding the controls?

I am generating insert queries and then executing them. On this insert query it is taking 1 second to query 100 records but almost 30 seconds to insert 100 records. a different generated query which is basically the same inset query inserting into the same table but getting the data from a...

I have written a procedure that generates queries and executes them. The problem is that I have 2 insert queries that are generated that insert into the same table and are basically the same except I that am using a different view for each. The first insert query, which is the Computers query...