Making report add in work

Good day

I have been trying to install some type of reporting service . I have found a add in for web developer 2005 express . I drag the nessesay onto my form from the tool box and data table , but when I test the application all I get is xml , like below. Have I left something out. sorry I forgot to add that I also get this error on the default page-

An error has occurred during report processing.

ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'GetDatabyShipsID' that has no parameters.

<?xml version="1.0" encoding="utf-8"?>

-<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

-<DataSources>

-<DataSource Name="ConnectionString">

+<ConnectionProperties>

<ConnectString/>

<DataProvider>SQL</DataProvider>

</ConnectionProperties>

<rd:DataSourceID>baa3d63e-0dc9-43cf-9477-0040139b2ea1</rd:DataSourceID>

</DataSource>

</DataSources>

<BottomMargin>2.5cm</BottomMargin>

<RightMargin>2.5cm</RightMargin>

Hi;

Ok from the error message you are getting ie. "An error has occurred during report processing.

ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'GetDatabyShipsID' that has no parameters." the error seems to indicate that the datasource you are using (ObjectDataSOurce1) is supposed to call a method called "GetDatebyShipsID" that has no parameters. Check if you have that method and add select parameters to your datasource.

Make MS SQL Server case-sensitive

I have already install my Microsoft SQL server 2000 as not case
sensitive, how to I change it to be case sensitive?Hi

Check out this previous post

http://tinyurl.com/2qzrv

John

"Dean" <deantakamine@.hotmail.com> wrote in message
news:4563939b.0401091713.3b12169@.posting.google.co m...
> I have already install my Microsoft SQL server 2000 as not case
> sensitive, how to I change it to be case sensitive?|||deantakamine@.hotmail.com (Dean) wrote in message news:<4563939b.0401091713.3b12169@.posting.google.com>...
> I have already install my Microsoft SQL server 2000 as not case
> sensitive, how to I change it to be case sensitive?

Information is in SQL Server books online.

The index is 'case-sensitive instance of SQL Server'.

However, most people are used to the default (case insensitive).

Make a copy of SQL Server database

I'm trying to make a copy of our 2005 SQL Server production database (25 meg) so we can install it in a new office being set up in another state. I have right clicked on the database I want to copy, selected Tasks, then option Copy Database... I'm trying to put the copy on the same server, and I am doing this work signed into the Management Studio as "sa" The wizard creates 5 steps, the first 4 run ok, then the 5th step runs for 10 to 20 seconds, then quits. The message says to look in the log on the server for the reason it quit. The only log I can find is the Error Logs at the bottom of the Object Explorer window. I look into the current log, then select the SQL Server log, the current one. There is only one line in here about the copy I just tried, and it only says "Starting up database XXXXXXXX" which is the database I'm trying to create through the copy process. Within Database Mail, SQL Agent, and Windows NT log lines, I can not find any reference to the copy job that just bombed.

Needless to say, I'm VERY new to all of this SQL Server admin stuff. If someone could point me in the right direction, it would really help!

Thanks!make a backup and restore it to your new server.|||Make a copy_only backup. Documentation (http://msdn2.microsoft.com/en-us/library/ms191495.aspx) is available at MSDN.

Maintenance plans

We have Veritas' Backupexec running in our Enterprise and the Veritas Install actually installs MS SQL Server MSDN on each Server in the Enterprise.

It looks like it also sets up a default Maintenance plan within each of the MSDN Instances.

I guess my question is.. Can I manage the Maintenance Plans on these MSDN Instances via the SQL Server EM GUI from my desktop?? Seems like when I look at the Maintenance plans alot of the options are greyed out or not available. What I am trying to do is modify one of the maintenance plans to have the backups deleted after one week (One of the Instances has been running a complete backup on the Backupexec Databases for a year and there are a years worth of backups on the Server) but the option to "remove files older than" is 'greyed out' ??The main reason I've seen options greyed out is insufficient privleges.|||I logged into my local MSDN Instance as 'sa' and created a new maintenance plan via EM on my desktop.

I can create the plan, but the options to "remove files older than" is still missing. This is so puzzling!!!!!??|||Have you checked with Veritas? My guess is that Backupexec may have permanently disabled those items.|||I thought Veritas might be the culprit also, So I installed MSDE locally on my machine and I get the same results. In a new maintenance plan, on the 'specify backup disk directory' screen, I put a check in the 'remove files older than' box and the dropdrop that should read 'hours, days, weeks, months' is blank and willl not populate. Is this something that is particular to MSDE???|||There's a reason it is called MSDE and not MS SQL Server 2000. MSDE is intended for disconnected applications and/or development. It is not intended as a way to avoid paying for what you need.

You need to read up on limitations in MSDE. Here's one article that may be interpreted as a keen marketing ploy. (http://www.teratrax.com/articles/msde_vs_sql_server.html)|||Thank you for the link to the article!!!!!!!!!! basically, i need to go back to veritas then.