No support for 64 bit really stinks. I wonder what will happen when the Office 2010 64 bit version comes out.

If you do not change your SSRS server then...

I followed the instructions, however by enabling the 32 bit it disables Reporting Service page.

Thank you

Gift Peddie (6/18/2009)

---

The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder

you need to create a new application configured to run as x86 in IIS 7...

Gift Peddie (6/11/2009)

---

If you are in Win2003 IIS6 needs to run in 32bits mode because by using x86 Excel you reports must run in x86 mode which means IIS6 must...

Hello,

Yes I created a 32-Bit DSN on the server. The problem is the Report Server appears not to want to use it.

I could be wrong, but from the error "ERROR [IM002]", it appears that you need to use the correct ODBC connection for the applicaiton.

32-bit applications will only see a DSN...

Are you runing on a 64 bit OS?

Do you create your ODBC as a System DSN?

Or did you create one using C:\Windows\SysWOW64\odbcad32.exe

thank you, I will give Report Server a go.

Thank you, that was helpfull.

Both databases are set to SQL_Latin1_General_CP1_Cl_AS. So it must be remembering last created or something.

Thank you.

sorry for not being clear. Here is my puzzle, I have two 2005 databases in two different instances. In one database if I right click and select New...

So all you would need is?

BACKUP DATABASE [TEST] TO DISK = N’D:\BACKUP\TEST.BAK WITH INIT

or

BACKUP DATABASE [TEST] TO DISK = N’D:\BACKUP\TEST.BAK WITH NOINIT

Ahh, but why are they added by the built in tools?

Thank you,

Mr or Mrs. 500

I created this "exec sp_executesql" as you sugested and it looks good. but how do you get a Apostrophe in? I tried ''' ? I need one...