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
>>