Prev: What string to pass in URL to open report viewer in a new window?
Next: Jump To URL issue
From: Jack Bender on 26 Jan 2010 08:21
I have an Access database that we use to grab data for an SRS report. We
just recently upgraded SQL 7 SRS to a new machine that is 64 bit and both SQL
and SRS are now running on a 64 bit platform.

Unfortunately the reports use a custom data source that is ODBC with a DSN
pointing to the Access Database.

When we try to run the report, we get the following error….


An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'Calendar'.
(rsErrorOpeningConnection)

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an
architecture mismatch between the Driver and Application


The issue appears to be that the ODBC drivers needed for Access are 32 bit
and can only be accessed via the C:\Windows\SysWOW64 folder and SRS appears
to only see the ODBC drivers in the C:\Windows\System32 folder.

Does anyone know how to get an SRS Report running on a 64 bit version of SRS
to connect to a Microsoft 2007 Access database using the correct ODBC
drivers?

From: Jack Bender on 26 Jan 2010 08:25
Correction, it is SQL & SRS, both are SQL Server 2005 Developer Edition on SP3

"Jack Bender" wrote:

> I have an Access database that we use to grab data for an SRS report. We
> just recently upgraded SQL & SRS to a new machine that is 64 bit and both SQL
> and SRS are now running on a 64 bit platform.
>
> Unfortunately the reports use a custom data source that is ODBC with a DSN
> pointing to the Access Database.
>
> When we try to run the report, we get the following error….
>
>
> An error has occurred during report processing. (rsProcessingAborted)
>
> Cannot create a connection to data source 'Calendar'.
> (rsErrorOpeningConnection)
>
> ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an
> architecture mismatch between the Driver and Application
>
>
> The issue appears to be that the ODBC drivers needed for Access are 32 bit
> and can only be accessed via the C:\Windows\SysWOW64 folder and SRS appears
> to only see the ODBC drivers in the C:\Windows\System32 folder.
>
> Does anyone know how to get an SRS Report running on a 64 bit version of SRS
> to connect to a Microsoft 2007 Access database using the correct ODBC
> drivers?
>
From: Klaus Sobel [MS] on 2 Feb 2010 04:09
Hi Jack,

there isn't any 64bit ODBC driver for ACCESS.

You have 2 possibilities

Run SSRS in 32

Install SQL EXPRESS 32 bit and create a Linked Server to your ACCESS database.
Then you connect to the SQL EXPRESS Linked Server.

Best Regards

Klaus Sobel [MS]

"Jack Bender" wrote:

> Correction, it is SQL & SRS, both are SQL Server 2005 Developer Edition on SP3
>
> "Jack Bender" wrote:
>
> > I have an Access database that we use to grab data for an SRS report. We
> > just recently upgraded SQL & SRS to a new machine that is 64 bit and both SQL
> > and SRS are now running on a 64 bit platform.
> >
> > Unfortunately the reports use a custom data source that is ODBC with a DSN
> > pointing to the Access Database.
> >
> > When we try to run the report, we get the following error….
> >
> >
> > An error has occurred during report processing. (rsProcessingAborted)
> >
> > Cannot create a connection to data source 'Calendar'.
> > (rsErrorOpeningConnection)
> >
> > ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an
> > architecture mismatch between the Driver and Application
> >
> >
> > The issue appears to be that the ODBC drivers needed for Access are 32 bit
> > and can only be accessed via the C:\Windows\SysWOW64 folder and SRS appears
> > to only see the ODBC drivers in the C:\Windows\System32 folder.
> >
> > Does anyone know how to get an SRS Report running on a 64 bit version of SRS
> > to connect to a Microsoft 2007 Access database using the correct ODBC
> > drivers?
> >
 | 
Pages: 1
Prev: What string to pass in URL to open report viewer in a new window?
Next: Jump To URL issue