Recent content by bdc101

I agree with you Denny, but the decision was taken out of my hands. They want the reports in Reporting Services rebuilt from scratch before we do the server switch. They want all these changes done before the server switch so it is ready before we change over. If I restore the msdb database...

Thanks for the response Denny. The reason we do not want to restore this database is there are a lot of jobs for SSRS subscriptions. We set all our reports up to be automatically emailed every morning. If we restore the msdb database all those jobs will be there, and we do not want that. I...

We have an old server running SQL Server 2000 that we are replacing, and we are keeping SQL Server 2000 on the new server. The reporting department wants to rebuild Reporting Services 2000 on the new server instead of restoring the old copies when we do the switch. If I do not restore the msdb...

I have two questions: 1) Can one instance of sql server on a third server be the mirror for instances on multiple servers, i.e. database x on server x and database y on server y both have a mirror on server z? 2) A separate license is not required for the secondary instance if it is used solely...

The primary key was proj_num and phone. There was a check constraint on the proj_num column to confirm the records from other project numbers do not get entered. I have it working now by removing all the check constraints and the primary key. I know that is not ideal, but it had to work now...

I have a partitioned view that is schemabound to the underlying tables. There is a job that runs every minute that has a step which is supposed to update the view. When the job runs, that step fails with the following error message: UNION ALL view 'sl' is not updatable because a partitioning...

I am using MySQL 5.0. I have run several simpler queries to test the DSN and conn and they run fine which is why I am so confused. Here is the response.written query: SELECT i.stateCD AS State, IFNULL(SUM(i.netamt),0) AS netAmt, IFNULL(COUNT(i.inv),0) AS OrderCount, MAX(YEAR(i.dtordrec2)) AS...

Thanks for all the suggestions, and I apologize for not including the info I have gotten from responses already. I have used response.writes to glean the following information: 1. rsOrders.eof is true after I execute the query. 2. rsOrders.recordcount is -1 3. Since the recordset is at...

Here is the for loop it starts on line 552 and ends on line 560. the query section I displayed earlier is on lines 159-263. The error occurs on the first line I try to access one of the arrays created in the earlier code. j = 0 For j = 0 to ubound(orderState) compareYear = CDbl(orderYear(j))...

Microsoft VBScript runtime error '800a0009' Subscript out of range: 'UBound' /reports/outside-sales-reports/quarterly-report/generate-report.asp, line 552 This line is well below the lines I posted and is simply: For j = 0 to ubound(orderState) I ran some response.write...

Hi DNG: Thanks, I did not catch that keyword. Changing the keyword did not fix the problem though. I ran this query in Navicat against the dB which is MySQL, and it works fine. Any other ideas? --- BDC

Hello all: I am trying to run a query against a database in an asp page, and I am getting an empty recordset returned. I know there is data that should be returned by the database, and I know the query works because I can run it against the database manually with success. I cannot find what...

I have tried several different values for the line ranging from 1 up to 180000. Originally the value was 1. --bdc101

I am getting one of two error codes from a vbs file when the task scheduler in Windows Server 2003 tries to run it. The file is used to generate several different sales reports at night. The reports will still generate if someone is there to press ok within a certain amount of time on the...

Found the problem finally. I was forgetting to check the array "state" for special characters. There was a space in the data that was not supposed to be there. Thanks everyone for all the help. --bdc101