attach db sql in a previous sql server version

Hi,
anyone can tell me if is possible to detach a db from a sql 2000 server and
attach it again into a sql 7.0?
thanks
VTNo, you can not move from 2000 to 7.0 using detach/attach. You can't
use backuo/restore either. As far as I know you have to do it all the
hard way, meaning scripts for the objects and moving the data through
DTS, bulk copy, attached server SELECT/INSERTs, etc..
Roy Harvey
Beacon Falls, CT
On Thu, 20 Jul 2006 06:06:02 -0700, VT <VT@.discussions.microsoft.com>
wrote:

>Hi,
>anyone can tell me if is possible to detach a db from a sql 2000 server and
>attach it again into a sql 7.0?
>thanks
>VT|||No, not possible to 'just' detach from SQL 2000 and reattach to SQL v7.
If you want to move the tables and data, you might look into DTS to transfer
objects and data.
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"VT" <VT@.discussions.microsoft.com> wrote in message
news:C627B49C-91C1-4B17-A0D4-45D3810F6892@.microsoft.com...
> Hi,
> anyone can tell me if is possible to detach a db from a sql 2000 server
> and
> attach it again into a sql 7.0?
> thanks
> VT

attach db sql in a previous sql server version

Hi,
anyone can tell me if is possible to detach a db from a sql 2000 server and
attach it again into a sql 7.0?
thanks
VTNo, you can not move from 2000 to 7.0 using detach/attach. You can't
use backuo/restore either. As far as I know you have to do it all the
hard way, meaning scripts for the objects and moving the data through
DTS, bulk copy, attached server SELECT/INSERTs, etc..
Roy Harvey
Beacon Falls, CT
On Thu, 20 Jul 2006 06:06:02 -0700, VT <VT@.discussions.microsoft.com>
wrote:
>Hi,
>anyone can tell me if is possible to detach a db from a sql 2000 server and
>attach it again into a sql 7.0?
>thanks
>VT|||No, not possible to 'just' detach from SQL 2000 and reattach to SQL v7.
If you want to move the tables and data, you might look into DTS to transfer
objects and data.
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"VT" <VT@.discussions.microsoft.com> wrote in message
news:C627B49C-91C1-4B17-A0D4-45D3810F6892@.microsoft.com...
> Hi,
> anyone can tell me if is possible to detach a db from a sql 2000 server
> and
> attach it again into a sql 7.0?
> thanks
> VT

Attach an sql express edition database file to Sql Developer Edition instanse

Hi i have two version of SQL server express (with Visual Studio 2005) and developer edition i am trying to access an sql database file -created by the express edition integrated with Visual studio- using a developer edition instance can i just attach it and access it. and can i use BI and reporting services on that fileHi,

files created are by SQL Server Express are full featured data files. You can do everything with them that you do with those created by the othwer editions of SQL Server 2k5.

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de

Assertion failed!

I'm connecting to a SQL Server 2000, sp3 running on Win2k
Server, SP3, english version from a workstation with
Win2k, sp 3, english version.
The client software is written in C# and I'm using ADO.NET
to connect.
Occasionally I get this fault:
Assertion failed!
Program: ...\..\..\Myprog.exe
File: ..\..\..\nt\ssock\src\ntsockc.c
Line: 1053 (sometimes other lines...)
Expression: 1 == pConnectionObject->fCallCheck
Any suggestions what could be wrong?
/MattiasHi Mattias,
If the Assertion is thrown by the C# application, you need to post in C# or
ADO.NET newsgroup for accurate information, e.g.
microsoft.public.dotnet.languages.csharp,
microsoft.public.dotnet.framework.adonet. The problem should be related to
SQL Server.
When the problem occurs, I suggest that you use Query Analyzer to connect
to the SQL Server from the computer where the problem occurs. If the
problem does not occur, it indicates that the problem is with the
application.
In addition, since it is a random problem, it could be quite complex. You
could also contact Microsoft Product Support Services via
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS, so that
we can have dedicated engineer to assist you.
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Bill Cheng
Microsoft Support Engineer
--
| Content-Class: urn:content-classes:message
| From: "Mattias Andersson" <mattias.andersson@.ip-consult.se>
| Sender: "Mattias Andersson" <mattias.andersson@.ip-consult.se>
| Subject: Assertion failed!
| Date: Mon, 30 Jun 2003 00:17:00 -0700
| Lines: 18
| Message-ID: <067701c33ed7$9931e2e0$a101280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcM+15kxvfxven3cQMytFjuuieMjcA==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa09.phx.gbl
| Xref: cpmsftngxa09.phx.gbl microsoft.public.sqlserver.server:22143
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I'm connecting to a SQL Server 2000, sp3 running on Win2k
| Server, SP3, english version from a workstation with
| Win2k, sp 3, english version.
|
| The client software is written in C# and I'm using ADO.NET
| to connect.
|
| Occasionally I get this fault:
| Assertion failed!
| Program: ...\..\..\Myprog.exe
| File: ..\..\..\nt\ssock\src\ntsockc.c
| Line: 1053 (sometimes other lines...)
|
| Expression: 1 == pConnectionObject->fCallCheck
|
| Any suggestions what could be wrong?
|
| /Mattias
|

Aspx with IIS6 with SQL 2000

Hi All,
I am trying to run aspx website on IIS version 6. It works locally with WEb Matrix but when I put the site into the IIS server, it cannot connect to the database. THe IIS is sonfigured and all users have full permissions but the error that is returned is:
Login failed for user '(null)'. Reason: Not associated with a treusted SQL Server connection.
SQL Server 2000 is installed and a connection is open to the database in question.
Would be very greatfull for ANY help on this, being tryin to get this workin for days!!
Collette.
Hi,
I have explained the cause and resolution for this error in the following articles.
http://harishmvp.blogspot.com/2005/05/you-may-receive-error-login-failed-for.html
http://harishmvp.blogspot.com/2005/05/you-may-receive-error-login-failed-for_25.html
One of the above should help you.
Write back if this doesnt help.
Thanks.|||

Hi!

Still having problems with the this! Done everything in the two documents and still no joy!

Error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Please help!!

Collette.

|||

Hi,

Can you let me know your scenario?

Thanks.

ASP.net version

I have been running SSRS in VB 2003 but recently I installed VS 2005 beta1
and now I am unable to access the report server. I noticed that I now have
asp.net version 2 instead of version 1. I think this may be the problem.
In VS 2005 I do not use the web part of the program at all so I think I may
be able to delete version 2 from IIS and install version 1 again and that
this may solve my problem. But before I do I just thought I should ask here
if someone else sees a problem. I guess the worst that could happen is that
it would continue not to work.
Anyone?Both the ReportServer and Reports virtuals roots need to be mapped to
ASP.Net 1.1.4322. You can verify this in the properties for each virtual
root on the ASP.Net tab.
What error message do you get when you access report server? Installing a
new version of the framework will reset the password on the ASPNet account,
removing all encryption keys from the account. You may simply need to run
rsactivate -r -c <config file>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> I have been running SSRS in VB 2003 but recently I installed VS 2005 beta1
> and now I am unable to access the report server. I noticed that I now
have
> asp.net version 2 instead of version 1. I think this may be the problem.
> In VS 2005 I do not use the web part of the program at all so I think I
may
> be able to delete version 2 from IIS and install version 1 again and that
> this may solve my problem. But before I do I just thought I should ask
here
> if someone else sees a problem. I guess the worst that could happen is
that
> it would continue not to work.
> Anyone?
>|||To remap the vroots back to 1.1.4322 use the aspnet_regiis.exe utility found
in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> Both the ReportServer and Reports virtuals roots need to be mapped to
> ASP.Net 1.1.4322. You can verify this in the properties for each virtual
> root on the ASP.Net tab.
>
> What error message do you get when you access report server? Installing a
> new version of the framework will reset the password on the ASPNet
account,
> removing all encryption keys from the account. You may simply need to run
> rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Woody Splawn" <nospam@.splawns.com> wrote in message
> news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have been running SSRS in VB 2003 but recently I installed VS 2005
beta1
> > and now I am unable to access the report server. I noticed that I now
> have
> > asp.net version 2 instead of version 1. I think this may be the
problem.
> >
> > In VS 2005 I do not use the web part of the program at all so I think I
> may
> > be able to delete version 2 from IIS and install version 1 again and
that
> > this may solve my problem. But before I do I just thought I should ask
> here
> > if someone else sees a problem. I guess the worst that could happen is
> that
> > it would continue not to work.
> >
> > Anyone?
> >
> >
>|||Using the aspnet_regiis utility will definitely cause you to lose the
encryption keys because it resets the ASPNet account password. You are
better off using the IIS virtual root properties page.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:utbIkAXgEHA.2544@.TK2MSFTNGP10.phx.gbl...
> To remap the vroots back to 1.1.4322 use the aspnet_regiis.exe utility
found
> in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
> news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> > Both the ReportServer and Reports virtuals roots need to be mapped to
> > ASP.Net 1.1.4322. You can verify this in the properties for each
virtual
> > root on the ASP.Net tab.
> >
> >
> > What error message do you get when you access report server? Installing
a
> > new version of the framework will reset the password on the ASPNet
> account,
> > removing all encryption keys from the account. You may simply need to
run
> > rsactivate -r -c <config file>
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Woody Splawn" <nospam@.splawns.com> wrote in message
> > news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > > I have been running SSRS in VB 2003 but recently I installed VS 2005
> beta1
> > > and now I am unable to access the report server. I noticed that I now
> > have
> > > asp.net version 2 instead of version 1. I think this may be the
> problem.
> > >
> > > In VS 2005 I do not use the web part of the program at all so I think
I
> > may
> > > be able to delete version 2 from IIS and install version 1 again and
> that
> > > this may solve my problem. But before I do I just thought I should
ask
> > here
> > > if someone else sees a problem. I guess the worst that could happen
is
> > that
> > > it would continue not to work.
> > >
> > > Anyone?
> > >
> > >
> >
> >
>|||> What error message do you get when you access report server?
I am getting the following message:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled)
>You may simply need to run rsactivate -r -c <config file>
If I do, what is the exact syntax?
If I understand correctly I move to my MS SQL Server\80\tools\binn directory
to run rsactivate. What is the name of the config file? I have a file
called cnfgsvr.ini, if that helps. What exactly do I do?
In the help on line I got the following:
"A system administrator on the computer running the Report server service
can use a backup copy of the public key to get the report server running
again. Use the rskeymgmt utility to apply the backup key set. If you do not
have backup of the key, you must run rskeymgmt utility to delete all of the
encrypted content, run rsconfig utility to respecify the encrypted
connection values used to connect to the report server database, restart the
service, and retype stored credentials for all reports that use stored
credentials. For more information this utility, search Books Online."
However, I do not understand exactly what they're saying.
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> Both the ReportServer and Reports virtuals roots need to be mapped to
> ASP.Net 1.1.4322. You can verify this in the properties for each virtual
> root on the ASP.Net tab.
>
> What error message do you get when you access report server? Installing a
> new version of the framework will reset the password on the ASPNet
account,
> removing all encryption keys from the account. You may simply need to run
> rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Woody Splawn" <nospam@.splawns.com> wrote in message
> news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have been running SSRS in VB 2003 but recently I installed VS 2005
beta1
> > and now I am unable to access the report server. I noticed that I now
> have
> > asp.net version 2 instead of version 1. I think this may be the
problem.
> >
> > In VS 2005 I do not use the web part of the program at all so I think I
> may
> > be able to delete version 2 from IIS and install version 1 again and
that
> > this may solve my problem. But before I do I just thought I should ask
> here
> > if someone else sees a problem. I guess the worst that could happen is
> that
> > it would continue not to work.
> >
> > Anyone?
> >
> >
>|||P.S.
I do keep a backup of my entire system. I'm sure I have a backup that
preceeds the install of VS 2005 beta1. If it is just a matter of copying a
certain file back into a certain directory I can easily do that, but what
file and what directory?|||Woody,
Check this thread and see if it will help.
http://tinyurl.com/6fyb7
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:OSyDmjXgEHA.3348@.TK2MSFTNGP12.phx.gbl...
> P.S.
> I do keep a backup of my entire system. I'm sure I have a backup that
> preceeds the install of VS 2005 beta1. If it is just a matter of copying
a
> certain file back into a certain directory I can easily do that, but what
> file and what directory?
>
>|||Your ASPNet account password was reset. The database is intact, and that
backup won't help you. As a side note, you may want to check out the topics
relating to backing up your report server in books online. You certainly
want to back up the encryption key.
The data that is missing was in the ASPNet user profile. Running
"rsactivate -r -c <config file>" will fix the problem. The config file you
are looking for is called rsreportserver.config. You should specify the
full path to the file.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:OSyDmjXgEHA.3348@.TK2MSFTNGP12.phx.gbl...
> P.S.
> I do keep a backup of my entire system. I'm sure I have a backup that
> preceeds the install of VS 2005 beta1. If it is just a matter of copying
a
> certain file back into a certain directory I can easily do that, but what
> file and what directory?
>
>

ASP.NET ReportViewer Problems

Hi,
I am using the web version of the ReportViewer control in a Visual
Studio 2005 Beta 2 project. We have an Oracle database, and SQL
Reporting Services. I have been using the ReportViewer in local mode
therefore.
But I have a problem with printing/output of reports. At the moment
the ReportViewer will only export to Excel, which is the only way to
get a report to print.
Is there a way to get a report to output all pages of a report at once
using the viewer. Then users could simply print the web page to print
out the report without having to export to Excel.
Is there something I am doing wrong? Is there a way to export a report
programmatically somehow? (Remembering I am using local mode. Should I
really be using the SQL Reporting Services server? If so can I using
the SQL 2005 Express tool?).
Thanks for any help,
Regards,
RichardSorry, I meant to say we have an Oracle database and *no* SQL Reporting
services.
Thanks,
Richard|||Now some time has passed, it would be worth trying the release version as it
has lots of improvements over the beta 2 version.

ASP.NET Report Viewer Version 9.0 problem.

I recently migrated my development server from Windows Server 2003 \ IIS 6 \
.NET Framework 2 and SQL 2005 to Windows Server 2008 \ IIS 7 \ .NET Framework
3.5 and SQL 2005 SP2. SQL install also includes Reporting Services. On my dev
workstation I have upgraded to from vs2005 to vs2008 and installed the
correct AjaxToolKit 3.5 dll.
I have a web project that uses SQL reporting services and Report Viewer 8.0
which used to work ok before the migration. I have replaced the Report Viewer
8.0 control within my web project to the new vs2008 Report Viewer 9.0 and
replaced all references (web.config etc) from 8.0 to 9.0. I have also
installed the Report Viewer 9.0 download on my development server &
workstation and rebooted.
When I now run my project the report viewer control does not render my
report (or even display the default icons for the report control such as
print icon etc).
I get a client side javascript error in IE7 stating â'Error: this.Controller
is null or not an objectâ'. If I try the site on FireFox the report displays
â'404 File or Directory not foundâ' within the report viewer.
Im running the report within a user control. Please find code for the uc
containing the report viewer and associated data objects below...
<%@. Control Language="C#" AutoEventWireup="true"
CodeFile="Reporting_MainSite.ascx.cs" Inherits="NPApplets_Reporting_MainSite"
%>
<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0,
Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" Height="325px" Width="100%" BackColor="#95B7F3">
<LocalReport ReportPath="Report_SiteTraffic.rdlc"
EnableExternalImages="True">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="DataSet1_Report_LastMonth" />
<rsweb:ReportDataSource DataSourceId="ObjectDataSource2"
Name="DataSet2_Report_Last12Months" />
<rsweb:ReportDataSource DataSourceId="ObjectDataSource3"
Name="DataSet3_Report_Last12MonthsUBS" />
<rsweb:ReportDataSource DataSourceId="ObjectDataSource4"
Name="DataSet4_Report_SinceLaunch" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource4" runat="server"
SelectMethod="GetData"
TypeName="DataSet4TableAdapters.Report_SinceLaunchTableAdapter"
OldValuesParameterFormatString="original_{0}">
<SelectParameters>
<asp:ControlParameter ControlID="lbWondersiteToReportOn"
Name="Wondersite_FullName"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource3" runat="server"
SelectMethod="GetData"
TypeName="DataSet3TableAdapters.Report_Last12MonthsUBSTableAdapter"
OldValuesParameterFormatString="original_{0}">
<SelectParameters>
<asp:ControlParameter ControlID="lbWondersiteToReportOn"
Name="Wondersite_FullName"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server"
SelectMethod="GetData"
TypeName="DataSet2TableAdapters.Report_Last12MonthsTableAdapter"
OldValuesParameterFormatString="original_{0}" >
<SelectParameters>
<asp:ControlParameter ControlID="lbWondersiteToReportOn"
Name="Wondersite_FullName"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"
TypeName="DataSet1TableAdapters.Report_LastMonthTableAdapter"
OldValuesParameterFormatString="original_{0}" >
<SelectParameters>
<asp:ControlParameter ControlID="lbWondersiteToReportOn"
Name="Wondersite_FullName"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:Label ID="lbWondersiteToReportOn" runat="server"
Visible="False"></asp:Label>
Within VS2008 designer the Report Viewer control shows the controls icons
correctly (print icon etc).
I have 4 data objects that my report uses. If I try and modify the data
source objects via the Smart Tag > Configure Data Source I get the following
error...
"The type 'DataSet4TableAdapters.Report_SinceLaunchTableAdapter' could not
be loaded. If the type is located in the App_Code folder, please check that
it compiles. If the type is located in a compiled assembly, pleaee check that
the assembly is referenced by the project.
The type "DataSet4TableAdapetrs.Report_SinceLaunchTableAdapter' could not be
foundâ'"
I have checked my DataSet.xsd files located in my App_Code directory and
everything compiles ok.
Im now stumped as what to try next. Any help, advice or pointers would be
very much appreciated.
Thanks in advance,
Paul.Managed to track down a fix...
Open Internet Information Services (IIS) Manager and select your Web
application.
Under IIS area, double-click on Handler Mappings icon.
At the Action pane on your right, click on Add Managed Handler.
At the Add Managed Handler dialog, enter the following:
Request path: Reserved.ReportViewerWebControl.axd
Type: Microsoft.Reporting.WebForms.HttpHandler
Name: Reserved-ReportViewerWebControl-axd
Click OK.
http://otkfounder.blogspot.com/2007/11/solving-reportviewer-rendering-issue-on.html
Paul.
"Paul Hale" wrote:
> I recently migrated my development server from Windows Server 2003 \ IIS 6 \
> .NET Framework 2 and SQL 2005 to Windows Server 2008 \ IIS 7 \ .NET Framework
> 3.5 and SQL 2005 SP2. SQL install also includes Reporting Services. On my dev
> workstation I have upgraded to from vs2005 to vs2008 and installed the
> correct AjaxToolKit 3.5 dll.
> I have a web project that uses SQL reporting services and Report Viewer 8.0
> which used to work ok before the migration. I have replaced the Report Viewer
> 8.0 control within my web project to the new vs2008 Report Viewer 9.0 and
> replaced all references (web.config etc) from 8.0 to 9.0. I have also
> installed the Report Viewer 9.0 download on my development server &
> workstation and rebooted.
> When I now run my project the report viewer control does not render my
> report (or even display the default icons for the report control such as
> print icon etc).
> I get a client side javascript error in IE7 stating â'Error: this.Controller
> is null or not an objectâ'. If I try the site on FireFox the report displays
> â'404 File or Directory not foundâ' within the report viewer.
> Im running the report within a user control. Please find code for the uc
> containing the report viewer and associated data objects below...
> <%@. Control Language="C#" AutoEventWireup="true"
> CodeFile="Reporting_MainSite.ascx.cs" Inherits="NPApplets_Reporting_MainSite"
> %>
> <%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0,
> Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"
> Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
> <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
> Font-Size="8pt" Height="325px" Width="100%" BackColor="#95B7F3">
> <LocalReport ReportPath="Report_SiteTraffic.rdlc"
> EnableExternalImages="True">
> <DataSources>
> <rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
> Name="DataSet1_Report_LastMonth" />
> <rsweb:ReportDataSource DataSourceId="ObjectDataSource2"
> Name="DataSet2_Report_Last12Months" />
> <rsweb:ReportDataSource DataSourceId="ObjectDataSource3"
> Name="DataSet3_Report_Last12MonthsUBS" />
> <rsweb:ReportDataSource DataSourceId="ObjectDataSource4"
> Name="DataSet4_Report_SinceLaunch" />
> </DataSources>
> </LocalReport>
> </rsweb:ReportViewer>
> <asp:ObjectDataSource ID="ObjectDataSource4" runat="server"
> SelectMethod="GetData"
> TypeName="DataSet4TableAdapters.Report_SinceLaunchTableAdapter"
> OldValuesParameterFormatString="original_{0}">
> <SelectParameters>
> <asp:ControlParameter ControlID="lbWondersiteToReportOn"
> Name="Wondersite_FullName"
> PropertyName="Text" Type="String" />
> </SelectParameters>
> </asp:ObjectDataSource>
> <asp:ObjectDataSource ID="ObjectDataSource3" runat="server"
> SelectMethod="GetData"
> TypeName="DataSet3TableAdapters.Report_Last12MonthsUBSTableAdapter"
> OldValuesParameterFormatString="original_{0}">
> <SelectParameters>
> <asp:ControlParameter ControlID="lbWondersiteToReportOn"
> Name="Wondersite_FullName"
> PropertyName="Text" Type="String" />
> </SelectParameters>
> </asp:ObjectDataSource>
> <asp:ObjectDataSource ID="ObjectDataSource2" runat="server"
> SelectMethod="GetData"
> TypeName="DataSet2TableAdapters.Report_Last12MonthsTableAdapter"
> OldValuesParameterFormatString="original_{0}" >
> <SelectParameters>
> <asp:ControlParameter ControlID="lbWondersiteToReportOn"
> Name="Wondersite_FullName"
> PropertyName="Text" Type="String" />
> </SelectParameters>
> </asp:ObjectDataSource>
> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
> SelectMethod="GetData"
> TypeName="DataSet1TableAdapters.Report_LastMonthTableAdapter"
> OldValuesParameterFormatString="original_{0}" >
> <SelectParameters>
> <asp:ControlParameter ControlID="lbWondersiteToReportOn"
> Name="Wondersite_FullName"
> PropertyName="Text" Type="String" />
> </SelectParameters>
> </asp:ObjectDataSource>
> <asp:Label ID="lbWondersiteToReportOn" runat="server"
> Visible="False"></asp:Label>
> Within VS2008 designer the Report Viewer control shows the controls icons
> correctly (print icon etc).
> I have 4 data objects that my report uses. If I try and modify the data
> source objects via the Smart Tag > Configure Data Source I get the following
> error...
> "The type 'DataSet4TableAdapters.Report_SinceLaunchTableAdapter' could not
> be loaded. If the type is located in the App_Code folder, please check that
> it compiles. If the type is located in a compiled assembly, pleaee check that
> the assembly is referenced by the project.
> The type "DataSet4TableAdapetrs.Report_SinceLaunchTableAdapter' could not be
> foundâ'"
> I have checked my DataSet.xsd files located in my App_Code directory and
> everything compiles ok.
> Im now stumped as what to try next. Any help, advice or pointers would be
> very much appreciated.
> Thanks in advance,
> Paul.
>

ASP.NET 1.1 and SQL Server 2005. Possible?

Hey,
I am starting to work on a project using ASP.NET. I am intending to useversion 1.1 cause version 2.0 is still Beta and not finalized yet. Iwas wondering if it is possible to use MS SQL Server 2005 with ASP.NET1.1. As far as I know the SQL Server 2005 requires ASP.NET 2.0. But Istill want to check if it is possible some how and if it was possible,will I find a server on the Internet that hosts SQL Server 2005 withASP.NET 1.1 cause till now all the companies I found provide onlyASP.NET 2.0 with SQL Server 2005.
[I don't actually know for sure but...]
Depends what you mean by "use" I guess. I'm sure it will respond to basic SQL Server requests at least as an OLEDB database, possibly as a SQL Server provider. However if you want to make use of any of the nice stuff then I doubt it very much.