ODBC datasource / dataset problem

Hi,
I'm using the Visual Studio designer to create my RS reports. When I
add a new project to the solution, the new project wizard allows me to
choose ODBC as the datasource type I want to use. However, I amn't
given the ODBC option when I try to add a datasource to an existing
project. I work around this by copying and manually editing the ODBC
.rds file that was created by the new project wizard. Does anyone know
"the right way" to add an ODBC datasource to a project without using
the project wizard? I'm a bit concerned about my workaround because I
now have multiple .rds files in the same project with the same
<DataSourceID>.
Also, I don't know if this problem is caused by my workaround, but when
I use the "hacked" .rds file as a report's datasource and open the
"Data" tab I see the message:
"The query could not be loaded. Verify your connection string and query
string"
The report still runs fine, and if I open the "Generic Query Designer"
(in the "Data" tab), the query appears, and returns results if I click
the "!" button.
Thanks in advance,
DonRight click on shared data sources, add new data source. When the data link
properties box comes up it is on the connection tab, click on the Provider
tab where you can now pick ODBC.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Don" <donalmurtagh@.yahoo.co.uk> wrote in message
news:1127296726.880744.15570@.g44g2000cwa.googlegroups.com...
> Hi,
> I'm using the Visual Studio designer to create my RS reports. When I
> add a new project to the solution, the new project wizard allows me to
> choose ODBC as the datasource type I want to use. However, I amn't
> given the ODBC option when I try to add a datasource to an existing
> project. I work around this by copying and manually editing the ODBC
> .rds file that was created by the new project wizard. Does anyone know
> "the right way" to add an ODBC datasource to a project without using
> the project wizard? I'm a bit concerned about my workaround because I
> now have multiple .rds files in the same project with the same
> <DataSourceID>.
>
> Also, I don't know if this problem is caused by my workaround, but when
> I use the "hacked" .rds file as a report's datasource and open the
> "Data" tab I see the message:
> "The query could not be loaded. Verify your connection string and query
> string"
> The report still runs fine, and if I open the "Generic Query Designer"
> (in the "Data" tab), the query appears, and returns results if I click
> the "!" button.
>
> Thanks in advance,
> Don
>

ODBC Connection with SQL Express

If I create any other user (test, felix, fido, etc) in my database, that user can login successfully through Management Studio Express except not through an ODBC connection. Thus, this is a very bizarre issue. I have made sure this user has the same roles as SA. My instance is configured to handle SQL Server Authentication and Integrated. This works fine in Studio Express, but not in the ODBC connection.

When using "SA" login, I can connect to Management Studio Express and through an ODBC connection. Seems rudimentary enough, however, if I change the name in the ODBC connection i get

"Connection Failed,

SQLState '28000', SQL

Server Error 18456,

Microsoft SQL Native Client SQL Server Login failed for user 'xyz'"

Any ideas? Do I need a different ODBC Administrator?

Hi,

I would suggest to refer http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx for connection troubleshooting.

Hemantgiri S. Goswami

|||

Most likely this is caused by the fact that you are connecting (or trying to connect) to a database within your connection string where you don′t have access to. The state in the error code should give you a bit more information about the problem during the connection time. try setting a database in the connection string which is in common accessible to everyone (master). Although this might work, you should consider putting the right database in the connection string afterwards, as changing database it not a cheap operation.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Odbc and deployment

I've created several reports, using ODBC to an external data source, and they
preview just fine in Visual Studio 2003. However, when I deploy the reports,
open Report Manager, and select a report to run I get:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
I'm wondering why the datasource doesn't work on deployment (the Odbc driver
is a "User" dsn). Everything is on my "localhost" machine.
Any help is appreciated. Thanks,
BillReport Services user is not you. Make your ODBC dsn a machine dsn and your
problem will go away.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bill H" <BillH@.discussions.microsoft.com> wrote in message
news:1342D1A4-6D41-4BAD-A165-451130EB714A@.microsoft.com...
> I've created several reports, using ODBC to an external data source, and
> they
> preview just fine in Visual Studio 2003. However, when I deploy the
> reports,
> open Report Manager, and select a report to run I get:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
> and no default driver specified
> I'm wondering why the datasource doesn't work on deployment (the Odbc
> driver
> is a "User" dsn). Everything is on my "localhost" machine.
> Any help is appreciated. Thanks,
> Bill|||I have the same problem. My dsn is a system dsn but it still won't work when
I deploy... same error message as described below. Any other ideas? Is it
anything to do with the windows accounts used by the relevant IIS folders?
Rob
"Bruce L-C [MVP]" wrote:
> Report Services user is not you. Make your ODBC dsn a machine dsn and your
> problem will go away.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bill H" <BillH@.discussions.microsoft.com> wrote in message
> news:1342D1A4-6D41-4BAD-A165-451130EB714A@.microsoft.com...
> > I've created several reports, using ODBC to an external data source, and
> > they
> > preview just fine in Visual Studio 2003. However, when I deploy the
> > reports,
> > open Report Manager, and select a report to run I get:
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'DataSource1'.
> > (rsErrorOpeningConnection) Get Online Help
> > ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
> > and no default driver specified
> >
> > I'm wondering why the datasource doesn't work on deployment (the Odbc
> > driver
> > is a "User" dsn). Everything is on my "localhost" machine.
> >
> > Any help is appreciated. Thanks,
> >
> > Bill
>
>|||Check out the credentials tab of your data source.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob Sykes" <RobSykes@.discussions.microsoft.com> wrote in message
news:255CDDC7-811D-4DDF-B963-4391BE127640@.microsoft.com...
>I have the same problem. My dsn is a system dsn but it still won't work
>when
> I deploy... same error message as described below. Any other ideas? Is
> it
> anything to do with the windows accounts used by the relevant IIS folders?
> Rob
> "Bruce L-C [MVP]" wrote:
>> Report Services user is not you. Make your ODBC dsn a machine dsn and
>> your
>> problem will go away.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Bill H" <BillH@.discussions.microsoft.com> wrote in message
>> news:1342D1A4-6D41-4BAD-A165-451130EB714A@.microsoft.com...
>> > I've created several reports, using ODBC to an external data source,
>> > and
>> > they
>> > preview just fine in Visual Studio 2003. However, when I deploy the
>> > reports,
>> > open Report Manager, and select a report to run I get:
>> >
>> > An error has occurred during report processing. (rsProcessingAborted)
>> > Get
>> > Online Help
>> > Cannot create a connection to data source 'DataSource1'.
>> > (rsErrorOpeningConnection) Get Online Help
>> > ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not
>> > found
>> > and no default driver specified
>> >
>> > I'm wondering why the datasource doesn't work on deployment (the Odbc
>> > driver
>> > is a "User" dsn). Everything is on my "localhost" machine.
>> >
>> > Any help is appreciated. Thanks,
>> >
>> > Bill
>>

Obtaining SQL RSS Developer Addition

I want to install SQL Reporting Services on my laptop which has Windows XP
Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
Where can I download or obtain the install file for SQL Reporting Services
Developer Edition?
- MaxI tried the same question a while ago with no reply out here.
No I bought msdn pro subscription to get visual studio and here I can
download rep s dev. edition as well.
You should think that you could get it for free if you have sql 2000 dev
edition, though...
"Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
> I want to install SQL Reporting Services on my laptop which has Windows XP
> Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> Where can I download or obtain the install file for SQL Reporting Services
> Developer Edition?
> - Max|||What are you trying to achieve Max?, the Reporting Services server-part does
not run on MSDE you can't install the reports-database on MSDE and it also
needs IIS to host the reports website.
Ed
"Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
>I want to install SQL Reporting Services on my laptop which has Windows XP
> Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> Where can I download or obtain the install file for SQL Reporting Services
> Developer Edition?
> - Max|||But you have different versions of rep s as welle as different versions of
sql server:
developers ediition
standard edition
entreprise edition
dev ed is much cheaper and can be used for dev purposes.
"Ed Richard" <Ed_XXX_@.wss-ed_REMOVE_.nl> wrote in message
news:%23mIKQ8tgFHA.3788@.tk2msftngp13.phx.gbl...
> What are you trying to achieve Max?, the Reporting Services server-part
does
> not run on MSDE you can't install the reports-database on MSDE and it also
> needs IIS to host the reports website.
> Ed
> "Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
> news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
> >I want to install SQL Reporting Services on my laptop which has Windows
XP
> > Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> >
> > Where can I download or obtain the install file for SQL Reporting
Services
> > Developer Edition?
> >
> > - Max
>|||I got lucky and found someone who had the setup file for SQL RSS Dev.
Edition. I am using it on SQL Dev Edition, not SQL MSDE (Desktop Edition).
And running iis on WinXP as well. All are working fine on my XP machine now.
"Michael Vardinghus" wrote:
> But you have different versions of rep s as welle as different versions of
> sql server:
> developers ediition
> standard edition
> entreprise edition
> dev ed is much cheaper and can be used for dev purposes.
> "Ed Richard" <Ed_XXX_@.wss-ed_REMOVE_.nl> wrote in message
> news:%23mIKQ8tgFHA.3788@.tk2msftngp13.phx.gbl...
> > What are you trying to achieve Max?, the Reporting Services server-part
> does
> > not run on MSDE you can't install the reports-database on MSDE and it also
> > needs IIS to host the reports website.
> >
> > Ed
> >
> > "Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
> > news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
> > >I want to install SQL Reporting Services on my laptop which has Windows
> XP
> > > Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> > >
> > > Where can I download or obtain the install file for SQL Reporting
> Services
> > > Developer Edition?
> > >
> > > - Max
> >
> >
>
>|||You can order a CD here:
http://www.microsoft.com/sql/reporting/howtobuy/retailfulfillment.mspx
Ed
"Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
>I want to install SQL Reporting Services on my laptop which has Windows XP
> Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> Where can I download or obtain the install file for SQL Reporting Services
> Developer Edition?
> - Max|||Hi,
This discussion is probably closed, but maybe you can still help me.
Could anyone ever find a link to download the Reporting Services Developer
Edition?
I have Reporting Services Evaluation Edition on my XP machine, but I wonder
what will happen when the 120 day trial duration expires and therefore wanna
install the developer edition.
Thanks,
Gul
"Ed Richard" wrote:
> You can order a CD here:
> http://www.microsoft.com/sql/reporting/howtobuy/retailfulfillment.mspx
> Ed
> "Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
> news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
> >I want to install SQL Reporting Services on my laptop which has Windows XP
> > Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> >
> > Where can I download or obtain the install file for SQL Reporting Services
> > Developer Edition?
> >
> > - Max
>
>

Obtaining RS developer edition?

We just purchased the Visual Studio .NET Special Edition, which includes the
Developer Edition of SQL Server. However, there was no CD of Reporting
Services contained in the box, and I can't find it anywhere for download.
Where can I get it?
Thanks.
Jon Pearce
jonp at the domain below
dgapartners.dropthispart.comJon Pearce wrote:
> We just purchased the Visual Studio .NET Special Edition, which includes the
> Developer Edition of SQL Server. However, there was no CD of Reporting
> Services contained in the box, and I can't find it anywhere for download.
> Where can I get it?
http://www.microsoft.com/sql/reporting/howtobuy/default.asp
U.S. and Canadian retail customers can order the CD directly via the
website. ($5 U.S.)
-BA|||UK customers can get it from a MS reseller (e.g.
http://www.greymatter.co.uk)
Note that it is more expensive to order the media kit outside of North
Amaerica - though still not a bad price (Sterling £ 27). I see no reason
for the huge discrepancy though, especially as it's just a CD, not even
boxed!
"Jon Pearce" <jpearce@.noemail.com> wrote in message
news:eTv%23guJsEHA.3048@.tk2msftngp13.phx.gbl...
> We just purchased the Visual Studio .NET Special Edition, which includes
> the
> Developer Edition of SQL Server. However, there was no CD of Reporting
> Services contained in the box, and I can't find it anywhere for download.
> Where can I get it?
> Thanks.
> Jon Pearce
> jonp at the domain below
> dgapartners.dropthispart.com
>